Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How create surogate key in Impala?

avatar
Explorer

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?

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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

View solution in original post

2 REPLIES 2

avatar
Super Collaborator

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

avatar
Explorer

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