Repository navigation
0.12.2
Fixes
- Added the
hash_keysystem function to replacehash_columnsfor computing keys from column values.hash_columnsreduces every value to its 32-bit hash code and joins the results without separators. Because of that, distinct rows can get the same key, for example(1, 23, 'x')and(12, 3, 'x'), orNULL,0, and''.ARRAYandBYTESvalues hash by identity, so the same row gets a different key each time it is processed.hash_keyhashes the full content of each value with SHA-256, using Flink's binary row format, which marksNULLvalues explicitly. Likehash_columns, it returns aCHAR(32)hex string. (#427) - Deprecated
hash_columnsin favor ofhash_key. Its output is unchanged, so running pipelines and existing compiled plans keep the same keys. DataSQRL switches tohash_keyin DataSQRL/sqrl#2513. (#427)
Full Changelog: 0.12.1...0.12.2