Hi, I have a partitioned hive table that has multiple partition columns. My query is of the form: select audf(column1) , sum(column2) from table1 join table2 on (table1.id = table2.id) where ((table1.partition_column1 = 2016 and table1.partition_column2 = 08 and table1.partition_column3 = 09) or (table1.partition_column1 = 2016 and table1.partition_column2 = 08 and table1.partition_column3 = 10)) and ((table2.partition_column1 = 2016 and table2.partition_column2 = 08 and table2.partition_column3 = 09) or (table2.partition_column1 = 2016 and table2.partition_column2 = 08 and table2.partition_column3 = 10)) group by audf(column1); Predicate push down happens when this query is run through hive-cli and input splits that are added are significantly low in number as compared to when this query is run as part of oozie hive action. All the 4 configuration properties related to ppd are set to true in both, hive as well as oozie configurations. I am using HDP 2.4. ... View more