pig-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raviv M-G <ravi...@post.harvard.edu>
Subject GROUP_CONCAT function
Date Tue, 06 Jul 2010 20:31:05 GMT
Hi all,

Is there a way to use the built-in functions of Pig (or has someone
already written a UDF) to create a similar result to SQL's
GROUP_CONCAT?

The idea is that I have a long list of book ISBN numbers and author names:

123    John Doe
123    Jane Doe

and I would like to be able to group by the ISBN number and then
concatenate them for export to the format:

123    John Doe; Jane Doe

Thanks,
Raviv

Mime
View raw message