You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/10/08 03:24:34 UTC

[jira] [Commented] (HIVE-8388) Support GROUP/ORDER BY column references by ordinal position

    [ https://issues.apache.org/jira/browse/HIVE-8388?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14162906#comment-14162906 ] 

Navis commented on HIVE-8388:
-----------------------------

Duplicates HIVE-494.

> Support GROUP/ORDER BY column references by ordinal position
> ------------------------------------------------------------
>
>                 Key: HIVE-8388
>                 URL: https://issues.apache.org/jira/browse/HIVE-8388
>             Project: Hive
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: John Scheibmeir
>            Assignee: Gunther Hagleitner
>            Priority: Minor
>
> Allow user to reference the group by or order by column by the desired column's ordinal position
> Support syntax such as:
> select t.col1, sum(t.col2) from my_table t group by 1 order by 1



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)