Grokbase › Groups › Hive › user › April 2011
FAQ
Dear Hive users,
I need to sync data between two Hive data warehouse. These two Hive data
warehouse have their own independent HDFS and metastore.

Currently my option is to sync HDFS data and then add partitions in the
destination HIVE tables, but this is very tedious operation when number of
tables are high (50 +).

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?

Any pointers are greatly appreciated.

Thanks,
Ravi

Search Discussions

  • Thiruvel Thirumoolan at Apr 12, 2011 at 4:23 am ⇧
    HIVE-1918 allows you to export/import tables, that should help you. Think its 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 data warehouse have their own independent HDFS and metastore.

    Currently my option is to sync HDFS data and then add partitions in the destination HIVE tables, but this is very tedious operation when number of tables are high (50 +).

    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?

    Any pointers are greatly appreciated.

    Thanks,
    Ravi

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedApr 11, '11 at 6:37p
activeApr 12, '11 at 4:23a
posts2
users2
websitehive.apache.org

2 users in discussion

Thiruvel Thirumoolan: 1 post Ravi .: 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase