Answer: Slowly changing dimensions- SCD1 and SCD2 implementation in Hive

answer re: Slowly changing dimensions- SCD1 and SCD2 implementation in Hive

Aug 29 '19

drop table if exists harsha.emp
drop table if exists harsha.emp_tmp1;

drop table if exists harsha.emp_tmp2;

drop table if exists harsha.init_load;

show databases;
use harsha;
show tables;

create table harsha.emp (eid int,ename string,sal int,loc string,dept int,start_date timestamp,end_date timestamp,current_status string)
comment "emp scd implementation"
row format delimited
fields terminated by ','
lines

…