question Re: Hive- Convert all values for a column to a comma separated string. in Support Questions

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

rmy1712 — Fri, 25 Aug 2017 03:28:30 GMT

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

dineshc — Fri, 25 Aug 2017 03:38:44 GMT

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".

rmy1712 — Fri, 25 Aug 2017 05:12:19 GMT

Thank you..!!

It worked.