Tablestore:Get started with the TimeSeries model

Step 1: Create a time series table

Create a time series table to store time series data.

For information about sample scenarios and table schemas, see Sample scenarios.

1. Go to the Instance Management page.

   1. Log on to the Tablestore console.

   2. In the top navigation bar, select a resource group and a region.

   3. On the Overview page, click the name of the instance that you want to manage or click Manage Instance in the Actions column of the instance.

2. In the lower part of the Instance Details tab, click the Time Series Tables tab.

3. On the Time Series Tables tab, click Create Time Series Table.

   Note

   You can also click Generate Demo with One Click to create a test table that has sample data for a quick start. When you create a time series table, the system performs specific initialization operations. You must wait for dozens of seconds before the time series are displayed.

4. In the Create Time Series Table dialog box, set the Name parameter to car_example and retain the default settings for other parameters.

   

5. Click Create.

   After you create the time series table, you can view the time series table on the Time Series Tables tab. If the time series table is not displayed in the list of time series tables, click the icon to refresh the list of time series tables.

   

Step 2: Write data to the time series table

Write time series data to the time series table. Time series data consists of metadata and data. If you do not create metadata before you write the time series data, the system automatically extracts the metadata from the written data.

1. On the Time Series Tables tab, click the name of the time series table that you want to manage, and then click the Query Data tab. You can also click Manage Data in the Actions column of the time series table.

2. (Optional) Create a time series.

   1. On the Query Data tab, click Add Time Series.

   2. In the Add Time Series dialog box, configure the metadata of the time series, such as the metric name and data source.

      

   3. Click Add.

3. Insert data.

   1. Click Query Data in the Actions column of the time series that you want to manage.

   2. Click Insert Data.

      The system automatically obtains the metadata of the selected time series.

   3. In the Insert Data dialog box, configure the Time and Attribute Column parameters.

      

   4. Click OK.

Step 3: Query time series data

Query the data in a time series within a specific time range.

For information about how to query data in a time series table by using SQL statements, see Use SQL to query time series data.

If you are unsure about the information of the time series that you want to query, you can specify multiple conditions to retrieve the time series and then query time series data. For more information, see Retrieve time series.

1. On the Query Data tab of the time series table, find the time series that you want to manage and click Query Data in the Actions column.

2. Specify query conditions.

   1. By default, the query results are sorted in chronological order. To sort query results in reverse chronological order, set the Reverse Chronological Oder parameter to Yes.

   2. Select a search method and specify a time range.

3. Click Search.

   The data that meets the conditions is displayed on the Query Data tab. The query results can be displayed in a list or a figure.