td_partial_delete>: Delete range of Treasure Data table

td_partial_delete> operator deletes records from a Treasure Data table.

Please be aware that records imported using streaming import can’t be deleted for several hours using td_partial_delete. Records imported by INSERT INTO, Data Connector (MapReduce Executor), and bulk imports can be deleted immediately.

Time range needs to be hourly. Setting non-zero values to minutes or seconds will be rejected.

+step1:
  td_partial_delete>: my_table
  database: mydb
  from: 2016-01-01T00:00:00+08:00
  to:   2016-02-01T00:00:00+08:00

Secrets

  • td.apikey: API_KEY The Treasure Data API key to use when running Treasure Data queries.

Parameters

  • td_partial_delete>: NAME

    Name of the table.

    Examples:

    td_partial_delete>: my_table
    
  • database: NAME

    Name of the database.

    Examples:

    database: my_database
    
  • from: yyyy-MM-ddTHH:mm:ss[Z]

    Delete records from this time (inclusive). Actual time range is :command:[from, to). Value should be a UNIX timestamp integer (seconds) or string in ISO-8601 (yyyy-MM-ddTHH:mm:ss[Z]) format.

    Examples:

    from: 2016-01-01T00:00:00+08:00
    
  • to: yyyy-MM-ddTHH:mm:ss[Z]

    Delete records to this time (exclusive). Actual time range is :command:[from, to). Value should be a UNIX timestamp integer (seconds) or string in ISO-8601 (yyyy-MM-ddTHH:mm:ss[Z]) format.

    Examples:

    to: 2016-02-01T00:00:00+08:00
    
  • endpoint: ADDRESS

    API endpoint (default: api.treasuredata.com).

  • use_ssl: BOOLEAN

    Enable SSL (https) to access to the endpoint (default: true).