Question

Hadoop Hive How to convert multiple rows into comma separated values

Answer 1

You can use the aggregator function collect_set to do this. Example:

SELECT Col1, collect_set(Col2)
FROM your_table
GROUP BY Col1;