Tablestore allows you to compute and analyze data by using a tool, such as MaxCompute, Spark, Hive, Hadoop MapReduce, Function Compute, Realtime Compute for Apache Flink, Presto, Tablestore search index, or Tablestore SQL query.
Select an analysis tool
Tablestore supports multiple data models, such as the Wide Column model and the TimeSeries model. The supported analysis tools vary based on the data model. You can select an analysis tool based on your business scenario.
Tool | Applicable model | References | Description |
MaxCompute | Wide Column | You can use the MaxCompute client to create an external table and use the external table to access Tablestore data. | |
Spark | Wide Column | You can use Spark to perform complex computing and analysis on Tablestore data that is accessed by using E-MapReduce (EMR) SQL or DataFrame. | |
Hive or Hadoop MapReduce | Wide Column | You can use Hive or Hadoop MapReduce to access a Tablestore table. | |
Function Compute | Wide Column | You can use Function Compute to perform real-time computing on the incremental data in Tablestore. | |
Realtime Compute for Apache Flink |
| You can use Realtime Compute for Apache Flink to access source tables, dimension tables, or result tables in Tablestore to compute and analyze big data. Data tables can be used as source tables, dimension tables, or result tables. Time series tables can be used only as result tables. | |
PrestoDB | Wide Column | After you connect PrestoDB to Tablestore, you can execute SQL statements to query and analyze data in Tablestore, write data to Tablestore, and import data to Tablestore by using PrestoDB. | |
Tablestore search index | Wide Column | Search indexes are used for multi-dimensional data queries and statistical analysis in big data scenarios based on inverted indexes and column stores. Tablestore provides the search index feature to meet your data analysis requirements such as obtaining extreme values, counting rows, and grouping data. If your business requires multi-dimensional queries such as queries based on non-primary key columns, Boolean queries, and fuzzy queries, you can create a search index based on the fields that you need. Then, you can query and analyze the data by using the search index. | |
Tablestore SQL query |
| The SQL query feature of Tablestore provides a unified access interface for multiple data engines. You can use the SQL query feature to perform complex queries and analysis on data in Tablestore in an efficient manner. |
Billing
You are charged for the read and write throughput that is consumed when you use compute engines to access Tablestore. For more information, see Billing overview.