Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Lateral View in sub query issue


Copy link to this message
-
Lateral View in sub query issue
John Omernik 2013-01-26, 02:38
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?