You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "S. Alex Smith (JIRA)" <ji...@apache.org> on 2009/02/13 21:01:04 UTC

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

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.

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

Posted by "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.