[
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.
