Here Table2 is very large table and contains lakhs of rows. From: Lunagariya, Dhaval [CCC-OT] Sent: Wednesday, June 08, 2016 5:52 PM To: user@hive.apache.org Subject: Need Your Inputs For Below Scenario
Hey folks, Need your help. Input Table1: Column1 Column2 Column3 Column4 Column5 Column6 Column7 A B1 B2 B3(NULL) B4 B5 B6 Input Table2: Column1 Column2 B1 D1 B2 D2 B3 D3 B4 D4 B5 D5 B6 D6 Output: Column1 Column2 Column3 A B1 D1 A B2 D2 A B4 D4 A B5 D5 A B6 D6 Here B3 is skipped because B3 is NULL. What is the efficient way to get above result using Hive? Regards, Dhaval
