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?

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 <[EMAIL PROTECTED]> 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?
>
>

Most likely its : HIVE-3226 (HIVE-1901)
Workaround: set hive.optimize.cp=false
On Sat, Jan 26, 2013 at 10:40 AM, Mark Grover
<[EMAIL PROTECTED]>wrote:

> 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 <[EMAIL PROTECTED]> 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?
>>
>>
>
--
"...:::Aniket:::... Quetzalco@tl"