Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Lateral View in sub query issue


+
John Omernik 2013-01-26, 02:38
+
Mark Grover 2013-01-26, 18:40
Copy link to this message
-
Re: Lateral View in sub query issue
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"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB