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

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

My installation doesn't have any extra .js files in this directory on the ambari server. Only these two. Mine are both dated Aug 30. ... View more

@Jay SenSharma 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 2.5.1.0. I found the support page for Ambari View 2.5.2.0 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 2.5.1.0->2.5.2.0, but my view looks the same (and still doesn't work). ... View more

This totally worked! Thanks @Jay SenSharma. Note: I use the previous saved query name from my json source file as the "title" in the new saved query. This allowed me to uniquely identify each query in the UI. If I ever revisit this code, I may also need to query Rest to see if a specific query already exists and replace it or increment the title name or something. -Dan ... View more

@Jay SenSharma I'm having trouble with this still. I tried what I actually wanted to post and, as below, tried with your sample. In both cases, I got a 500 server error. What am I doing wrong here? curl -u admin:admin -i -H 'X-Requested-By: ambari' -H 'Content-Type: application/json' -X PUT -d '{"file":{"fileContent":"SELECT * FROM store LIMIT 300;","hasNext":false,"page":0,"pageCount":1}}' http://hdp-node00:8080/api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/resources/file/%2Fuser%2Fadmin%2Fhive%2Fjobs%2Fhive-job-103-2017-10-18_12-09%2Fquery.hql HTTP/1.1 500 Server Error X-Frame-Options: SAMEORIGIN X-XSS-Protection: 1; mode=block X-Content-Type-Options: nosniff Pragma: no-cache Set-Cookie: AMBARISESSIONID=1woe7sttjidcw1rpi053bemdq5;Path=/;HttpOnly User: admin Content-Type: text/plain;charset=ISO-8859-1 Content-Length: 48 { "status": 500, "message": "Server Error" } ... View more

Ah, yes, I also looked at this as well and found I'd actually have to migrate the Hue database first as it currently uses the embedded Sqlite3 database, which doesn't support remote access. This was encouraging though and is likely very helpful for those who configured thier Hue for an external database in the first place. ... View more

Oh, and what I'm actually doing is migrating saved queries from Cloudera/Hue to Amabri Hive View. I found I can easily export queries to a list of JSON in Hue, but I don't see any native way of importing those to Ambari, so I'm going to try to load them via the Rest API using Python. ... View more

@Jay SenSharma, this is great stuff. Thank you for your super-fast response. Presumably this works the same for Hive 2, just change the path from /api/v1/views/HIVE/versions/1.5.0/instances/AUTO_HIVE_INSTANCE/ to /api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/ -Dan ... View more