[HIVE-1449] Table aliases in order by clause lead to semantic analysis failure

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Ashish Thusoo
• Reporter: Ashish Thusoo
• Created: 02/Jul/10 21:43
• Updated: 17/May/12 19:03

Description

A simple statement of the form

select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by a.account_id;

throws a sematic analysis exception

where as

select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by account_id;

works fine (the second query does not have the table alias a in the order by clause.