[ https://issues.apache.org/jira/browse/HIVE-581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhenxiao Luo updated HIVE-581: ------------------------------ Attachment: HIVE-581.2.patch.txt > 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 > 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira