Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive databse backup

Solved Go to solution

Hive databse backup

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Hive databse backup

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

View solution in original post

2 REPLIES 2
Highlighted

Re: Hive databse backup

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

View solution in original post

Highlighted

Re: Hive databse backup

@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

Don't have an account?
Coming from Hortonworks? Activate your account here