DeleteMany/ Delete Query
mohit6522 opened this issue · 1 comments
mohit6522 commented
Is there a way to delete multiple records(on line of Oracle SQL Delete and Truncate)? Also can we delete based on column name, field names similar to using delete with where clause(no just on primary key)?
gmfeinberg commented
Hi,
There is a request that allows you to delete multiple rows as long as they share the same shard key. It is the MultiDeleteRequest. There's an example in examples/multi_data_ops.py
As for the second part of your question, no, it's not possible to delete via SQL query without a primary key.