hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <grover.markgro...@gmail.com>
Subject Re: Lateral View in sub query issue
Date Sat, 26 Jan 2013 18:40:02 GMT
Hi John,
Thanks for reporting this.

Can you please take a look at the Lateral View issues here:
https://issues.apache.org/jira/issues/?jql=project%20%3D%20HIVE%20AND%20text%20~%20%22lateral%20view%22

and create a new JIRA with the details if one previously doesn't exist?

Thanks again,
Mark

On Fri, Jan 25, 2013 at 6:38 PM, John Omernik <john@omernik.com> wrote:

> Anyone else seeing this
>
>
> select col1, col2, col3, excol
> from sometablewithanarrayfield
> LATERAL VIEW explode(arcol) artab as excol
>
>
> Works just fine
>
> select col1, excol, count(1) as excount from (
> select col1, col2, col3, excol
> from sometablewithanarrayfield
> LATERAL VIEW explode(arcol) artab as excol
> ) a
> group by col1, excol
>
> Fails instantly with a weird java error
>
> Known bug? Need more details?
>
>

Mime
View raw message