hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Seidman <jonathan.seid...@gmail.com>
Subject Re: Need urgent suggestion on the below issue
Date Wed, 09 May 2012 18:11:40 GMT
Varun – So yes, Hive stores the full URI to the NameNode in the metadata
for every table and partition. From my experience you're best off modifying
the metadata to point to the new NN, as opposed to trying to manipulate
DNS. Fortunately, this is fairly straightforward since there's mainly one
column you need to modify, and assuming you're using something like MySQL
will only require a global search-and-replace on the URI in this column. I
don't remember the exact table that contains this info, but if you browse
the metastore tables you should find a LOCATION column which contains the
NN URI that you need to change.

On Wed, May 9, 2012 at 11:14 AM, varun kumar <varun.uid@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<http://localhost: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
>
>

Mime
View raw message