Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

deletion of old data and insert new data in hive table

deletion of old data and insert new data in hive table

New Contributor
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

Don't have an account?
Coming from Hortonworks? Activate your account here