A DELETE statement is used to delete one or more rows in a table, depending on how many rows satisfy the search condition that you specify in the WHERE clause. The WHERE clause also helps reduce unintentional DELETE commands.
DELETE statements are helpful for:
Cleaning up error records
Removing duplicate records
Removing unnecessary or unexpected results from result tables
A Presto DELETE of individual records from tables offers more flexibility than the td_partial_delete command.
Syntax
DELETE FROM <table_name> [ WHERE <condition> ]
Where:
<table_name> is the name of the table for deletion
<condition> is the clause to specify a search condition
Examples
Delete all line items shipped by air:
DELETE FROM lineitem WHERE shipmode = 'AIR'
Delete all event logs from a July 1st, 2017 UTC:
DELETE FROM lineitem WHERE TD_TIME_RANGE(time, '2017-07-01','2017-07-02')