You can use the Commvault software to back up and restore Apache Hive databases.
Backups
Data You Can Back Up
- 
All Hive databases or user-specified databases in the Hadoop cluster.
 - 
Hive tables from all nodes in the Hadoop cluster.
 
Backups You Can Perform
- 
Full backups
 - 
Incremental backups
 - 
Synthetic full backups
 
When You Can Perform Backups
- 
On a schedule: The server plan that you assign manages scheduled backups
 - 
On demand: You can perform on-demand backups at any time
 
Restores
Data You Can Restore
- Hive databases and tables
 
Backups You Can Use for Restores
- 
The most recent backup: For example, restore the most recent backup to its original location
 - 
A backup from a specific date: For example, restore data to a point in time before it became unusable
 
Destinations You Can Restore To
- 
The current location (in place)
 - 
Different set of tables on the same cluster or a different cluster (out of place)