[HIVE-2228] Can't use DB qualified column names in WHERE or GROUP BY clauses

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.7.0
• Component/s: Database/Schema, Query Processor, SQL
• Assignee: Zhenxiao Luo
• Reporter: Carl Steinbach
• Created: 20/Jun/11 22:07
• Updated: 18/Dec/15 20:38

Description

Hive doesn't allow you to use DB qualified column names in the WHERE or GROUP BY clauses. The workaround is to define a table alias:

hive> CREATE DATABASE db1;
OK

hive> CREATE TABLE db1.t(a INT, b INT);
OK

hive> SELECT * FROM db1.t WHERE db1.t.a > 100;
FAILED: Error in semantic analysis: Line 1:26 Invalid table alias or column reference 'db1'

hive> SELECT * FROM db1.t t WHERE t.a > 100;
OK

hive> SELECT * FROM db1.t GROUP BY db1.t.a;
FAILED: Error in semantic analysis: Line 1:29 Invalid table alias or column reference 'db1'

hive> SELECT * FROM db1.t t GROUP BY t.a;
OK

Issue Links

• is related to: HIVE-3542 Can not use DB Qualified Name in Order By, Sort By, Distribute By, and Cluster By
• is related to: HIVE-1977 DESCRIBE TABLE syntax doesn't support specifying a database qualified table name
• is related to: HIVE-1517 ability to select across a database