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)