Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of alokawi@gmail.com designates
 209.85.216.41 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAJqeMKQ51wxY4QOSGJAaoZKnZkqEpj-Rjw105+FxVHK4HDo6PA@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>
	<CAJqeMKQ51wxY4QOSGJAaoZKnZkqEpj-Rjw105+FxVHK4HDo6PA@mail.gmail.com>
Date: Sat, 25 Aug 2012 17:59:53 +0530
Message-ID: 
 <CAP=P7hucKRwnguFEvphyAS74MNph8z73XZ4qDgOA38kApzEouw@mail.gmail.com>
Subject: Re: alter external table location with new namenode address
From: Alok Kumar <alokawi@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Carl,

I tried and found ALTER TABLE SET LOCATION command can't be used
to set location for non-native tables. In my case, where all hive tables are
mapped with tables in hbase, ALTER TABLE SET LOCATION  was not possible!!
I agree it wasn't a good idea though but only option i believe

or is it available with any newer hive release?

Thanks,
Alok

On Sat, Aug 25, 2012 at 1:22 AM, Carl Steinbach <carl@cloudera.com> wrote:
> 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
>> >
>> >
>
>


-- 
Alok Kumar