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

[Zhenxiao Luo (JIRA)]

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