[jira] Commented: (HIVE-94) re-factor Hive grammar to be more human readable

["Raghotham Murthy (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-94?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12652602#action_12652602 ] 

Raghotham Murthy commented on HIVE-94:
--------------------------------------

I had added the HiveQL syntax a while back on the wiki.

http://wiki.apache.org/hadoop/Hive/HiveQL

It might need some updating based on the changes to the syntax.

> re-factor Hive grammar to be more human readable
> ------------------------------------------------
>
>                 Key: HIVE-94
>                 URL: https://issues.apache.org/jira/browse/HIVE-94
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Documentation, Query Processor
>            Reporter: Pete Wyckoff
>
> Hive.g grammar specification could be re-factored to look more friendly. 
> MySQL's select statement looks like this on the docs page and presumably, their grammar is similar.
> {noformat}
> SELECT
>     [ALL | DISTINCT | DISTINCTROW ]
>       [HIGH_PRIORITY]
>       [STRAIGHT_JOIN]
>       [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
>       [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
>     select_expr, ...
>     [FROM table_references
>     [WHERE where_condition]
>     [GROUP BY {col_name | expr | position}
>       [ASC | DESC], ... [WITH ROLLUP]]
>     [HAVING where_condition]
>     [ORDER BY {col_name | expr | position}
>       [ASC | DESC], ...]
>     [LIMIT {[offset,] row_count | row_count OFFSET offset}]
>     [PROCEDURE procedure_name(argument_list)]
>     [INTO OUTFILE 'file_name' export_options
>       | INTO DUMPFILE 'file_name'
>       | INTO var_name [, var_name]]
>     [FOR UPDATE | LOCK IN SHARE MODE]]
> {noformat}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.