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