How create surogate key in Impala?

[#1]

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?

[#2 · Accepted solution]

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

[#3]

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