Support Questions

Find answers, ask questions, and share your expertise

How are you protecting Hive views

New Contributor

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

5 REPLIES 5

Expert Contributor

@NikoBelic  Could you please elaborate your issue?

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

New Contributor
Hi Asish,

Thanks for looking into this query.

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

Expert Contributor

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

New Contributor

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

Expert Contributor

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