DEV Community

Sriharsha Vemuri
Sriharsha Vemuri

Posted on

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

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

Top comments (1)

Collapse
 
mrvemuri profile image
Sriharsha Vemuri

SCD implementation