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 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