Reply
New Contributor
Posts: 2
Registered: ‎01-13-2018

deletion of old data and insert new data in hive table

ABCDKey
1546100
5687200
5632300
8965400

I have loaded  the above table with a file in hive, next day I got new file(below) with some changes in the data(highlighted in yellow colour) 

abcdKey
50302010100
6795200
10203040300

 

now I want to load the only the change(yellow one) data in my final table and all other existing data should delete

 

my final table would look like:

 

ABCDKey
50302010100
10203040300

  

 

Please help me with the logic

Announcements