Time series table operations

Prerequisites

An installed CLI with configured access credentials. For more information, see Tablestore CLI.
A Tablestore instance. For more information, see Instance operations.

Create a time series table with an optional time-to-live (TTL) setting.

create -m timeseries -t <tableName> --ttl <timeToLive>

Parameter	Required	Description
-m, --model	Yes	The table type. Set this parameter to timeseries to create a time series table.
-t, --table	Yes	The name of the time series table.
--ttl	No	The TTL of data in the time series table, in seconds. Default value: -1 (data never expires). Valid values: an integer greater than or equal to 86400 (one day), or -1. Important Data expiration is calculated from the timestamp column that you specify, not from the write time.

Example

Create a time series table named mytable where data never expires.

create -m timeseries -t mytable --ttl -1

List all time series tables in the current instance.

list_table --ts

Select a time series table for subsequent data operations.

use --ts -t <tableName>

Parameter	Required	Description
--ts	Yes	Operates on a time series table.
-t, --table	Yes	The name of the time series table.

Example

use --ts -t mytable

View the configuration of a time series table.

desc --ts -t <tableName>

Parameter	Required	Description
--ts	No	Operates on a time series table. Optional if a time series table is already selected with `use --ts`.
-t, --table	No	The name of the time series table. Optional if a table is already selected with `use`.
-f, --print_format	No	The output format. Valid values: `json` (default) and `table`.
-o, --output	No	Saves the table information to a local JSON file.

Example

desc --ts -t mytable

Update the TTL of a time series table.

alter --ttl <timeToLive> --ts

Parameter	Required	Description
--ts	Yes	Operates on a time series table.
--ttl	Yes	The TTL of data in the time series table, in seconds. Valid values: an integer greater than or equal to 86400 (one day), or -1 (data never expires). Important Data expiration is calculated from the timestamp column that you specify, not from the write time.

Example

Set the TTL of the current time series table to 86400 seconds (one day).

alter --ttl 86400 --ts

Drop a time series table and all its data.

drop -t <tableName> --ts -y

Parameter	Required	Description
-t, --table	Yes	The name of the time series table.
--ts	Yes	Operates on a time series table.
-y, --yes	Yes	Skips the deletion confirmation prompt.

Example

Drop the mytable time series table.

drop -t mytable --ts -y