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

Switch to Threaded View
Pig >> mail # user >> convert rows to columns in Pig


Copy link to this message
-
Re: convert rows to columns in Pig
I think it will work for to change columns to rows. I am looking to change
rows to columns.
On Fri, Oct 18, 2013 at 12:14 PM, ajay kumar <[EMAIL PROTECTED]>wrote:

> try this,
>
> A = load 'input';
> B = foreach A generate FLATTEN(TOBAG(*));
>
>
> On Fri, Oct 18, 2013 at 12:04 PM, soniya B <[EMAIL PROTECTED]>
> wrote:
>
> > Hi,
> >
> > How to convert rows to columns in pig latin?
> >
> > example:
> >
> > input file
> >
> > A   100     3
> > B   200     4
> > C   400     6
> >
> > required output
> >
> > A        B        C
> >
> > 100     200    400
> >
>
>
>
> --
> *Thanks & Regards,*
> *S. Ajay Kumar
> +91-9966159106*
>