GitHub user mt-iyamamoto created a discussion: SQL Lab queries can't be stopped when running on Athena
Running long-lasting queries on SQL Lab against an Athena connection can't be stopped. This really undermines the ability to use Superset in environments that rely on the AWS ecosystem. ## How to reproduce the bug 1. Open SQL Lab 2. With an Athena connection, write a query and execute it 3. Click on STOP 4. Failure message pops up on the UI (image below) ## Expected results 6. The query should be stopped ## Actual results We get the message `Failed to stop query.` on the UI ## Screenshots <img width="383" height="180" alt="image" src="https://github.com/user-attachments/assets/ec963ae6-3137-4119-8211-f6eb983029f9"; /> ## Environment - browser type and version: Google Chrome Version 142.0.7444.162 (Official Build) (arm64) - superset version: 5.0.0 - python version: 3.11.14 - pyathena version: 3.21.1 - source : AWS Athena ## Checklist - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are 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. ## Additional context 1. Issue very similar to [17011](https://github.com/apache/superset/issues/17011). However, this one was closed [given it was tested on an old version of Superset](https://github.com/apache/superset/issues/17011#issuecomment-2610842997) 2. Listed here as a feature request, given that query cancellation [isn't listed as an available feature of Superset for Athena connections](https://github.com/apache/superset/tree/81e561bdc96f191ad3d2a0262f42aa321482c3db/superset/db_engine_specs#core-platform--metadata-features) GitHub link: https://github.com/apache/superset/discussions/36415 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
