https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/353719#M236773 <P>How create function SURROGATE_KEY()?.&nbsp;I note that it would be necessary to install a package to perform the function in Impala</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kaviana_0-1664497801843.png" style="width: 999px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/35795i5BB5A73CE5747D87/image-size/large?v=v2&amp;px=999" role="button" title="Kaviana_0-1664497801843.png" alt="Kaviana_0-1664497801843.png" /></span></P><P>&nbsp;</P> Fri, 30 Sep 2022 00:30:42 GMT Kaviana 2022-09-30T00:30:42Z https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/352752#M236594 <P>I would like to know how is the best way to create surrogate key or SK in Impala. If there is no UDF function <STRONG>SURROGATE_KEY().</STRONG> How could I do?</P> Tue, 20 Sep 2022 23:22:25 GMT https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/352752#M236594 Kaviana 2022-09-20T23:22:25Z https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/353249#M236669 <P>Hi ,</P><P>&nbsp;</P><P>There seems to be a UDF present for SK in Hive, Have you tried this? Is it Working?</P><P><A href="https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-hiveql/topics/hive_surrogate_keys.html" target="_blank">https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-hiveql/topics/hive_surrogate_keys.html</A></P><P>&nbsp;</P><P>Regards,</P><P>Chethan YM</P> Sun, 25 Sep 2022 05:12:06 GMT https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/353249#M236669 ChethanYM 2022-09-25T05:12:06Z https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/353719#M236773 <P>How create function SURROGATE_KEY()?.&nbsp;I note that it would be necessary to install a package to perform the function in Impala</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kaviana_0-1664497801843.png" style="width: 999px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/35795i5BB5A73CE5747D87/image-size/large?v=v2&amp;px=999" role="button" title="Kaviana_0-1664497801843.png" alt="Kaviana_0-1664497801843.png" /></span></P><P>&nbsp;</P> Fri, 30 Sep 2022 00:30:42 GMT https://community.cloudera.com/t5/Support-Questions/How-create-surogate-key-in-Impala/m-p/353719#M236773 Kaviana 2022-09-30T00:30:42Z