Hi, Mix: Looks like you want to use all non-letter character as delimiter to parse the data, It sound like the same issue as http://mail-archives.apache.org/mod_mbox/pig-user/201209.mbox/%3ccae7pyjyrsewmsgrv9jesy44g2mnn7rcj1t1avmn5xwo97qz...@mail.gmail.com%3E
Please correct me if I am wrong. I don't think it is supported. But if you can write a UDF to pre-process the data a little bit then call Pig load command, it should work. Johnny On Fri, Mar 1, 2013 at 4:32 PM, Mix Nin <[email protected]> wrote: > *Hi * > * > * > *I have a file that has data as follows * > * > **AA*:11,22,33;*BB*:144,244,344;*CC*:yny;*DD*:11,33;*EE*:144,344 ; 11111 > > I need output as follows. How do I write PIG script for this > > > > Event key > > AA > > BB > > CC > > 11111 > > 11 > > 144 > > y > > 11111 > > 22 > > 244 > > n > > 11111 > > 33 > > 344 > > y >
