Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

How are you protecting Hive views

New Contributor

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


Super Collaborator

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

Super Collaborator



VIEWS are stot=red in TBLS table i.e in Hive metadata. You can create a database dump as a backup.


Please follow to create database dump for mysql


Please follow 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?

Super Collaborator

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.