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
*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