Re: Where clause and bucketized table

2012-03-02 Thread Mark Grover
@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. - Original Message - From: "Bejoy Ks" To: user@hive.apache.org Sent: Friday, March 2, 2012 5:58:56 AM Subject: Re: Wh

Re: Where clause and bucketized table

2012-03-02 Thread Bejoy Ks
Partitions.  Regards Bejoy.K.S From: "mdefoinplatel@orange.com" To: "user@hive.apache.org" Sent: Friday, March 2, 2012 3:15 PM Subject: Where clause and bucketized table Hi folks,   I have a table T bucketized  on user_id and I am surprise

Where clause and bucketized table

2012-03-02 Thread mdefoinplatel.ext
Hi folks, I have a table T bucketized on user_id and I am surprised to see that all the buckets are read during the execution of the following query: SELECT * from T where user_id = X What should I do to make sure hive will account for the bucket structure to run this query ? Cheers, Michael