Support Questions
Find answers, ask questions, and share your expertise

What are the steps to restore a subset of Hive data not the entire database?

Highlighted

What are the steps to restore a subset of Hive data not the entire database?

Explorer

What are the detailed steps involved in restoring a subset of Hive data not the entire database?

5 REPLIES 5

Re: What are the steps to restore a subset of Hive data not the entire database?

Cloudera Employee

@Debra -

Could you provide the method used to backup Hive data?

Highlighted

Re: What are the steps to restore a subset of Hive data not the entire database?

Explorer

mysql is the metastore and backup method.

Highlighted

Re: What are the steps to restore a subset of Hive data not the entire database?

Mentor

@Debra

Here is an example

Highlighted

Re: What are the steps to restore a subset of Hive data not the entire database?

Explorer

Hi Geoffrey

I need the information on how to get the backup subset from mysql information synched with hive warehouse data in HDFS.

/apps/hive/warehouse

Highlighted

Re: What are the steps to restore a subset of Hive data not the entire database?

Explorer

I purposedly dropped a table after performing a backup and was able to successfully restore the database in Hive. One thing I notice is the file was not recovered in HDFS /apps/hive/warehouse despite the location showing when I run describe formatted against this the table. Is this behavior expected?

Don't have an account?