Tablestore:Query time series data

Overview

You can call the GetTimeseriesData operation to query time series data that meets specified conditions.

When you query time series data, you must specify the target time series and configure query conditions.

• You can specify whether to read data in reverse chronological order to retrieve the latest data points from a time series.

• You can specify which data columns to return. By default, the operation returns all data columns.

• You can specify the maximum number of rows to return in a single request.

Procedure

You can use the console to query data from a time series within a specific time range.

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 instance alias or click Manage Instance in the Actions column.

2. On the Instance Details tab, click the Time Series Tables tab.

3. On the Time Series Tables tab, click Manage Data in the Actions column of the target time series table.

4. On the Query Data tab, click Query Data in the Actions column of the target time series.

5. Set the query conditions.

   1. Query results are sorted chronologically by default. To retrieve data in reverse chronological order, set Reverse Chronological Order to Yes.

   2. Select a query method and set the time.

6. Click Search.

   The data that meets the query conditions is displayed on the Query Data tab. You can view the results as a list or a graph.

   List view

   On the query page, select a metric name (e.g., measure_9), a data source (e.g., data_3), and specify tags (e.g., cluster=cluster_3 and region=region_9). After you set the timestamp and click Query Data, the results appear in a list with columns of numerical data.

   Graph view

   Set the metric name to measure_9 and the data source to data_3. Configure the tags cluster=cluster_3 and region=region_9. Select Time Range for the query method and set it to 30 days. Then, click Query. In the results area, click the Graph tab. From the column list on the left, select the checkboxes for col_9_3_1 and col_9_3_2. A line chart appears in the main panel, plotting values against time. You can hover over the line to view the value of a specific data point.

Development integration

You can query time series data by using the Tablestore CLI or one of the following SDKs.

• Use SDKs

  • Java SDK: Query time series data

  • Go SDK: Query time series data

  • Python SDK: Query time series data

• Use the Tablestore CLI

FAQ

• How do I delete time series data?

• Can I query data immediately after it is written to a time series table?

Related topics

• You can also use SQL to query time series data. For more information, see Use SQL to query time series data.

• To visualize time series data, you can connect Tablestore to Grafana. For more information, see Connect to Grafana.

• To store time series data at a low cost while enabling fast queries and analysis, you can use time series analytics storage. For more information, see Analytics storage.