Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
From: Thiruvel Thirumoolan <thiruvel@yahoo-inc.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Date: Tue, 12 Apr 2011 09:52:45 +0530
Subject: Re: How to sync hive tables from one cluster to another cluster.
Thread-Topic: How to sync hive tables from one cluster to another cluster.
Thread-Index: Acv4yUYcAqqg4kLKS7KUMiU2d6ijFA==
Message-ID: <1B6E6E23-21C1-475C-814C-24EC09F731E4@yahoo-inc.com>
References: <BANLkTi=ZZTAuiBd6S8zOBWwhcEGkp+YMYQ@mail.gmail.com>
In-Reply-To: <BANLkTi=ZZTAuiBd6S8zOBWwhcEGkp+YMYQ@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

HIVE-1918 allows you to export/import tables, that should help you. Think i=
ts available only in 0.8


On Apr 12, 2011, at 12:07 AM, Ravi . wrote:

> Dear Hive users,
>   I need to sync data between two Hive data warehouse. These two Hive dat=
a warehouse have their own independent HDFS and metastore.
>=20
> Currently my option is to sync HDFS data and then add partitions in the d=
estination HIVE tables, but this is very tedious operation when number of t=
ables are high (50 +).
>=20
> Is there any better way to sync hive tables? Is their any utility similar=
  to MySQLdump or importing tool for hive tables from another metastore?=20
>=20
> Any pointers are greatly appreciated.
>=20
> Thanks,
> Ravi
>=20
> =20
>=20