You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Sudipto Das <su...@cs.ucsb.edu> on 2009/09/11 20:04:29 UTC

Multiple rows from a single row

Hi,

I have a scenario where in a query, I need to split up a single row and
output 3 different rows. Is this supported by Hive, and if yes, can someone
point me to the syntax?

Thanks
Sudipto

PhD Candidate
CS @ UCSB
Santa Barbara, CA 93106, USA
http://www.cs.ucsb.edu/~sudipto

Re: Multiple rows from a single row

Posted by Sudipto Das <su...@gmail.com>.

Thanks... I'll look into it and get back if I have any more questions.

PhD Candidate
CS @ UCSB
Santa Barbara, CA 93106, USA
http://www.cs.ucsb.edu/~sudipto


On Fri, Sep 11, 2009 at 11:17 AM, Raghu Murthy <rm...@facebook.com> wrote:

> You will need to write a custom mapper script using a TRANSFORM clause. See
> http://wiki.apache.org/hadoop/Hive/LanguageManual/Transform
>
>
> On 9/11/09 11:04 AM, "Sudipto Das" <su...@cs.ucsb.edu> wrote:
>
> > Hi,
> >
> > I have a scenario where in a query, I need to split up a single row and
> output
> > 3 different rows. Is this supported by Hive, and if yes, can someone
> point me
> > to the syntax?
> >
> > Thanks
> > Sudipto
> >
> > PhD Candidate
> > CS @ UCSB
> > Santa Barbara, CA 93106, USA
> > http://www.cs.ucsb.edu/~sudipto <http://www.cs.ucsb.edu/%7Esudipto>
>
>

Re: Multiple rows from a single row

Posted by Raghu Murthy <rm...@facebook.com>.

You will need to write a custom mapper script using a TRANSFORM clause. See
http://wiki.apache.org/hadoop/Hive/LanguageManual/Transform

On 9/11/09 11:04 AM, "Sudipto Das" <su...@cs.ucsb.edu> wrote:

> Hi,
> 
> I have a scenario where in a query, I need to split up a single row and output
> 3 different rows. Is this supported by Hive, and if yes, can someone point me
> to the syntax?
> 
> Thanks
> Sudipto
> 
> PhD Candidate
> CS @ UCSB
> Santa Barbara, CA 93106, USA
> http://www.cs.ucsb.edu/~sudipto