Re: Single Mapper - HIVE 0.11

2013-10-11 Thread Gourav Sengupta
quot; "set hive.auto.convert.join=true" === Thanks and Regards, Gourav Sengupta On Thu, Oct 10, 2013 at 9:16 AM, Gourav Sengupta wrote: > Hi, > > The entire table of 34 million records is in a single ORC file. and its > around 7 GB in size. the oth

Re: Single Mapper - HIVE 0.11

2013-10-10 Thread Gourav Sengupta
with HADOOP configuration as with some other queries I am getting more than 24 mappers. Please accept my sincere regards for your kind help and insights. Thanks, Gourav Sengupta On Wed, Oct 9, 2013 at 6:22 PM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > What is your

Single Mapper - HIVE 0.11

2013-10-09 Thread Gourav Sengupta
Hi, I am trying to run a join using two tables stored in ORC file format. The first table has 34 million records and the second has around 300,000 records. Setting "set hive.auto.convert.join=true" makes the entire query run via a single mapper. In case I am setting "set hive.auto.convert.join=f

Re: GROUP BY Issue

2013-06-17 Thread Gourav Sengupta
uot; rows and joining will make 25 rows > with the same F1 value. > > I cannot imagine what you're intended to do. > > 2013/6/12 Gourav Sengupta : > > Hi, > > > > I had initially forwarded this request to the user group but am yet to > > receive any response.

Fwd: GROUP BY Issue

2013-06-12 Thread Gourav Sengupta
more) and there must be a better alternative. Regards, Gourav -- Forwarded message -- From: Gourav Sengupta Date: Mon, Jun 10, 2013 at 4:10 PM Subject: GROUP BY Issue To: u...@hive.apache.org Hi, On running the following query I am getting multiple records with same value of F1