Hi Rodrigo Ferreira,
Thanks a lot It worked.
On 18 July 2014 15:18, Rodrigo Ferreira <[email protected]> wrote:
> Hi Nivetha, I don't know if I understood it correctly, but I think you can
> just use FLATTEN to "flatten" your bag.
>
> It would become something like:
>
> A = ...
>
> B = FOREACH A GENERATE FLATTEN(YourUDF(input)) AS (description, name, no,
> trans_no);
>
> and then you can access your data normally by just using the name you gave
> in the flatten output schema:
>
> Ex.:
>
> C = FOREACH B GENERATE trans_no, no, name, description;
>
> I hope this helps :)
>
> Rodrigo Ferreira.
>
>
> 2014-07-18 11:33 GMT+02:00 Nivetha K <[email protected]>:
>
> > Hi,
> >
> > I am working with Pig. How to parse XML with nested tags using UDF.I
> > tried with UDF and used List<Tuple> as the return type of the UDF while
> > compiling i get Unexpected data type java.util.ArrayList found in stream.
> > Note only standard Pig type is supported when you output from
> UDF/LoadFunc.
> > So I used bag as the return type , now I am having problem with
> retrieving
> > the fields using Pig .
> >
> > My bag having the tuples where all the tuples having same
> > schema I don't know how to retrive those values.
> >
> > XML:
> >
> >
> >
> >
> <transaction><trans><trans_no>123</trans_no><pkid><pk1><no>10</no><name>nivetha</name></pk1><pk1><no>20</no><name>anu</name></pk1><pk1><no>30</no><name>anitha</name></pk1></pkid><description>Some
> >
> >
> text</description></trans><trans><trans_no>124</trans_no><pkid><pk1><no>90</no><name>nivetha1</name></pk1><pk1><no>80</no><name>anu1</name></pk1><pk1><no>70</no><name>anitha1</name></pk1></pkid><description>Some
> > text</description></trans></transaction>
> >
> > My UDF Output:
> >
> > ({(Some text,nivetha,10,123),(Some text,anu,20,123),(Some
> > text,anitha,30,123)})
> > ({(Some text,nivetha1,90,124),(Some text,anu1,80,124),(Some
> > text,anitha1,70,124)})
> >
> >
> >
> > regards,
> >
> > Nivetha
> >
>
