hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Copying a Hive metastore
Date Fri, 30 Sep 2011 22:15:39 GMT
On Fri, Sep 30, 2011 at 5:05 PM, Steven Wong <swong@netflix.com> wrote:

> Hi,
>
>
>
> What is a good way to copy the entire content of a Hive metastore and
> insert it into another Hive metastore? The second metastore contains
> existing metadata that needs to be preserved. Both metastores are in MySQL,
> not fronted by any Hive metastore server.
>
>
>
> My guess is Hive has some metastore API that may be appropriate here, but I
> don’t know if that is true because I know zilch about that API — I don’t
> even know where the API documentation is.
>
>
>
> Thanks.
>
> Steven
>

I would say a simple way is to take mysql dumps and then append the dump
files together. As long as you do not have two tables with the same name I
do not see any challenges with that. This portion of the API is not very
well documented because most do not interact with the metastore directly,
they only interact with HQL.

Mime
View raw message