question Re: Hive databse backup in Archives of Support Questions (Read Only)

Hive databse backup

saransh_sharma — Fri, 16 Sep 2022 11:33:44 GMT

I want to take a backup of my hive database (metadata + data)

Please guide me in how to do it.

Is it possible to do it using distcp?

Also, is it possible to take the backup on a local system?

Re: Hive databse backup

bmathew — Thu, 04 May 2017 19:38:39 GMT

Backup:

1. The Hive Metastore

- This is in an RDBMS. MySQL by default. The RDBMS will have tools for backup.

- Metastore contains metadata, table partition info, DDL, info about tables

2. The data

- This is in HDFS

- You can use DistCp to copy the data to another cluster

Re: Hive databse backup

bandarusridhar1 — Fri, 26 May 2017 21:07:48 GMT

@Saransh Sharma

In addition to @Binu Mathew If you don't want to take separate backups, and there are limited table to take, even you can use Hive Import/Export option.

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport