hadoop - Hive Query to group by id -

i have table in hive

id|name

1 "a"

2 "b"

1 "c"

i want output of query

1 "a,b"

2 "c"

according id must group name how can achieve above in hive?,is there built-in function in hive this? pointers of great help

regards,

as far understood looking kind of group_concat(sql function) in hive ...

you can achieve same functionality select id , collect_set(name) tblname group id.