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

Switch to Plain 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

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

Bejoy KS 2012-08-24, 12:10
Alok Kumar 2012-08-24, 17:56
Carl Steinbach 2012-08-24, 19:52
Alok Kumar 2012-08-25, 12:29