[HIVE-7693] Invalid column ref error in order by when using column alias in select clause and using having

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Pengcheng Xiong
• Reporter: Deepesh Khandelwal
• Created: 12/Aug/14 16:31
• Updated: 05/May/16 21:10
• Resolved: 05/May/16 21:10

Description

Hive CLI session:

hive> create table abc(foo int, bar string);
OK
Time taken: 0.633 seconds
hive> select foo as c0, count(*) as c1 from abc group by foo, bar having bar like '%abc%' order by foo;
FAILED: SemanticException [Error 10004]: Line 1:93 Invalid table alias or column reference 'foo': (possible column names are: c0, c1)

Without having clause, the query runs fine, example:

select foo as c0, count(*) as c1 from abc group by foo, bar order by foo;

The above queries run well with CBO on in Hive master. We tested other queries as can be seen in the attachment. The summary is (1) Hive does not allow alias in group by; (2) Hive does not allow alias in having. The problem will appear only when the first query is run with CBO off. However, CBO should be on as default. Thus, we mark it as won't fix.

Issue Links

• links to: RB