[HIVE-3107] Improve semantic analyzer to better handle column name references in group by/sort by clauses

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0, 0.10.0, 0.11.0, 0.12.0
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Harish Butani
• Reporter: Richard Ding
• Created: 09/Jun/12 00:40
• Updated: 08/Oct/14 13:28
• Resolved: 19/Nov/13 17:25

Description

This is related to HIVE-1922.

Following queries all fail with various SemanticExceptions:

explain select t.c from t group by c;
explain select t.c from t group by c sort by t.c; 
explain select t.c as c0 from t group by c0;
explain select t.c from t group by t.c sort by t.c; 

It is true that one could always find a version of any of above queries that works. But one has to try to find out and it doesn't work well with machine generated SQL queries.

Issue Links

• is depended upon by: HIVE-5614 Subquery support: allow subquery expressions in having clause
• is related to: HIVE-8398 ExprNodeColumnDesc cannot be cast to ExprNodeConstantDesc