This topic describes the limits of search index.

Mapping

Item Maximum value Description
Number of index fields 200 The maximum number of fields that can be indexed.
Array length 256 The maximum number of elements in an array.
Number of the fields that can be used for sorting and aggregation 100 The maximum number of fields that can be used for sorting and aggregation.
Number of nested levels 1 The maximum number of nested levels.
Number of child rows in nested fields 256 The maximum number of rows that can be nested within the nested fields.
Number of nested child fields 25 The maximum number of fields that can be nested.
Total length of primary key columns 1000 The total length of all primary key columns in each row can be a maximum of 1,000 bytes.
Total length of strings in primary key columns 1000 The total length of strings in all primary key columns of each row can be a maximum of 1,000 bytes.
length of string (indexed as KEYWORD) in a single attribute column 4KB None.
length of string (indexed as TEXT) in a single attribute column 2MB Same as the length limit on attribute columns in tables.
Length of wildcards in a query 10 The length of wildcards that are contained in a query can be a maximum of 10 characters.

Search

Category Item Maximum value Description
General limits offset + limit 10000 To query more than 10,000 rows, specify the next_token parameter.
limit 100
  • When you call the SearchIndex operation to query data of a specified column, you can set the limit parameter to a value up to 1000 if the search index contains the data.
  • If your business requirements are not met due to the limit, submit a ticket.
timeout 10s None.
CU 100000
  • This limit does not apply to scanning and analysis requests.
  • If your business requirements are not met due to the limit, submit a ticket.
QPS 100000
  • The upper limit for lightweight transaction processing is 100,000 queries per second (QPS).
  • If your business requirements are not met due to the limit, submit a ticket.
Aggregation Aggregations at the same level 5 The number of Aggregations is recalculated each time you add a new aggregation to SubGroupBy.
GroupBys at the same level 5 The number of GroupBys is recalculated each time you add a new GroupBy to SubGroupBy.
Nested levels for a GroupBy 3 The root GroupBy is also calculated as a nested level.
Filters in a GroupByFilter 10 None.
Groups returned by a GroupByField 2000 None.
Ranges in a GroupByRange 100 None.
Ranges in a GroupByGeodistance 10 None.

ParallelScan

Category Item Description
General limits offset + limit Parallel scan does not support specifying the both the offset and limit parameter for paging. Returned results are displayed sequentially.
limit The maximum value is 2000.
CU Tablestore does not impose limits on CUs.
QPS Tablestore does not impose limits on CUs.
Maximum concurrent tasks The value of MaxParallel in the response to the ComputeSplites operation.

Index

Item Maximum value Description
Rate 50,000 rows/s
  • When data is written to a table for the first time or when a large amount of data is required to be written in a short span of time, it takes several minutes for Tablestore to perform load balancing.
  • The rate for TEXT field-based indexing is limited to 10,000 rows per second because this indexing consumes more CPU resources for tokenization.
  • If your business requirements are not met due to the limit, submit a ticket.
Synchronization latency 10s
  • The value is smaller than 10 seconds when the writing rate is steady.
  • The synchronization latency is within one minute in most cases.
  • It takes up to one minute to initialize new index.
Count of rows 20 billion If your business requirements are not met due to the limit, submit a ticket.
Total size 10TB If your business requirements are not met due to the limit, submit a ticket.

Other limits

Item Value
Supported region China (Hangzhou), China (Shanghai), China (Beijing), China (Zhangjiakou-Beijing Winter Olympics), China (Shenzhen), China (Hong Kong), Singapore, US (Silicon Valley), and India (Mumbai)
Region to support Australia (Sydney) and UK (London)
Note If your business requirements are not met due to the limit, submit a ticket at the Alibaba Cloud official website. Describe the scenario, items, requirements, and reasons in the ticket. Your requirements will be taken into consideration during future development.