Deepesh Khandelwal created HIVE-7693: ----------------------------------------
Summary: Invalid column ref error in order by when using column alias in select clause and using having Key: HIVE-7693 URL: https://issues.apache.org/jira/browse/HIVE-7693 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.13.0 Reporter: Deepesh Khandelwal Hive CLI session: {noformat} 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) {noformat} Without having clause, the query runs fine, example: {code} select foo as c0, count(*) as c1 from abc group by foo, bar order by foo; {code} -- This message was sent by Atlassian JIRA (v6.2#6252)