Concat single column fields using GROUP BY

Question

Is there any way to combine/concat the fields within one column by grouping them. Eg:

col1   col2
1     aa
1     bb
1     cc
2     dd
2     ee

I want to query something like :

select col1, concat(col2) from tableName group by col1;

Output should be :

1    aa,bb,cc
2    dd,ee

Is there any function in hive to do this ?

Answer 1

you can use concat_ws() and collect_list() to achieve this....

Something like

select id , concat_ws(",", collect_list(val)) from test group by id; 

"," is the seperator in the above query.