You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Raihan Jamal (JIRA)" <ji...@apache.org> on 2012/07/05 22:19:33 UTC

[jira] [Created] (HIVE-3233) Error in semantic analysis:Invalid Table Alias

Raihan Jamal created HIVE-3233:
----------------------------------

             Summary: Error in semantic analysis:Invalid Table Alias
                 Key: HIVE-3233
                 URL: https://issues.apache.org/jira/browse/HIVE-3233
             Project: Hive
          Issue Type: Bug
            Reporter: Raihan Jamal
            Priority: Minor


When I am trying to do this query I always get Semantic Analysis error-

hive> SELECT COUNT(*) FROM DW_CHECKOUT_TRANS JOIN PDS_ATTRIBUTE_DATA_REALTIME ON (DW_CHECKOUT_TRANS.BUYER_ID = PDS_ATTRIBUTE_DATA_REALTIME.UID);
    FAILED: Error in semantic analysis: line 1:76 Invalid Table Alias DW_CHECKOUT_TRANS

But when I add table alias name infront of Table then it starts working? why is it so? Below query works fine.

SELECT COUNT(*) FROM DW_CHECKOUT_TRANS CO JOIN PDS_ATTRIBUTE_DATA_REALTIME PDS ON (CO.BUYER_ID = PDS.UID);

--
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

[jira] [Updated] (HIVE-3233) Error in semantic analysis:Invalid Table Alias

Posted by "Raihan Jamal (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raihan Jamal updated HIVE-3233:
-------------------------------

    Priority: Major  (was: Minor)
    
> Error in semantic analysis:Invalid Table Alias
> ----------------------------------------------
>
>                 Key: HIVE-3233
>                 URL: https://issues.apache.org/jira/browse/HIVE-3233
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Raihan Jamal
>
> When I am trying to do this query I always get Semantic Analysis error-
> hive> SELECT COUNT(*) FROM DW_CHECKOUT_TRANS JOIN PDS_ATTRIBUTE_DATA_REALTIME ON (DW_CHECKOUT_TRANS.BUYER_ID = PDS_ATTRIBUTE_DATA_REALTIME.UID);
>     FAILED: Error in semantic analysis: line 1:76 Invalid Table Alias DW_CHECKOUT_TRANS
> But when I add table alias name infront of Table then it starts working? why is it so? Below query works fine.
> SELECT COUNT(*) FROM DW_CHECKOUT_TRANS CO JOIN PDS_ATTRIBUTE_DATA_REALTIME PDS ON (CO.BUYER_ID = PDS.UID);

--
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