What strategy you would propose for protecting the Hive views.?
VIEWS are stot=red in TBLS table i.e in Hive metadata. You can create a database dump as a backup.
Please follow https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html to create database dump for mysql
Please follow https://www.postgresql.org/docs/current/backup-dump.html to create database dump for postgres
Please let me know,if you have any queries. Please "Accept As Solution", if your queries are answered.
@NikoBelic Thanks for the update. The hive metadata indeed is stored on database. You need to take the dump to backup the metadata.
Please let me know,if you have nay queries. Please "Accept as Solution" ,if your queries are answered.