-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