FYI,
Brickhouse provides a numeric_range UDTF, which explodes integer values,
and an array_index UDF, so you could solve your problem by exploding on a
numeric range of the size of the array. ie.
select n, array_index(arr, n )
from mytable
lateral view numeric_range(0, size(arr) -1 ) n1 as n
;
set hive.exec.parallel=true;
This will run Hive jobs in parallel, if they are able to do so.
As for multi-threading in the actual job itself, I don't think so, but I'm
not sure. The query planner will merge steps together, in order to try to
minimize the number of MR jobs needed to run a query, b
