[jira] Resolved: (HIVE-289) superfluous parenthesis break queries

["Zheng Shao (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-289?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao resolved HIVE-289.
-----------------------------

    Resolution: Won't Fix

This seems easy enough for users. We should try to stick to SQL grammar.
By the way, sub-query alias is required.

> superfluous parenthesis break queries
> -------------------------------------
>
>                 Key: HIVE-289
>                 URL: https://issues.apache.org/jira/browse/HIVE-289
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: S. Alex Smith
>
> Queries like"from (my_table) select *;" break.
> This has a deleterious effect on automated query construction.  In particular, the following works well:
> "FROM %s <do something complicated>" % "my_table"
> "FROM %s <do something complicated>" % "(FROM my_other_table SELECT my_row WHERE my_table.ds='2009-02-13')"
> but if extra parenthesis were correctly ignored, the following would also work:
> "FROM (%s) <do something complicated>" % "my_table"
> "FROM (%s) <do something complicated>" % "FROM my_other_table SELECT my_row WHERE my_table.ds='2009-02-13'"
> which would allow a much more convenient and generic nesting of queries.

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