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 >> Converting xml to csv


Copy link to this message
-
Re: Converting xml to csv
Hai,

Load those two files as two relations and extract or parse XML files by
using extract_regex_all and finally store them into CSV files.....

Thanks
Naga
On Sep 12, 2013 5:44 AM, "jamal sasha" <[EMAIL PROTECTED]> wrote:

> Hi,
>   So I have different xml data sources...For example:
>
> src1.txt
>
> <foo>
> <bar>1</bar>
> </foo>
> <foo>
> <bar>2</bar>
> </foo>
> .. and so on
>
>
> and another data
>
> src2.txt
>
> <aux>
> <foobar>1</foobar>
> <fushbar>foo</fushbar>
> </aux>
>
> ... and so on
>
>
> So basicaly different xml (valid formats)
>
> Rather than writing different pig scripts.. is there a way to write 1
> script and then convert all these xml data into csv?
> 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