[
https://issues.apache.org/jira/browse/HIVE-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-3542:
-----------------------------------
Fix Version/s: (was: 0.10.0)
> 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
>
> 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
