How to achieve SCD2 on hive tables in Talend

[Anonymous]

Hi All,

I'm trying to understand how to acheive scd2 type for hive tables using Talend.

Can anyone help me understand.

Thanks.

[vapukov]

Hi,

since Hive does not support UPDATES, you could follow:

https://community.hortonworks.com/questions/113155/best-and-easy-way-to-implement-and-create-scd2-in...

http://dwgeek.com/impala-hive-slowly-changing-dimension-scd-type-2.html/

https://hortonworks.com/blog/update-hive-tables-easy-way-2/

in case if you use Cloudera - you can use Impala tables with Kudu as storage for SQL access

regards

[Anonymous · Accepted solution]

Thanks! 

I was able to do it.