[Bug] Cannot cancel StarRocks SQL

[ruanwenjun]

Code of Conduct

• I agree to follow this project's Code of Conduct

Search before asking

• I have searched in the issues and found no similar issues.

Describe the bug

Hi team,
We use kyuubi to submit starrocks sql.
It seems the starrocks sql can only be killed when its statement.cancel method executed.
However, kyuubi appears to have same behaves to client-side cancel and close operations.
Therefore, we are currently unable to kill SQL on Starrocks in Kyuubi.

Affects Version(s)

1.9.2

Kyuubi Server Log Output

Kyuubi Engine Log Output

Kyuubi Server Configurations

Kyuubi Engine Configurations

Additional context

No response

Are you willing to submit PR?

• Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
• No. I cannot submit a PR at this time.

[pan3793]

So we should propagate the Kyuubi JDBC driver operation to the JDBC engine? We can use the existing Hive Thrift protocol with additional key-value pairs to simulate such specific operations.

See more details on how Kyuubi JDBC driver implemented get/set catalog/schema

[ruanwenjun]

So we should propagate the Kyuubi JDBC driver operation to the JDBC engine? We can use the existing Hive Thrift protocol with additional key-value pairs to simulate such specific operations.

See more details on how Kyuubi JDBC driver implemented get/set catalog/schema

It seems we have already propagate the Kyuubi JDBC driver operation to the JDBC engine, but we use close to correspond to cancelOperation. In some driver e.g mysqk the close method will not cancel the sql and will block untill the statement finished. I submit #7249 try to fix this.