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')

  • No labels