Blynk-Technologies / clickhouse4j

Lighter and faster alternative for the official ClickHouse JDBC driver
Other
213 stars 38 forks source link

how can i implements batch delete? #91

Open DaC1989 opened 3 years ago

DaC1989 commented 3 years ago

is there a way to use delete in batch mode? i get this error:

Query must be like 'INSERT INTO [db.]table [(c1, c2, c3)] VALUES (?, ?, ?)'. Got: ALTER TABLE `T_HR_C020302` DELETE WHERE `EXTLS` = ? AND `EXTSS` = ?
doom369 commented 3 years ago

Query is correct. where exactly do you get this message from?