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
-
Parse data with multiple delimiters and transpose rows and columns
Mix Nin 2013-03-01, 22:28
---------- 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