hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Ogrodnek (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-581) improve group by syntax
Date Wed, 24 Jun 2009 22:30:07 GMT
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.

View raw message