2

We use regular insert for inserting into EmbeddedRocksDB tables.

Inserting a new value for a key updates the value.

There is no DELETE FROM rocksTable where xxx in Clickhouse.

Inserting NULL also doesn't work, which just sets default values for the value part.

So, how do we delete a row, based on the key?

ramazan polat
  • 7,111
  • 1
  • 48
  • 76

1 Answers1

0

Delete is not implemented. You can add column (flag) deleted and update it using insert and select only not deleted rows.

Denny Crane
  • 11,574
  • 2
  • 19
  • 30