clickhouse jdbc 通过server写入数据，不会将任务分发给worker，直接连接worker，又会报错

[yijiluo]

(you don't have to strictly follow this form)

Enhancement

clickhouse jdbc 通过server写入数据（insert values），不会将任务分发给worker，但是直接连接worker写入，clickhouse jdbc 默认会先对写入表执行select语句，此时会报错：DB::Exception: Worker group is not set，因为 worker write不能执行read操作。

[yijiluo]

也可能是spark处理jdbc写入的时候，发了一个查询请求，发到 worker write，就会报错，但是发送insert values请求，就是正常的

[yijiluo]

[yijiluo]

clickhosue jdbc 获取列信息的时候，也会报错

[nudles]

(you don't have to strictly follow this form)

Enhancement

clickhouse jdbc 通过server写入数据（insert values），不会将任务分发给worker，但是直接连接worker写入，clickhouse jdbc 默认会先对写入表执行select语句，此时会报错：DB::Exception: Worker group is not set，因为 worker write不能执行read操作。

@yijiluo what's your cluster configuration? 1 server + x default workers + y write workers?
Do you mean that the server never forwards the insert requests to the write workers?

[yijiluo]

(you don't have to strictly follow this form)

Enhancement

clickhouse jdbc 通过server写入数据（insert values），不会将任务分发给worker，但是直接连接worker写入，clickhouse jdbc 默认会先对写入表执行select语句，此时会报错：DB::Exception: Worker group is not set，因为 worker write不能执行read操作。

@yijiluo what's your cluster configuration? 1 server + x default workers + y write workers? Do you mean that the server never forwards the insert requests to the write workers?

yes，my cluster is 1 server + 2 default workers + 3 write workers.
If I use clickhouse jdbc to connect to byconity, and send insert values requests, the server CPU load and disk IO wait will be high, and woker write will not have much load. This issue has been reported in the wechat community group and has been replied to. Currently, insert values requests will not be executed by woker write

[skyoct]

@yijiluo Hi, You can refer to #722.

[yijiluo]

@yijiluo Hi, You can refer to #722.

Yeah, I got it. I set <prefer_cnch_catalog>1</prefer_cnch_catalog> in user.xml on woker write, and i can write by http, when I use clickhouse jdbc to write , it send select to worker write and report error, please see it.