We need to create a unique identifier for each entry, we currently use newid() on our SQL Server.
Since Dremio does not support this, can you please give us an alternate solution that is supported by Dremio.
Thanks
We need to create a unique identifier for each entry, we currently use newid() on our SQL Server.
Since Dremio does not support this, can you please give us an alternate solution that is supported by Dremio.
Thanks
Hi @mgct, what about the undocumented md5 function ?
SELECT MD5('something_to_hash') ==> 1bc29b36f623ba82aaf6724fd3b16718
Have you tried External query feature in 4.8? Should support newid() in the query