Bejoy, Thank you for your help. updated metastore n its working fine.
Regards -Alok On Fri, Aug 24, 2012 at 5:40 PM, Bejoy KS <[email protected]> wrote: > Yes you need to update the metastore db directly for this to be in effect. > > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > > -----Original Message----- > From: Alok Kumar <[email protected]> > Date: Fri, 24 Aug 2012 13:30:36 > To: <[email protected]>; <[email protected]> > Reply-To: [email protected] > Subject: 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 > >
