How calculate a checksum of all the values in a row

Dremio University
1

Hello,

I want to calculate a checksum of all the values in a row of a table in Dremio without naming all the columns.
I don’t want to do : SELECT md5(concat(t.col1, t.col2, t.col3, … )) FROM table t

For other systems, I do the following:

  • Postgresql and DuckDB:
    SELECT md5(t::text) FROM table t
    or SELECT md5(row_to_json(t)) FROM table t

  • Spark SQL:
    spark.sql(“SELECT md5(concat(t.*)) FROM table t”)

Is it possible to do this in Dremio?