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.
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-18.104.22.168/bk_ambari-views/content/section_saved_queri...
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.
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.