I used the RestAPI to create a bunch of saved queries. Right now I cannot delete either the queries created via the API or new queries I save from the GUI.
When clicking the "x" to delete the query, I'm prompted "Do you want to delete the saved query?" and I click confirm. The popup closes, but the query remains in the list. I've also refreshed the page to make sure it wasn't just a display problem.
Has this behavior been seen before? Are there log files I should watch to find out where the process is failing? I'm not getting any error messages in the GUI.
It might be a browser cache issue . Can you please try with "Incognito Mode" (Private Mode") of your browser to see if Browser Caching is not causing any issue. If you are using IE browser then it might be related to that.
As an alternate approach, Can you please try this:
1). Try to get the list of savedQueryes to find out the saved query ID that you want to delete
@Jay SenSharma When I tail the Ambari server log while attempting to delete, there is no new events written. Confirmed it works for other Ambari users, but no logs are written for successful saved query deletes either.
@Jay Kumar SenSharma There is definitely more logs coming in now, but no messages when trying to delete from the Ambari Views Hive 2.0 interface. Deleting using the curl commands via the RestAPI still works fine.
I've tested this with multiple Ambari users as well. Mixed results. When using a user with no imported queries (none created with the rest API) it seemed like I created a saved query from the web UI, couldn't delete. Deleted with RestAPI, then could create and delete from the GUI. However, the same approach didn't seem to work in an account that had imported queries.
It isn't a cache thing. Tried incognito, but still couldn't delete.
The curl commands did work, but I wouldn't expect end users to be able to do this. That said, it seems to only be affecting the admin user right now. I tried another account and it can create and delete queries fine.
I was using Ambari 18.104.22.168. I found the support page for Ambari View 22.214.171.124 for Hive 2 and it shows a little different. My views has "X"s next t othe items to delete, but the documentation shows gear icons to either delete or show the query history. I upgraded my version from 126.96.36.199->188.8.131.52, but my view looks the same (and still doesn't work).