[
https://issues.apache.org/jira/browse/HIVE-1683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16138203#comment-16138203
]
Alfonso Nishikawa commented on HIVE-1683:
-----------------------------------------
For anyone reaching this comments, it is possible to set the group by position
(not by alias, but in much cases will be enough) configuring {{set
hive.groupby.orderby.position.alias=true;}}.
>From [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+GroupBy]
>:
bq. In groupByExpression columns are specified by name, not by position number.
However in Hive 0.11.0 and later, columns can be specified by position when
configured as follows:
For Hive 0.11.0 through 2.1.x, set hive.groupby.orderby.position.alias to
true (the default is false).
For Hive 2.2.0 and later, set hive.groupby.position.alias to true (the
default is false).
> Column aliases cannot be used in a group by clause
> --------------------------------------------------
>
> Key: HIVE-1683
> URL: https://issues.apache.org/jira/browse/HIVE-1683
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Reporter: Shrikrishna Lawande
> Labels: SQL
>
> Column aliases cannot be used in a group by clause
> Following query would fail :
> select col1 as t, count(col2) from test group by t;
> FAILED: Error in semantic analysis: line 1:49 Invalid Table Alias or Column
> Reference t
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
