A hive table stores the full HDFS URI to the table such as hdfs://hostname:9120/user/hive/warehouse
You likely have restored you name node to a different hostname and now hive is not able to locate it. You might be able to create a DNS cname to resolve this. Hind sight, is 20/20 but I would have restored the name node to the same host/ip. If the cname does not work you will have to alter all your table to the correct path. Edward On Wed, May 9, 2012 at 12:14 PM, varun kumar <varun....@gmail.com> wrote: > Hi All, > > I have changed the namenode from one server to another when there was a > crash of hardware. > > After configuring the Namenode. > > When i am executing hive query below error is shown.. > > bin/hive -e “insert overwrite table pokes select a.* from invites a where > a.ds=’2008-08-15′;” > Hive history > file=/tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_2120318983.txt > Total MapReduce jobs = 2 > Launching Job 1 out of 2 > Number of reduce tasks is set to 0 since there’s no reduce operator > Starting Job = job_201112011620_0004, Tracking URL > =http://x.x.x.b:50030/jobdetails.jsp?jobid=job_201112011620_0004 > Kill Command = C:\cygwin\home\Bhavesh.Shah\hadoop-0.20.2\/bin/hadoop job > -Dmapred.job.tracker=localhost:9101 -kill job_201112011620_0004 > 2011-12-02 10:07:30,777 Stage-1 map = 0%, reduce = 0% > 2011-12-02 10:07:57,796 Stage-1 map = 100%, reduce = 100% > Ended Job = job_201112011620_0004 with errors > FAILED: Execution Error, return code 2 from > org.apache.hadoop.hive.ql.exec.MapRedTask > > I have noticed that it is trying to communicate with the old host.I am > unable to trouble shoot where i have done wrong in building the hadoop > Namenode. > > Can you please suggest me why hive is not able to communicate to the new > Name node. > > > > > -- > Regards, > Varun Kumar.P >