Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB