The Wide Column model is similar to the data model of Bigtable or HBase and is suitable for various scenarios such as the storage of metadata and big data. The Wide Column model stores data in data tables. A single data table can store petabyte-level data and support tens of millions of queries per second (QPS). This topic describes the features of the Wide Column model supported by the Tablestore CLI
Features
The following table describes the features of the Wide Column model supported by the Tablestore CLI
Feature | Description |
You can perform operations on data tables. For example, you can create a table, use a table, query the names of tables, and delete a table. | |
You can perform basic read and write operations on data in data tables. For example, you can insert, read, scan, import, and export data, and update and delete a single row of data. | |
You can perform operations on secondary indexes. For example, you can create a secondary index, select a secondary index, query data by using a secondary index, export data by using a secondary index, and delete a secondary index. | |
You can perform operations on search indexes. For example, you can create a search index, query data by using a search index, and delete a search index. | |
You can perform operations related to Tunnel Service. For example, you can create a tunnel, simulate data consumption by using a tunnel, and delete a tunnel. | |
You can execute SQL statements to perform operations related to data query. For example, you can execute SQL statements to enter the SQL mode, create a mapping table, query data, and delete a mapping table. |