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.

Reply via email to