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

Hive: Dynamic Partition Pruning and Left Outer Joins

New Contributor

Hi,

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

SELECT *
  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.

Thanks,

Paul

0 REPLIES 0