Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How are you protecting Hive views

avatar
New Contributor

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

5 REPLIES 5

avatar
Guru

@NikoBelic  Could you please elaborate your issue?

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

avatar
New Contributor
Hi Asish,

Thanks for looking into this query.

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

avatar
Guru

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

avatar
New Contributor

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

avatar
Guru

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