Can you post your query? Is there " or " connecting the partitions' predicate with others?
Thanks Yongqiang On Mon, Dec 27, 2010 at 11:09 PM, Narendra <uncle.n...@gmail.com> wrote: > 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
