[jira] [Commented] (AMBARI-22759) [Hive Views 2.0] Deleting a Saved query is Buddy when Mutliple Queries exist in same Name

["Akhil S Naik (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-22759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16321891#comment-16321891 ] 

Akhil S Naik commented on AMBARI-22759:
---------------------------------------

Attached the Fix of the issue.


web client will seek for the record from the saved-query's using the id and will delete the record and reload the table.

Tested and working fine in latest ambari .



> [Hive Views 2.0] Deleting a Saved query is Buddy when Mutliple Queries exist in same Name
> -----------------------------------------------------------------------------------------
>
>                 Key: AMBARI-22759
>                 URL: https://issues.apache.org/jira/browse/AMBARI-22759
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-views
>    Affects Versions: 2.5.2
>         Environment: ambari 2.5.2 
>            Reporter: Akhil S Naik
>         Attachments: hive_duplicate_saved_query_issue.png
>
>
> Reproduction scenario :
> Save some queries under same name .
> !https://issues.apache.org/jira/secure/attachment/12905639/hive_duplicate_saved_query_issue.png!
> delete one of the saved query 
> *hive views is deleting some other query randomly and the query i deleted still exists in saved query even after refresh of page.*
> Root Cause : 
> After the Fix of AMBARI-19958, Hive views is querying the saved Queries with FilterBy queryId and server is responding mutiple queries as all the queries has same name,
> then Web client is deleting the first record from these savedQueries due to which this issue is happening.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)