hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Nagaraju <rajeshnagar...@gmail.com>
Subject Re: Question on LATERAL VIEW explode
Date Sun, 29 Sep 2013 01:09:02 GMT
Hi Gary

I would say write an UDF

Thanks and Regards
Rajesh


On Sun, Sep 29, 2013 at 5:16 AM, Gary Zhao <garyzhao@gmail.com> wrote:

> Hello
>
> Do you know if my scenario is supported or not, or how I may do it.
> Basically, I have an array in a recode, like
>
> [1, 2, 3]
>
> What I want is to explode it twice so I can have the following output:
>
> 1 2
> 1 3
> 2 1
> 2 3
> 3 1
> 3 2
>
> I tried a few queries but couldn't make it succeed.
>
> Thanks
> Gary
>
>

Mime
View raw message