CODEWITHSUNDEEP
redhat-datavirt
Norbert Funke
Norbert Funke

Reputation: 81

is there a function to concatenate all columns in teiid?

I am trying to do a checksum for change detection on rows, so I can compare 2 tables. One way I have done in the past is by concatenation of all columns and then do a hash. How can I concat all columns?

SELECT concat(*) form TABLE;

does not work

I also tried the PostgreSQL variant of

select r::text from sandbox.abs_frmt r;

Upvotes: 0

Views: 143

Answers (1)

Steven Hawkins
Steven Hawkins

Reputation: 588

By default string lengths are limited, so it's probably best to do the hash of each column and use a function to combine the hashes.

If you don't have a concern with the size of the concatted value, the closest built-in logic would be to use jsonArray, jsonObject, or xmlforest to create a single vale that represents a row - jsonArray may be preferable as it will just be the values, no names:

select sha2_256(cast(jsonArray(col1, col2, ...) as string)),... from tbl;

Upvotes: 0

Related Questions