Home | About | Sematext search-lucene.com search-hadoop.com
 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