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.

How to update the data from one table to another table Hive

Highlighted

How to update the data from one table to another table Hive

Explorer

In my hive DB i have two tables those are (table1)source and (table2)destination table 

and we created table2 as orc table with bucketing and transactional enable table to perform update and delete,

but table1 is managed table with test format table.

 

While creating the table1 i am creating the hash_diff for all the columns and storing it as seperate column in the table for checking the difference between two tables.

 

Hive is not supporting for subqueries in update.

 

If the the hash diff is not same, i need to update the entire row into another table, but not able to do this 

 

Can you guide me how to achieve this.