Re: Hive Buckets and Select queries

2015-12-31 Thread Lefty Leverenz
cc: u...@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,

Hive Buckets and Select queries

2015-12-28 Thread Varadharajan Mukundan
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, its doing a "Full table scan" SELECT * FROM foo WHERE id= After doing some searching on the net, i found that "table sample" seems to b