[
https://issues.apache.org/jira/browse/HIVE-581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388043#comment-14388043
]
Lefty Leverenz commented on HIVE-581:
-------------------------------------
Doc note: This added configuration parameter
*hive.groupby.orderby.position.alias* to HiveConf.java in release 0.11.0. It
is documented in the wiki here:
* [hive.groupby.orderby.position.alias |
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.groupby.orderby.position.alias]
* [Group By Syntax |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+GroupBy#LanguageManualGroupBy-GroupBySyntax]
* [Order By Syntax |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#LanguageManualSortBy-SyntaxofOrderBy]
> improve group by syntax
> -----------------------
>
> Key: HIVE-581
> URL: https://issues.apache.org/jira/browse/HIVE-581
> Project: Hive
> Issue Type: Improvement
> Components: Clients, Query Processor
> Reporter: Larry Ogrodnek
> Assignee: Zhenxiao Luo
> Labels: features
> Fix For: 0.11.0
>
> Attachments: HIVE-581.1.patch.txt, HIVE-581.2.patch.txt
>
>
> It would be nice if group by allowed either column aliases or column position
> (like mysql).
> It can be burdensome to have to repeat UDFs both in the select and in the
> group by.
> e.g. instead of:
> select f1(col1), f2(col2), f3(col3), count(1) group by f1(col1), f2(col2),
> f3(col3);
> it would allow:
> select f1(col1), f2(col2), f3(col3), count(1) group by 1, 2, 3;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
