hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yongqiang he <>
Subject Re: Question of Hive Partitioning
Date Tue, 28 Dec 2010 07:36:01 GMT
Can you post your query? Is there " or " connecting the partitions'
predicate with others?

On Mon, Dec 27, 2010 at 11:09 PM, Narendra <> 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

View raw message