hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bejoy KS" <bejoy...@yahoo.com>
Subject Re: alter external table location with new namenode address
Date Fri, 24 Aug 2012 12:10:50 GMT
Yes you need to update the metastore db directly for this to be in effect.

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


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


View raw message