Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Parse data with multiple delimiters and transpose rows and columns


Copy link to this message
-
Re: Parse data with multiple delimiters and transpose rows and columns
You can try reading as single column, then splitting with reg exp and then
flattening.
2 бер. 2013 00:29, "Mix Nin" <[EMAIL PROTECTED]> напис.

> ---------- Forwarded message ----------
> From: Mix Nin <[EMAIL PROTECTED]>
> Date: Fri, Mar 1, 2013 at 2:26 PM
> Subject:
> To: [EMAIL PROTECTED]
>
>
> *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
>
>  Event key
>
> AA
>
> BB
>
> CC
>
> 11111
>
> 11
>
> 144
>
> y
>
> 11111
>
> 22
>
> 244
>
> n
>
> 11111
>
> 33
>
> 344
>
> y
>
>
> How could we write a PIG script for this.
>
>
> Thanks
>