This article explains how to delete your imported data by using the td table:partial_delete command.

Prerequisites

• Basic knowledge of Treasure Data, including the toolbelt.

Deletion

The td table:partial_delete command lets you delete your imported data within a specific table by specifying the time range. Please note that because the stored data is partitioned per hour, the arguments for --from and --to must be divided by 3600 (1 hour).

$ td table:partial_delete --help
usage:
  $ td table:partial_delete <db> <table>

example:
  $ td table:partial_delete example_db table1 --from 1341000000 --to 1341003600

description:
  Delete logs from the table within the specified time range

options:
  -t, --to TIME                    end time of logs to delete
  -f, --from TIME                  start time of logs to delete
  -w, --wait                       wait until the job is finished

The data deletion is executed as a job. This means that you can confirm its status by issuing the td jobs command (see Job Management). The -w option lets you wait until the job is finished.

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels. Live chat with our staffs also work well.