Table aliases in order by clause lead to semantic analysis failure ------------------------------------------------------------------
Key: HIVE-1449 URL: https://issues.apache.org/jira/browse/HIVE-1449 Project: Hadoop Hive Issue Type: Bug Components: Query Processor Reporter: Ashish Thusoo Assignee: Ashish Thusoo Fix For: 0.7.0 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. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.