[
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
