Hive Database backup, table, metastore

Big Data Apache Hive
#1

Dear Team,

Is there any way to take backup of

  1. Hive database
  2. Hive Tables (Particular Table)
  3. Hive metastore

Please let me know.

Thanks in Advance !!!

#2

Hello Mohit,

You can save all the tables in HDFS.

#3

We can take back up of Hive metastore using back up feature of underlying database.

For tables in Hive, it is not common practice. If required you can copy to other cluster using distcp.