Wu Qinlong created HIVE-15874:
---------------------------------
Summary: Invalid position alias in Group By when CBO failed
Key: HIVE-15874
URL: https://issues.apache.org/jira/browse/HIVE-15874
Project: Hive
Issue Type: Bug
Components: CBO
Affects Versions: 1.2.1
Reporter: Wu Qinlong
for example：
SELECT 2017 as column_1,cloumn_2 from table GROUP BY 1,2 ;
error info:
FAILED: SemanticException [Error 10220]: Invalid position alias in Group By
Position alias: 2017 does not exist
The Select List is indexed from 1 to 2
the first process Position Alias result:
SELECT 2017 as column_1,cloumn_2 from table GROUP BY 2017,cloumn_2 ;
when CBO is enabled and CBO optimize failed, Position Alias will be processed
one more time , this lead to '2017' out of the column range
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
