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
Michael        Unlike partitions, hive doesn't choose buckets by itself based on a where clause in HQL. You need to specify the number of buckets that the query should be executing on using TABLE SAMPLE clause .  SELECT * from T TABLESAMPLE (m OUT OF n BUCKETS ON id)  where user_id = X; https:/