To kill a slow query through the ODBC interface, we can normally use "sqlcancel". However, "clickhouse-odbc" does not implement this function, and there will be no response after calling this interface. Therefore, the only way to kill the slow query is through "kill query" in "clickhouse-server". the mysql odbc and oracle odbc all works.
To kill a slow query through the ODBC interface, we can normally use "sqlcancel". However, "clickhouse-odbc" does not implement this function, and there will be no response after calling this interface. Therefore, the only way to kill the slow query is through "kill query" in "clickhouse-server". the mysql odbc and oracle odbc all works.
from odbc.cpp,we find the sqlcancel API,it only works when cursor happend.