Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - alter external table location with new namenode address


Copy link to this message
-
alter external table location with new namenode address
Alok Kumar 2012-08-24, 08:00
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