hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Thusoo (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-729) select expression with optional "as"
Date Thu, 06 Aug 2009 20:44:15 GMT

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

Ashish Thusoo commented on HIVE-729:
------------------------------------

I think it is safe to change this test. Since the column alias is optional the statement treats
the second expression as a column alias due to the lack of , and since this expression is
not an identifier it barfs. What do you think? I can generate a new patch that has Zheng's
fixes and the test output update.


> select expression with optional "as"
> ------------------------------------
>
>                 Key: HIVE-729
>                 URL: https://issues.apache.org/jira/browse/HIVE-729
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>            Priority: Minor
>             Fix For: 0.4.0
>
>         Attachments: HIVE-729.1.patch
>
>
> "as" should be optional in select expression. Query like the following should work:
> {code}
> SELECT a, b FROM (
>   SELECT key a, value b
>   FROM src
> ) src1
> ORDER BY a LIMIT 1;
> {code}

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


Mime
View raw message