How to delete items using a timestamp?

Community
1

Hi!

Can I delete items using a timestamp?

Also is it possible to delete a specific item? eg id=1

2

There is no row level delete.

You can work round this using an extra column with a deleted flag, and set it with dedup inserts or UPDATE. Then, filter out these ‘deleted’ rows

Otherwise, you must drop partitions.