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.

Reply via email to