Re: Alter location of database in Hive

2014-07-01 Thread Matouk IFTISSEN
Hello If you do alter location 'new-location' in your all tables it does not work ? Le 1 juil. 2014 03:15, "Prem Yadav" a écrit : > I think you should be able to copy the data to a different location and > then drop the old db, and create a new one with the new location. > > > On Tue, Jul 1, 2014

Re: Alter location of database in Hive

2014-06-30 Thread Prem Yadav
I think you should be able to copy the data to a different location and then drop the old db, and create a new one with the new location. On Tue, Jul 1, 2014 at 1:54 AM, Jon Bender wrote: > Answered my own question, no there is not. The way to do is is to modify > the DB_LOCATION_URI field in

Re: Alter location of database in Hive

2014-06-30 Thread Jon Bender
Answered my own question, no there is not. The way to do is is to modify the DB_LOCATION_URI field in metastore.DBS (at least if you're using MySQL) On Mon, Jun 30, 2014 at 5:14 PM, Jon Bender wrote: > Hey all, > > I'm on Hive 0.10.0 on one of my clusters. We had a namenode hostname > change,