yep it can can happen in any server hosting a database or schema. I believe you will need to rename the database directory underr hive warehouse ditectory <DBNAME>.db.
Then you can hack Hive metasttore database. Mine is on SAP ASE. Certain tables like DBS etc in metastoreDB need to be changed. I cannot fremember on top of my head. Best to basckup database before hacking it and do it out of business hours. That is an approch. I am sure there are better ways. HTH, Mich On 27/3/2015, "Fabio C." <anyte...@gmail.com> wrote: >Maybe they just typed time_shit instead of time_shift and found it out >after 3 hours of tables compression... I don't think it's too important, >but which is the workaround? I'm also interested in this. >Maybe it's just a matter of metastore and one could try to explore the >metastore db to change how the database is referenced, possibly having to >change also the DB folder name on HDFS... My two cents ;) > >Regards > >On Fri, Mar 27, 2015 at 3:10 PM, @Sanjiv Singh <sanjiv.is...@gmail.com> >wrote: > >> Can I know why do you want to do so? >> >> Currently There is no command or direct way to do that..then I can suggest >> workaround for this. >> >> Thanks, >> Sanjiv Singh >> >> >> Regards >> Sanjiv Singh >> Mob : +091 9990-447-339 >> >> On Wed, Mar 25, 2015 at 10:01 AM, Shushant Arora < >> shushantaror...@gmail.com> wrote: >> >>> Hi >>> >>> Is there any way in hive0.10 to rename a database ? >>> >>> Thanks >>> >>> >> > >
