Re: how is number of mappers determined in mapside join?

2012-03-20 Thread Bruce Bian
--- > *From:* Bruce Bian > *To:* user@hive.apache.org; Bejoy Ks > *Sent:* Monday, March 19, 2012 7:48 PM > *Subject:* Re: how is number of mappers determined in mapside join? > > Hi Bejoy, > Thanks for your reply. > The function is from the book, Hadoop The Definitive Guide 2nd

Re: how is number of mappers determined in mapside join?

2012-03-19 Thread Bejoy Ks
ither 128 or 256 Mb blocks. Hope it helps!.. Regards Bejoy   From: Bruce Bian To: user@hive.apache.org; Bejoy Ks Sent: Monday, March 19, 2012 7:48 PM Subject: Re: how is number of mappers determined in mapside join? Hi Bejoy, Thanks for your reply. The fun

Re: how is number of mappers determined in mapside join?

2012-03-19 Thread Bruce Bian
point me to the > document from which you got this? > > Regards > Bejoy > > -- > *From:* Bruce Bian > *To:* user@hive.apache.org > *Sent:* Monday, March 19, 2012 2:42 PM > *Subject:* how is number of mappers determined in mapside join? &

Re: how is number of mappers determined in mapside join?

2012-03-19 Thread Bejoy Ks
MB, your table size. I'm not sure of the formula you posted here, Can you point me to the document from which you got this? Regards Bejoy From: Bruce Bian To: user@hive.apache.org Sent: Monday, March 19, 2012 2:42 PM Subject: how is number of ma

how is number of mappers determined in mapside join?

2012-03-19 Thread Bruce Bian
Hi there, when I'm executing the following queries in hive set hive.auto.convert.join = true; CREATE TABLE IDAP_ROOT as SELECT a.*,b.acnt_no FROM idap_pi_root a LEFT OUTER JOIN idap_pi_root_acnt b ON a.acnt_id=b.acnt_id the number of mappers to run in the mapside join is 3, how is it determined?