Hi, Hive wiki says "Hive currently does input pruning only if the partition predicates are specified in the WHERE clause closest to the table_reference in the FROM clause..." what does this mean?
I have a query in which I am joining 4 tables two of which need to be pruned by partition. The partition predicates are specified in the WHERE clause. However, I see that only one of the table gets pruned by the partition whereas the other one goes for a full table scan. Have a great holiday season! Narendra
