Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of carl@cloudera.com designates
 209.85.212.173 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAP=P7htrSZHt4BFWd6aJBJ5xvBs7wqFUWcwES8OsHs1FPQDouA@mail.gmail.com>
References: 
 <CAP=P7hu2xRauw6vLy18iZ+Ge5mew3n0jKcakh7qnzaAqQZ-Gsg@mail.gmail.com>
	<2051305521-1345810255-cardhu_decombobulator_blackberry.rim.net-1556424874-@b25.c15.bise7.blackberry>
	<CAP=P7htrSZHt4BFWd6aJBJ5xvBs7wqFUWcwES8OsHs1FPQDouA@mail.gmail.com>
Date: Fri, 24 Aug 2012 12:52:41 -0700
Message-ID: 
 <CAJqeMKQ51wxY4QOSGJAaoZKnZkqEpj-Rjw105+FxVHK4HDo6PA@mail.gmail.com>
Subject: Re: alter external table location with new namenode address
From: Carl Steinbach <carl@cloudera.com>
To: user@hive.apache.org
Cc: bejoy_ks@yahoo.com, user@hbase.apache.org
Content-Type: multipart/alternative; boundary=00504502d8479cd7b904c8085130

--00504502d8479cd7b904c8085130
Content-Type: text/plain; charset=ISO-8859-1

Directly accessing the metastore schema is generally not a good idea.
Instead I recommend using the ALTER TABLE SET LOCATION command:

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable%2FPartitionLocation

Thanks.

Carl

On Fri, Aug 24, 2012 at 10:56 AM, Alok Kumar <alokawi@gmail.com> wrote:

> Bejoy,
>
> Thank you for your help.
> updated metastore n its working fine.
>
> Regards
> -Alok
>
> On Fri, Aug 24, 2012 at 5:40 PM, Bejoy KS <bejoy_ks@yahoo.com> wrote:
> > Yes you need to update the metastore db directly for this to be in
> effect.
> >
> > Regards
> > Bejoy KS
> >
> > Sent from handheld, please excuse typos.
> >
> > -----Original Message-----
> > From: Alok Kumar <alokawi@gmail.com>
> > Date: Fri, 24 Aug 2012 13:30:36
> > To: <user@hbase.apache.org>; <user@hive.apache.org>
> > Reply-To: user@hive.apache.org
> > Subject: alter external table location with new namenode address
> >
> > Hello,
> >
> > We have hive external table mapped to hbase, now moving
> > from pseudo distributed to fully distributed hadoop cluster.
> >
> > found that hive queries are still pointing to older namenode address
> > ie: hdfs://localhost:9000/user/hive/warehouse/<table-name> as it stores
> > full uri in its derby metastore.
> >
> > Q . what would be the best way to set new namenode address?
> >
> >  Alter table command on hive shell to set hdfs location is only
> > possible for native tables!!
> > should i update derby "DB_LOCATION_URI" column directly?
> >
> > Your help/suggestion is highly appreciated
> >
> > Thanks,
> > Alok
> >
> >
>

--00504502d8479cd7b904c8085130--