[Explore] Stop button for queries doesn't work?

[vylc]

Stop button functionality, when pressed:
(1) Cancel query on DB side
(2) Reset explore view to state before query was run
(3) Currently, when query is running, user is allowed to modify selections on left hand nav
(a) When stop button is depressed, should stop current query and persist these selections
(b) Could also not allow user to change selections when query is being run (ie. grey out selectors)
I think a is preferable, but both are acceptable.

• [ x] I have checked the superset logs for python stacktraces and included it here as text if any
• [ x] I have reproduced the issue with at least the latest released version of superset
• [ x] I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

Expected results

Actual results

Steps to reproduce

[mistercrunch]

fixed here:
#4301

[graceguo-supercat]

#4301 only stop query in front-end, the query is still running in DB side (but browser won't wait for response). It will be good feature to stop query on DB side.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[dpnsh]

@vylc were you able to solve this issue ?

[saurabh3091]

@dpnsh I figured the issue. You can fix this issue by adding

while polled.operationState in unfinished_states:
    session.refresh(query)

inside this while loop. I will create a PR for that in superset.

superset/superset/db_engine_specs/hive.py

Line 335 in 398a01f

while polled.operationState in unfinished_states:

[saurabh3091]

Can be tracked through this issue.