[HIVE-3472] Build An Analytical SQL Engine for MapReduce

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.10.0
• Assignee: Unassigned
• Reporter: Shane Huang
• Created: 17/Sep/12 09:46
• Updated: 25/Dec/13 12:15

Description

While there are continuous efforts in extending Hive’s SQL support (e.g., see some recent examples such as HIVE-2005 and HIVE-2810), many widely used SQL constructs are still not supported in HiveQL, such as selecting from multiple tables, subquery in WHERE clauses, etc.

We propose to build a SQL-92 full compatible engine (for MapReduce based analytical query processing) as an extension to Hive.

The SQL frontend will co-exist with the HiveQL frontend; consequently, one can mix SQL and HiveQL statements in their queries (switching between HiveQL mode and SQL-92 mode using a “hive.ql.mode” parameter before each query statement). This way useful Hive extensions are still accessible to users.

Issue Links

• is related to: HIVE-1386 HiveQL SQL Compliance (Umbrella)

Sub-Tasks

• Build a full SQL-compliant parser for Hive: Open
• Subquery Unnesting: Open
• Multiple-table selection support: Open
• add Date data type: Closed