Stop button for queries doesn't work in SQL Lab.

[saurabh3091]

The issue concerns hive/spark-thriftserver(maybe also presto but not tested) as the processing engine.
When a user runs a query on SQL Lab and later for any reason wants to stop it, it just stops on the frontend as solved here.
The query on the processing engines mentioned above still runs.
This PR aimed to solve the issue for other DBs but not hive. After it this PR was added to fix it but it still doesn't worrk.

How to reproduce the bug

1. Run any query in SQL Lab with hive/spark-thriftserver as backend processing engine.
2. Press STOP button on the UI.
3. Check the query engine, the query will still be running. You will still get the results on front end when the query finishes.

Expected results

The query should be killed on the query processing engine.

Actual results

Query keeps running on the processing engine. You will still get the results on the front end when the query finishes.

Environment

• browser type and version: Chrome/Firefox
• superset version: latest
• python version: 3.8

Checklist

Make sure to follow these steps before submitting your issue - thank you!

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

[rpmahesh2022]

SQL-Lab - query does not stop with the stop button. received the error "Failed at stopping query. 'UuFm_F97lp'"

the query continues to run even after I reboot the server.

[saurabh3091]

@rpmahesh2022 which backend do you use for query execution and which version of superset?

[DianaLyM]

Same issue: Connected to Apache Kyuubi, stop request returned: {“message”:“Could not cancel query”}.