hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yongqiang he <heyongqiang...@gmail.com>
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?

Thanks
Yongqiang
On Mon, Dec 27, 2010 at 11:09 PM, Narendra <uncle.nari@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

Mime
View raw message