Versions Compared

Key

  • 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
excludeLimitations

Prerequisites

  • 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.

...