How to delete a few rows via SQL?

In QuestDb Update and Delete statement are not supported. At least now. The ways to delete data are: - Drop a partition - Write a copy of the table without the rows you want to delete, drop table and then rename the table to the one you wanted. Something like Create table mytablecopy AS ( SELECT * FROM mytable where columnvalue != 2 ) Timstamp(...) PARTITION BY ...; DROP TABLE mytable; RENAME table mytablecopy TO mytable; These are costly workarounds for exceptional cases.

Context: Stack Overflow #65976247 (accepted answer, 10 votes): is there a way to delete a view rows matching a query in QuestDB? I can't find any statement allowing me that. This would be the best option: delete from mytable where columnvalue==2; Thanks!

Matched source

Source: Published skill Original query: "How to delete a few rows via SQL?" Key terms: delete, rows

Source: Stack Overflow #65976247 (accepted answer, 10 votes): is there a way to delete a view rows matching a query in QuestDB? I can't find any statement allowing me that. This would be the best option: delete from mytable where columnvalue==2; Thanks!

Verified resolution: In QuestDb Update and Delete statement are not supported. At least now. The ways to delete data are: - Drop a partition - Write a copy of the table without the rows you want to delete, drop table and then rename the table to the one you wanted. Something like Create table mytablecopy AS ( SELECT * FROM mytable where columnvalue != 2 ) Timstamp(...) PARTITION BY ...; DROP TABLE mytable; RENAME table mytablecopy TO mytable; These are costly workarounds for exceptional cases.

Source URL: https://stackoverflow.com/questions/65976247/how-to-delete-a-few-rows-via-sql