Tablestore:Query time series data

Overview

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

When you query time series data, you must specify the time series information and query conditions based on your business requirements.

• You can specify whether to read data in reverse chronological order to obtain the latest data.

• You can specify the data columns that you want to return. By default, all data columns are returned.

• You can specify the maximum number of rows to return at a time.

Procedure

You can query time series data within a specific time range in a time series in the Tablestore console.

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 time series table that you want to manage.

4. On the Query Data tab, click Query Data in the Actions column of the time series that you want to manage.

5. Specify query conditions.

   1. By default, the query results are sorted in chronological order. If you want to read data in reverse chronological order, set Reverse Chronological Order to No.

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

6. Click Search.

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

   Display data in a list

   

   Display data in a graph

   

Development integration

You can use the following Tablestore SDKs or the Tablestore CLI to query time series data:

• Use Tablestore 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 immediately query the data that I just wrote to a time series table?

References

• You can also execute SQL statements 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 Tablestore to Grafana.

• To store time series data at low costs and quickly query and analyze time series data, you can use time series analytics stores. For more information, see Analytical store for time series.