Home | About | Sematext search-lucene.com search-hadoop.com
 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
inelu nagamallikarjuna 2013-09-12, 02:38
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
>