This topic describes how to write and query time series data in Tablestore.
Write time series data
After you create a time series table, you can select an appropriate method to write time series data based on your business requirements.
-
You can use an SDK to write multiple rows of time series data to a time series table at the same time. For more information, see Write time series data.
-
If you want to write time series data in batches, write data to multiple tables at a time, or obtain the write status, you can use Time Series Writer. For more information, see Use Time Series Writer to write time series data.
-
If you want to migrate data from a Kafka data source to a time series table in Tablestore, you can use Tablestore Sink Connector. For more information, see Sync Kafka data to a time series table.
Note-
In IoT storage scenarios, you can store Kafka data, EMQX data, and IoT Platform data in time series tables of Tablestore. For more information, see Time series data ingestion.
-
After you compute and analyze data by using Flink, you can use time series tables of Tablestore to store the output results. For more information, see Flink tutorials.
-
In some scenarios, if you want to migrate time series data from one time series table to another, you can use the Data Integration service of DataWorks. For more information, see Synchronize data from a time series table to another time series table.
-
If you create an analytical storage for a time series table, the analytical store automatically synchronizes data from the time series table when you write time series data to the time series table.
Query time series data
-
After you write time series data to a time series table, you can query time series data that meets specific conditions based on your business requirements.
-
After you create a mapping table for a time series table, you can execute SQL statements to query time series data.
-
After you write time series data to a time series table, if you need to use analytical storage to query and analyze time series data of a specific timeline, you can use SELECT statements to query time series data after you create an attachment relationship for the analytical storage.