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
Copy link to this message
-
Re: Lateral View in sub query issue
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 Mokashi 2013-02-14, 08:02
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