Hive- Convert all values for a column to a comma separated string.

[#1]

Select name, city from people;

The above query results:

jon Atlanta

jon Newyork

snow LA

snow DC

But i want the result as a single row as follows:

jon Atlanta,Newyork

snow LA,DC

[#2 · Accepted solution]

You can use the collect_set UDAF function in hive.

select name, collect_set(city) from people group by name;

collect_Set will remove all duplicates.

If you need the duplicates then you must use "collect_list".

Read here for official documentation and details.

[#3]

Thank you..!!

It worked.