
+
Mix Nin 20130301, 22:28
+
Vitalii Tymchyshyn 20130302, 08:38
+
Mix Nin 20130302, 00:32

Re: Parse data with multiple delimiters and transpose rows and columns
Hi, Mix:
Looks like you want to use all nonletter character as delimiter to parse the data, It sound like the same issue as http://mailarchives.apache.org/mod_mbox/piguser/201209.mbox/%[EMAIL PROTECTED]%3E Please correct me if I am wrong. I don't think it is supported. But if you can write a UDF to preprocess 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 > 

