hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abe Weinograd <...@flonet.com>
Subject map side join
Date Thu, 30 Apr 2015 14:01:17 GMT
Hi,

I am doing a few map side joins in one query to load an user facing ORC
table in order to denormalize.

Two of the tables I am joining too are pretty large.  I am
setting hive.auto.convert.join.noconditionaltask.size pretty high.
However, the join it self filters on those two tables, but it seems like
its submitting the whole table to the job.  if I use a view with the filter
baked in, will that help?  I don't want to have to jack up the JVM for the
client/HiveServer2 to accommodate the full table.

Thanks,
Abe

Mime
View raw message