Rows to column with comma separated

How about using group_concat UDx in Vertica.

Example usage :

create table test_comma_concat
(col1 varchar)

insert into test_comma_concat values('a');
insert into test_comma_concat values('b');
insert into test_comma_concat values('c');
insert into test_comma_concat values('d');

select * from test_comma_concat

Using group_concat function :

nnani=> select group_concat(col1) over () from test_comma_concat;
    list
------------
 b, d, a, c
(1 row)

You can get this UDx from Vertica Marketplace

Hi Navin,

I am unable to get group_concat UDx in Vertica.

Can you please download and send that to me here as an attachment.

Hi,

  You can download the strings_package from the URL https://github.com/vertica/Vertica-Extension-Packages/tree/master/strings_package

Group_concat is present in strins_package. Instructions on how to install package are present in the above given URL.

-Regards,

 Sruthi