see if "BagToString" helps you
https://svn.apache.org/repos/asf/pig/trunk/src/org/apache/pig/builtin/BagToString.java
*Cheers !!*
Arvind
On Fri, Aug 28, 2015 at 3:05 AM, Simha G <hadoopsi...@gmail.com> wrote:
> Hi Team,
>
> I have a source data like below,
>
>
> {(03-07-2011),(03-07-2011)},{(Jackson),(Jackson)},{(Mississippi),(Mississippi)},{(Team
> Sports),(Team Sports)},{(credit),(credit)}
> {(11-14-2011),(11-14-2011)},{(Des Moines),(Des
> Moines)},{(Iowa),(Iowa)},{(Outdoor Play Equipment),(Outdoor Play
> Equipment)},{(credit),(credit)}
>
> And i want the data in tupples, I tried like below
>
> mydata = load '/user/flatendata' USING PigStorage(',') as (id:chararray,
> name:chararray, lastname:chararray, hobby:chararray, city:chararray);
>
> flatted = foreach mydata genereate flatten(id), flatten(name),
> flatten(lastname), flatten(hobby);
>
> but i am getting below output ,
>
> ({(03-07-2011),(03-07-2011)},{(Jackson),(Jackson)})
> ({(11-14-2011),(11-14-2011)},{(Des Moines),(Des Moines)})
>
>
> Could you please suggest me how to get the below flatten data.
>
> (03-07-2011,03-07-2011,Jackson,Jackson,Mississippi,Mississippi,Team
> Sports,Team Sports,credit,credit)
> (11-14-2011,11-14-2011,Des Moines,Des Moines,Iowa,Iowa,Outdoor Play
> Equipment,Outdoor Play Equipment,credit,credit)
>
>
> Thanks,
> Narasimha
>
