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
