CODEWITHSUNDEEP
hadoophive
Naga Vemprala
Naga Vemprala

Reputation: 728

hive: Using collect_set with a delimiter

I am trying to use collect_set in a hive query to group the columns on a group by condition. Each row is having spaces as delimiters instead of ',' or something. How to change the delimiter to ',' or any other delimiter in this case?

Thanks in advance.

Regards, Naga Vemprala

Upvotes: 5

Views: 14314

Answers (1)

Jeremy Beard
Jeremy Beard

Reputation: 2725

COLLECT_SET returns an array, with which you can then concatenate the entries into a single comma-separated value using CONCAT_WS:

select serial_num, concat_ws(",", collect_set(customer_lastName)) as concatenate_lastNames from External_Table group by serial_num

Upvotes: 7

Related Questions