Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


The Presto DELETE statement has several known limitations. Review Presto DELETE limitations for more information.

Continue to these tasks.

Table of Contents


  • Basic knowledge of Treasure Data, including the TD Toolbelt

  • Understanding of Presto or Hive


  • Presto DELETE Statement Syntax.

  • Partial Delete: Efficient for small tables because it reloads the entire table

  • Partial Delete based on TIME Column: Efficient for huge tables. You take a superset of rows, which includes rows to be deleted and filtered based on the time column.