[HIVE-3542] Can not use DB Qualified Name in Order By, Sort By, Distribute By, and Cluster By

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: Query Processor
• Assignee: Zhenxiao Luo
• Reporter: Zhenxiao Luo
• Created: 06/Oct/12 05:10
• Updated: 19/Dec/12 06:30

Description

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

Issue Links

• relates to: HIVE-2228 Can't use DB qualified column names in WHERE or GROUP BY clauses