Skip to main content
Kaviana
Silver ⭐️
Sep 20, 2022 11:22 PM UTC
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 ⭐️
Sep 25, 2022 5:12 AM UTC

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 ⭐️
Sep 25, 2022 5:12 AM UTC

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 ⭐️
Sep 30, 2022 12:24 AM UTC

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