[HIVE-3233] Error in semantic analysis:Invalid Table Alias

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Tags: hive
• Assignee: Unassigned
• Reporter: Raihan Jamal
• Created: 05/Jul/12 20:18
• Updated: 06/Feb/13 09:23

Description

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

Issue Links

• is related to: HIVE-3991 junit failure on Semantic Analysis