Zhenxiao Luo created HIVE-3542: ---------------------------------- Summary: Can not use DB Qualified Name in Order By, Sort By, Distribute By, and Cluster By Key: HIVE-3542 URL: https://issues.apache.org/jira/browse/HIVE-3542 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 0.9.0 Reporter: Zhenxiao Luo Assignee: Zhenxiao Luo Fix For: 0.10.0
CREATE DATABASE db1; CREATE TABLE db1.t(a INT, b INT); SELECT * FROM db1.t ORDER BY db1.t.a; FAILED: SemanticException [Error 10004]: Line 3:29 Invalid table alias or column reference 'db1': (possible column names are: a, b) SELECT * FROM db1.t SORT BY db1.t.a; FAILED: SemanticException [Error 10004]: Line 3:28 Invalid table alias or column reference 'db1': (possible column names are: a, b) SELECT * FROM db1.t CLUSTER BY db1.t.a; FAILED: SemanticException [Error 10004]: Line 3:31 Invalid table alias or column reference 'db1': (possible column names are: a, b) SELECT * FROM db1.t DISTRIBUTE BY db1.t.a; FAILED: SemanticException [Error 10004]: Line 3:34 Invalid table alias or column reference 'db1': (possible column names are: a, b) alias is working OK: SELECT * FROM db1.t t ORDER BY t.a; OK SELECT * FROM db1.t t SORT BY t.a; OK SELECT * FROM db1.t t CLUSTER BY t.a; OK SELECT * FROM db1.t t DISTRIBUTE BY t.a; OK -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira