D2
A B4 D4
A B5 D5
A B6 D6
From: Lunagariya, Dhaval [mailto:dhaval.lunagar...@citi.com]
Sent: Wednesday, June 08, 2016 6:25 PM
To: 'user@hive.apache.org'
Cc: 'er.dcpa...@gmail.com'
Subject: RE: Need Your Inputs For Below Scenario
Here Table2 is very
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
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
D
