https://community.cloudera.com/t5/Support-Questions/Can-t-Delete-Saved-Queries/m-p/176423#M138673 <P><A rel="user" href="https://community.cloudera.com/users/44374/danielthomas.html" nodeid="44374">@Daniel Thomas<BR /></A></P><P>You will need to enable the DEBUG log inside the view specific log4j properties like following to see the savedQuery deletion logging.<BR /><BR /><STRONG>Example:</STRONG><BR />1. Edit the following file and change the following entry from INFO to DEBUG as following:</P><PRE># grep DEBUG /var/lib/ambari-server/resources/views/work/HIVE\{2.0.0\}/view.log4j.properties log4j.logger.org.apache.ambari.view.hive20=DEBUG,hive20</PRE><P><BR />2. Restart ambari-server and the try deleting saved query.</P><PRE># ambari-server restart # curl -H "X-Requested-By: ambari" -u admin:admin -X DELETE <A href="http://localhost:8080/api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/savedQueries/1" target="_blank">http://localhost:8080/api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/savedQueries/1</A></PRE><P><BR />3. Now review the following log.</P><PRE>30 Oct 2017 19:17:54,800 DEBUG [ambari-client-thread-26] [HIVE 2.0.0 AUTO_HIVE20_INSTANCE] DataStoreStorage:123 - Deleting org.apache.ambari.view.hive20.resources.savedQueries.SavedQuery:1</PRE><P>.</P><P>Here in the above logging we see that the saved Query with ID =1 is deleted.</P><P><A rel="user" href="https://community.cloudera.com/users/44374/danielthomas.html" nodeid="44374"></A> </P> Tue, 31 Oct 2017 02:21:15 GMT jsensharma 2017-10-31T02:21:15Z