Support Questions
Find answers, ask questions, and share your expertise

Hive: Dynamic Partition Pruning and Left Outer Joins

New Contributor


Does anyone know whether Hive will partition prune when a partitioned table appears in a left outer join such as below:

  FROM tab a
  LEFT OUTER JOIN partitoned_tab b
               ON a.col_1 = b.col_1
              AND a.partition_col = b.partition_col

It only appears to partition prune as indicated by Dynamic Partitioning Event Operator in the explain plan when joins are inner.