hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lianhui Wang (JIRA)" <>
Subject [jira] [Commented] (HIVE-3472) Build An Analytical SQL Engine for MapReduce
Date Tue, 25 Sep 2012 03:00:09 GMT


Lianhui Wang commented on HIVE-3472:

nexr have done some works in oracle sql to hive sql.
the session's address(from page 18):
i think we should transfer the oracle's syntax tree to hive's syntax tree.that maybe easy.
another thing is directly transfer the oracle's sql to hive query play.but i think that need
more time and works.

> Build An Analytical SQL Engine for MapReduce
> --------------------------------------------
>                 Key: HIVE-3472
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.10.0
>            Reporter: Shengsheng Huang
>         Attachments: SQL-design.pdf
> 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,
> 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. 

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message