Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
---------- 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB