The way you use prepared statement is actually creating a insert query without telling the driver column types. It can be optimized by changing the query to INSERT INTO device_user (device_type,device ...

create a table in clickhouse create a prepared statement from a concatenated insert string containing the table name add multiple values to the prepared statement in a batch use executeLargeBatch ...