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