improve group by syntax
-----------------------
Key: HIVE-581
URL: https://issues.apache.org/jira/browse/HIVE-581
Project: Hadoop Hive
Issue Type: Improvement
Components: Clients, Query Processor
Reporter: Larry Ogrodnek
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.
-
You can reply to this email to add a comment to the issue online.