Re: Hive Buckets and Select queries

2015-12-31 Thread Gopal Vijayaraghavan
> and when we issue the following query, its doing a "Full table scan" > > > SELECT * FROM foo WHERE id= Bucket pruning is available in Hive-2.0 right now (HIVE-11525). Doc note pending, for 2016 when Hive-2.0 releases. Cheers, Gopal

Re: Hive Buckets and Select queries

2015-12-31 Thread Lefty Leverenz
cc: user@hive.apache.org -- Lefty On Mon, Dec 28, 2015 at 11:00 PM, Varadharajan Mukundan < srinath...@gmail.com> wrote: > Hi All, > > Say i have a table with below schema: > > CREATE TABLE foo (id INT) CLUSTERED BY (id) INTO 8 BUCKETS STORED AS ORC; > > and when we issue the following query,

Re: hive buckets

2012-06-25 Thread Bejoy Ks
triggered which does the grouping/selection of data into various buckets Regards Bejoy KS From: shaik ahamed To: user@hive.apache.org Sent: Monday, June 25, 2012 1:46 PM Subject: hive buckets Hi Users,     I am new to hive ,i need the clarity on hive

hive buckets

2012-06-25 Thread shaik ahamed
Hi Users, I am new to hive ,i need the clarity on hive buckets as this is done with the hive partition table only or we can create a buckets for hive table .please give an example with the sample data.