On KILL QUERY error "expected string or bytes-like object" in Clickhouse DB about superset HOT 1 OPEN

Hey @berlicon! I'm here to assist you with any bugs, questions, and contribute to the repository. Let's tackle this issue together!

To resolve the "ClickHouse Connect (Superset) Error - expected string or bytes-like object" when executing the KILL QUERY command in Superset/SQL Lab connected to a ClickHouse database, ensure that the parameters passed to the command are of the correct type (string or bytes-like object).

Here's a code snippet to properly format the KILL QUERY command:

query_id = "091f6bf3-18b4-4977-89e7-ac9a038a242f"  # Ensure this is a string
kill_query_command = f"KILL QUERY WHERE query_id = '{query_id}'"

# Execute the command
database.execute(kill_query_command)

Make sure that query_id is a string. If query_id is obtained from another source, convert it to a string before using it in the KILL QUERY command.

If the issue persists, check the implementation of the execute method in your database connection to ensure it correctly handles the KILL QUERY command ^[1].

To continue talking to Dosu, mention @dosu.

from superset.