Support Questions
Find answers, ask questions, and share your expertise

How to restrict saving results of queries in HIVE View?

Explorer

I have a hive view user and wouldn't want him to save the query results. How should I go about restricting him from doing it.

4 REPLIES 4

Super Mentor

@Abhilash Chandra

The Saved Queries tab in the Hive View shows all the queries that have been saved by the current user. Users can click the gear icon to the right of the query list to view the history of a query or to delete it: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.2.0/bk_ambari-views/content/section_saved_queri...

.

Explorer

I am not tlking about the saved queries. I am saying about the query results itself. There is a option to download the results to HDFS / csv. I don't want my user to do that. I would want to restrict them from downloading any production data results.

Super Mentor

@Abhilash Chandra

Unfortunately it is not possible to disallow any specific user to now be able to save the results.

The "Save As" button in the Hive View can be tweaked little bit using the Java script manipulation a bit to disable the "Save As" permanently for all users though. But that is not a good solution.

Also the results will still be displayed in the UI after query execution and even the API response will have the JSON result. Which can not be restricted without a major Logic/UI change.

Explorer

Thats a good point. I would like to restrict save for all users. Can you tell me what needs to be manipulated to disable it.