Hive 0.11, Stinger and SQL-Compatibility
The release of Hive 0.11 is exciting and represents a big step forward to delivery of Project Stinger and SQL-IN-Hadoop. There is still some work to be done however. We look forward to delivery of Hadoop 2 with YARN and the Apache Tez project as being huge increases to Hive performance, but this is not the only goal of Stinger.
SQL-In-Hadoop simply can’t be SQL without SQL compatibility
Today, HiveQL provides a fairly good set of SQL data types and semantics and while this (or a subset thereof) may be good enough for some of the “on” Hadoop solutions, we feel there needs to be more, especially if Hadoop and Hive are to meet the stringent requirements of enterprise class business analytics. To this end, we have set a goal of compatibility with most of SQL-92 and beyond with some SQL-2003 extensions.…