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 ...
I just noticed that it is not possible to execute the java.sql.Connection.prepareStatement(String sql, int option) method with option on java.sql.Statement.NO ...