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

Switch to Threaded View
Hive, mail # user - Cannot use explode with sub queries?


Copy link to this message
-
Cannot use explode with sub queries?
Vijay 2011-11-03, 23:36
I can't seem to use explode with subqueries. This is what I'm trying:

select user, requestid
from (
  select user, requestid_list
  from logs where ...
) t lateral view explode(requestid_list) as requestid;

I tried a few similar variations but none of them seem to work. I
can't find any examples with explode and sub queries.

Thanks,
Vijay