-
Re: Parse data with multiple delimiters and transpose rows and columnsJohnny Zhang 2013-03-02, 00:45
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/%[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 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
>
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/%[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 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
>
