I need to concat string values row wise with '~' as delimiter. I have the following data:
I need to concat 'Comment' column for each 'id' in the ascending order of 'row_id' with '~' as delimiter.
Expected output is as below:
GROUP_CONCAT
is not an option since its not recognized in my Hive version.
I can use collect_set
or collect_list
, but I won't be able to insert delimiter in between.
Is there any workaround?