In ClickHouse there is a table system.processes which contains info about all queries running right now. And we can kill any too long query.
This table works great. I can run any long query any type. Then I can see that query in system.processes and kill that query. I checked this functionality in DBeaver. Also I tested that in Superset / SQLLab. All queries running in SQLLab I can see in system.processes except of SELECT queries. I want to see all queries from Superset, not only ins/upd/del but also SELECT queries.
How to reproduce the bug
Success case: I run in Superset query: "insert into eso.t2(v) SELECT v from eso.t2" and can see that query in system.processes.
I received workaround for this issue from @den-crane - https://github.com/ClickHouse/ClickHouse/issues/62604#issuecomment-2051992160
TLDR: add sleep(1) to SELECT query. So, instead this "SELECT * FROM t" I should write this: "SELECT sleep(1),* FROM t"