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
