Re: Alter location of database in Hive
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 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 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, so I'm trying to point all of our tables, partitions and databases >>> to the new locations. >>> >>> When i describe database mydb, the location shows up as >>> "hdfs:///user/hive/warehouse/mydb.db", and i want to set it >>> to "hdfs:///user/hive/warehouse/mydb.db" >>> >>> Is there a way to do this. Or do I need to go poking around in the >>> mysql metadata to actually carry this out? >>> >>> Regards, >>> Jon >>> >> >> >
Re: Alter location of database in Hive
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 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, so I'm trying to point all of our tables, partitions and databases >> to the new locations. >> >> When i describe database mydb, the location shows up as >> "hdfs:///user/hive/warehouse/mydb.db", and i want to set it >> to "hdfs:///user/hive/warehouse/mydb.db" >> >> Is there a way to do this. Or do I need to go poking around in the mysql >> metadata to actually carry this out? >> >> Regards, >> Jon >> > >
Re: Alter location of database in Hive
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, so I'm trying to point all of our tables, partitions and databases > to the new locations. > > When i describe database mydb, the location shows up as > "hdfs:///user/hive/warehouse/mydb.db", and i want to set it > to "hdfs:///user/hive/warehouse/mydb.db" > > Is there a way to do this. Or do I need to go poking around in the mysql > metadata to actually carry this out? > > Regards, > Jon >