hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "@Sanjiv Singh" <sanjiv.is...@gmail.com>
Subject Re: rename a database
Date Fri, 27 Mar 2015 16:14:37 GMT
There is already JIRA raised for this functionality and patch available
with ticket.

Patch moves the database directory on HDFS and changes its related metadata
entities.
Unit tests are also included.

https://issues.apache.org/jira/browse/HIVE-4847

I have not tried it yet.

Regards,
Sanjiv Singh


Regards
Sanjiv Singh
Mob :  +091 9990-447-339

On Fri, Mar 27, 2015 at 9:31 PM, Dr Mich Talebzadeh <mich@peridale.co.uk>
wrote:

>
> 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." <anytek88@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.on@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 <
> >> shushantarora09@gmail.com> wrote:
> >>
> >>> Hi
> >>>
> >>> Is there any way in hive0.10 to rename a database ?
> >>>
> >>> Thanks
> >>>
> >>>
> >>
> >
> >
>

Mime
View raw message