hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2228) Can't use DB qualified column names in WHERE or GROUP BY clauses
Date Mon, 26 Mar 2012 21:54:26 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Carl Steinbach updated HIVE-2228:
---------------------------------

    Component/s: SQL
                 Database/Schema
    
> Can't use DB qualified column names in WHERE or GROUP BY clauses
> ----------------------------------------------------------------
>
>                 Key: HIVE-2228
>                 URL: https://issues.apache.org/jira/browse/HIVE-2228
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema, Query Processor, SQL
>    Affects Versions: 0.7.0
>            Reporter: Carl Steinbach
>            Assignee: Zhenxiao Luo
>
> 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:
> {noformat}
> 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
> {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message