How are you protecting Hive views

[#1]

What strategy you would propose for protecting the Hive views.?

[#2]

@NikoBelic  Could you please elaborate your issue?

Do you want to secure Hive Views using Ranger authorisation? Is this your requirement?

[#3]

Hi Asish,

Thanks for looking into this query.

I want to backup hive views metadata, want to understand best practices
around this.

[#4]

@NikoBelic 

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.

[#5]

Thanks Asish. Appreciate your response. Is it possible to just backup Hive metadata without DB dump?

[#6]

@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.