Skip to main content
Kaviana
Silver ⭐️
September 20, 2022
Solved

How create surogate key in Impala?

I would like to know how is the best way to create surrogate key or SK in Impala. If there is no UDF function SURROGATE_KEY(). How could I do?

ChethanYM
ChethanYMAnswer
Gold ⭐️
September 25, 2022

Hi ,

 

There seems to be a UDF present for SK in Hive, Have you tried this? Is it Working?

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-hiveql/topics/hive_surrogate_keys.html

 

Regards,

Chethan YM

2 replies

ChethanYM
Gold ⭐️
ChethanYMAnswer
Gold ⭐️
September 25, 2022

Hi ,

 

There seems to be a UDF present for SK in Hive, Have you tried this? Is it Working?

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-hiveql/topics/hive_surrogate_keys.html

 

Regards,

Chethan YM

Translate
Kaviana
KavianaAuthor
Silver ⭐️
September 30, 2022

How create function SURROGATE_KEY()?. I note that it would be necessary to install a package to perform the function in Impala

Kaviana_0-1664497801843.png

 

Translate