Re: Skew Join Optimization in hive

2011-06-07 Thread Shantian Purkad
logic and dependencies in the joins) From: Igor Tatarinov To: user@hive.apache.org; Shantian Purkad Sent: Tuesday, June 7, 2011 12:58 PM Subject: Re: Skew Join Optimization in hive Have you tried splitting the query into 2 or 3 steps and/or enabling map jons

Re: Skew Join Optimization in hive

2011-06-07 Thread Igor Tatarinov
Have you tried splitting the query into 2 or 3 steps and/or enabling map jons (SET hive.auto.convert.join = true;) if some of the tables are smallish? On Tue, Jun 7, 2011 at 12:31 PM, Shantian Purkad wrote: > Hi, > > I have a query which joins 12 different tables (most of them left outer > joins