hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narendra <uncle.n...@gmail.com>
Subject Question of Hive Partitioning
Date Tue, 28 Dec 2010 07:09:13 GMT
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

Mime
View raw message