Re: mapjoin error

2014-07-08 Thread Navis류승우
Looks like HIVE-6913(https://issues.apache.org/jira/browse/HIVE-6913) and will be fixed in hive-0.14.0. Thanks, Navis 2014-07-04 17:12 GMT+09:00 sunww : > Hi > I'm using hive0.11 and hadoop2.2. When I use a large table join on > two empty tables , it convert to mapjoin automatic.But mr fa

mapjoin error

2014-07-04 Thread sunww
HiI'm using hive0.11 and hadoop2.2. When I use a large table join on two empty tables , it convert to mapjoin automatic.But mr failed, This is error log:Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException: /data/data5/yarn/lo

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
Thanks Ashutosh. I will give it a try. -Vivek From: Ashutosh Chauhan [hashut...@apache.org] Sent: 28 November 2012 12:43 To: user@hive.apache.org Subject: Re: MapJoin error: .hashtable file not found Hi Vivek, I will encourage you to try out latest trunk

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
: Navis류승우 [navis@nexr.com] Sent: 28 November 2012 12:44 To: user@hive.apache.org Subject: Re: MapJoin error: .hashtable file not found hi, The hashtable file you mentioned is pre-staged file for MapJoin. If you remove MAPJOIN hint and set auto.convert.join=false, it will be disabled 2012/11

Re: MapJoin error: .hashtable file not found

2012-11-27 Thread Navis류승우
gro...@gmail.com] > Sent: 28 November 2012 11:41 > To: user@hive.apache.org > Subject: Re: MapJoin error: .hashtable file not found > > Vivek, > What version of Hive are you using? And, on what OS? > > Mark > > On Tue, Nov 27, 2012 at 9:34 PM, Vivek Mishra <mailto

Re: MapJoin error: .hashtable file not found

2012-11-27 Thread Ashutosh Chauhan
___ > From: Mark Grover [grover.markgro...@gmail.com] > Sent: 28 November 2012 11:41 > To: user@hive.apache.org > Subject: Re: MapJoin error: .hashtable file not found > > Vivek, > What version of Hive are you using? And, on what OS? > > Mark > > On Tue, Nov 27, 2012

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
there? " -Vivek From: Mark Grover [grover.markgro...@gmail.com] Sent: 28 November 2012 11:41 To: user@hive.apache.org Subject: Re: MapJoin error: .hashtable file not found Vivek, What version of Hive are you using? And, on what OS? Mark On Tue, Nov 27, 2012 at 9:34 PM, Vivek Mish

Re: MapJoin error: .hashtable file not found

2012-11-27 Thread Mark Grover
ugh gz files are there > > -Vivek > > From: Vivek Mishra > Sent: 24 November 2012 11:52 > To: user@hive.apache.org > Subject: MapJoin error: .hashtable file not found > > Hi, > > I am trying to run a MapJoin query and somehow get

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
rg Subject: MapJoin error: .hashtable file not found Hi, I am trying to run a MapJoin query and somehow getting below error. I can see that file is not there in specified directory. Did some debugging but no luck as well. Here is the error: nOperator:Load back 1 hashtable file fro

MapJoin error: .hashtable file not found

2012-11-23 Thread Vivek Mishra
Hi, I am trying to run a MapJoin query and somehow getting below error. I can see that file is not there in specified directory. Did some debugging but no luck as well. Here is the error: nOperator:Load back 1 hashtable file from tmp file uri:c:/hadoop/hdfs/mapred/local/taskTracker/di