I used to have some tables in HIVE but after an incident HIVE went down and some new tables erased and old tables went back to a previous schema state.
What I want, is to ask if it is there any option to backup tables' schemas into MySQL which stores HIVE metastore in order to retrieve them if there occurred any incident again.
All the hive related tables are stored under "hive" database in mysql.
You can take mysql dump for a database hive and can prevent this from happening in the future.
You can use command like:
mysqldump -u root -p hive
View solution in original post