[ https://issues.apache.org/jira/browse/HIVE-581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273769#comment-13273769 ]
Namit Jain commented on HIVE-581: --------------------------------- @Steven, the current behavior seems like a bug. I dont think, we should support it. Adding a config for this seems like a bad idea. > 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: Weizhe Shi > Labels: features > > 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira