k
> To: user@hive.apache.org
> Cc: user@hive.apache.org
> Cc: Bejoy Ks
> Subject: Re: Cartesian Product in HIVE
> Sent: Oct 1, 2012 09:32
>
> Thanks for the reply Bejoy. I did not any order by in the query. Here are the
> properities I have used and query, table sizes - set
ail.com
> > Date: Sat, 29 Sep 2012 07:44:06 -0700
> > Subject: Re: Cartesian Product in HIVE
> > To: user@hive.apache.org; bejoy...@yahoo.com
> >
> > Thanks for the reply Bejoy.
> >
> > I tried to map join, by setting the property mentioned by you and Even
&
OIN table3 t3
table2 : 997406 rows
total bytes: 20848934 -- 19.88 mb
table3 : 20773 rows
total bytes: 353127 -- 0.33 mb
#of Mappers: 4
#of reducers: 1
>
> Regards
> Bejoy KS
>
>> From: abhishek.dod...@gmail.com
>> Date: Sat, 29 Sep 2012 07:44:06 -0700
>> Subject:
r two tables.
Regards
Bejoy KS
> From: abhishek.dod...@gmail.com
> Date: Sat, 29 Sep 2012 07:44:06 -0700
> Subject: Re: Cartesian Product in HIVE
> To: user@hive.apache.org; bejoy...@yahoo.com
>
> Thanks for the reply Bejoy.
>
> I tried to map join, by setting the prope
Thanks for the reply Bejoy.
I tried to map join, by setting the property mentioned by you and Even
increased the small table file size
20k table size would be not more than 200 mb but it doesnot work.
Cartesian product of tables, they dont have any similar columns does
map join work here??
By ap
Hi Abshiek
What is the data size of the 20k rows? If it is lesser then you can go in for
map join, which will give you a performance boost.
set hive.auto.convert.join = true;
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Abhishek
Date: Fri, 28 Sep
