c.c.jdbc.parser.ClickHouseSqlParser - Parse error

[KeKeValue]

c.c.jdbc.parser.ClickHouseSqlParser - Parse error at line 1, column 47. Encountered: ?. If you believe the SQL is valid, please feel free to open an issue on Github with this warning and the following SQL attached.
TRUNCATE TABLE shanhu_subject_info on cluster ?

[KeKeValue]

In my Spring Boot project, I am using ClickHouse to first clear the table data and then insert data into it. However, when executing the statement to clear the table, I received a "Parse error."
Here is the code:
Call site: xxMapper.truncate(clusterName);
MyBatis mapper interface method: void truncate(String clusterName);
MyBatis XML file:

TRUNCATE TABLE shanhu_subject_info on cluster #{clusterName}

Configuration details: .yml
clickhouse:
url: jdbc:clickhouse://ip:8123/database_name
username: user
password: pwd
driver-class-name: com.clickhouse.jdbc.ClickHouseDriver

[chernser]

Good day, @KeKeValue !
What is the exact SQL statement?
Just in the first message it is with ? and in the last it is with name parameter #{clusterName}
I would appreciate if you can give an example code that fails.

Thanks!

[KeKeValue]

My intention is to clear the data of one local table on a specific ClickHouse cluster. So, I executed the following SQL:
TRUNCATE TABLE shanhu_subject_info ON CLUSTER #{clusterName}
The value for the SQL placeholder #{clusterName} is configured in the configuration file, and the value corresponds to the actual ClickHouse cluster name.

[KeKeValue]

Since the cluster names are different in each environment, I have configured the corresponding cluster names in the configuration files for both QAS and PRD environments. When executing the SQL, I use a placeholder to dynamically select the appropriate cluster name for QAS or PRD environments.

[KeKeValue]

@chernser brother, can you help me take a look at this issue