Does OD or Spark autocasts non-string type values to string when using the CONCAT_WS function?
Also where would i learn more about the autocast behavior?
I can use the CONAT_WS spark function in a query processor with different non-string types.
SELECT CONCAT_WS(' ,', i.a, i.b, i.c) as my_new_string from InputTable i
where a is of type BigInt, b of Datetime and c of string.
The spark doc however states:
Returns the concatenation of the strings separated
Motivation: I need to now if SHA2(my_new_string, 256) can create unwanted collisions due to non injective behavior in the autocast.