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


Copy link to this message
-
Lateral View in sub query issue
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?
+
Mark Grover 2013-01-26, 18:40
+
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