topic Re: Using FOR XML RAW in Spark SQL in Data Engineering

Using FOR XML RAW in Spark SQL

AzaharNadaf — Wed, 27 Dec 2023 05:26:26 GMT

How can I convert below SQL server query to spark SQL

Query - SELECT distinct HashBytes('md5', (SELECT a, b, c for xml raw)) as xyzzy FROM table name

Need help here community 🙂

AzaharNadaf — Wed, 27 Dec 2023 06:57:22 GMT

Also need to find out here how to use multiple columns in md5 function as above

AzaharNadaf — Wed, 03 Jan 2024 06:53:05 GMT

The Idea here was to create a unique id based upon the number of columns,

I have used dense Rank to resolve this issue

Thanks