Question: how to find difference between 2 tables in hive?
Answer: Control_table, with known data. New_table, with data to check. Result_table, table where records with different values in new_table then control_table are inserted to.