The latest articles on DEV Community by Sriharsha Vemuri (@mrvemuri). https://dev.to/mrvemuri https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F231457%2Fe8f1a5c1-3780-4ca9-9212-337e9a64930f.jpg https://dev.to/mrvemuri en Sriharsha Vemuri Tue, 17 Sep 2019 18:08:47 +0000 https://dev.to/mrvemuri/answer-slowly-changing-dimensions-scd1-and-scd2-implementation-in-hive-1l6k https://dev.to/mrvemuri/answer-slowly-changing-dimensions-scd1-and-scd2-implementation-in-hive-1l6k <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pTF_nE4a--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/37472146/slowly-changing-dimensions-scd1-and-scd2-implementation-in-hive/57718516#57718516" rel="noopener noreferrer"> <span class="title-flare">answer</span> re: Slowly changing dimensions- SCD1 and SCD2 implementation in Hive </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Aug 29 '19</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/37472146/slowly-changing-dimensions-scd1-and-scd2-implementation-in-hive/57718516#57718516" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--5MiFESHx--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 0 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Rk_a5QFN--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://practicaldev-herokuapp-com.freetls.fastly.net/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <pre><code>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</code></pre>… </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/37472146/slowly-changing-dimensions-scd1-and-scd2-implementation-in-hive/57718516#57718516" rel="noopener noreferrer">Open Full Answer</a> </div> </div>