This article explains how to delete your imported data by using the
td table:partial_delete command.
Table of Contents
- Basic knowledge of Treasure Data, including the toolbelt.
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
--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.