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.