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

Switch to Plain View
Pig, mail # user - Parse data with multiple delimiters and transpose rows and columns


+
Mix Nin 2013-03-01, 22:28
+
Vitalii Tymchyshyn 2013-03-02, 08:38
Copy link to this message
-
Parse data with multiple delimiters and transpose rows and columns
Mix Nin 2013-03-02, 00:32
*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
+
Johnny Zhang 2013-03-02, 00:45