John doe works in Google his job there is to keep track of employee’s details of change in project or change in manager and even keep track of the hikes and variable pay changes an employee gets. He ...

STEP2: Select all the records which are not changed from STG and HIST using inner join and filter on HIST.column = STG.column as below hive> select hist.* from emp_hist hist inner join emp_stagg stg ...