Migrate from T-SQL CHECKSUM_AGG to Dremio

1

Dear all,

we are currently monitoring changes in a table with a query like the following:

SELECT c1, c2, c3, CHECKSUM_AGG(CHECKSUM(c4, c5, c6)) AS checksum
FROM t1
GROUP BY c1, c2, c3

We weren’t able to find something comparable to CHECKSUM_AGG and were wondering if anyone might have an idea how to solve this in Dremio.

Thanks for reading and any suggestions!
Markus

2

@M.Gross As we check on this, you can try using External query