This topic describes the limits on search indexes.

Mapping

Item Maximum value Description
Number of indexed fields 500 The maximum number of fields that can be indexed.
Array length 256 The maximum number of elements in an array.
Number of fields for EnableSortAndAgg 100 The maximum number of fields that can be sorted and aggregated.
Number of nested levels 5 A maximum number of five levels can be nested.
Number of child rows in a nested field 256 The maximum number of rows that are contained in a nested field.
Number of nested fields 25 The maximum number of child fields that can be nested.
Total length of primary key columns 1,000 bytes The total length of all primary key columns cannot exceed 1,000 bytes.
Total length of STRING in primary key columns 1,000 bytes The total length of STRING in all primary key columns cannot exceed 1,000 bytes.
Length of STRING indexed as KEYWORD in an attribute column 4 KB None.
Length of STRING indexed as TEXT in an attribute column 2 MB The value is the same as the length limit on an attribute column in a table.
Length of wildcards in a query 20 The length of wildcards cannot exceed 20 characters.

Search

Category Item Maximum value Description
General limits offset+limit 10000 To increase the number of returned rows, specify the next_token parameter.
limit 100
  • When you call the Search operation to query data of a specified column, the maximum value of the limit parameter can increase to 1000 if the data is contained in search indexes.
  • To increase the number of returned rows,submit a ticket.
timeout 10s None.
CU 100,000
  • This limit does not apply to scanning and analysis requests.
  • To increase the number of capacity units (CUs),submit a ticket.
QPS 100,000
  • The upper limit for lightweight transaction processing is 100,000 queries per second (QPS).
  • To increase QPS,submit a ticket.
Aggregation and GroupBy Number of Aggregations at the same level 5 The number of Aggregations is recalculated each time you add a new Aggregation to SubGroupBy.
Number of GroupBys at the same level 5 The number of GroupBys is recalculated each time you add a new GroupBy to SubGroupBy.
Number of nested GroupBys 3 The root GroupBy is also calculated as a nested level.
Number of Filters in GroupByFilter 10 None.
Number of groups returned by GroupByField 2,000 None.
Number of Ranges in GroupByRange 100 None.
Number of Ranges in GroupByGeodistance 10 None.

ParallelScan

Category Item Description
General limit offset+limit You cannot specify the offset and limit parameters for paging when you use parallel scan. Returned results are displayed sequentially from the beginning.
limit The maximum value is 2000.
CU None.
QPS None.
Maximum number of concurrent tasks The value of the MaxParallel parameter. The value is contained in the data that is returned by calling the ComputeSplits 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 written in a short period of time, Tablestore performs load balancing within seconds.
  • The rate of indexing on TEXT fields is limited to 10,000 row/s because this indexing consumes a larger number of CPU resources for tokenization.
  • To increase the rate,submit a ticket.
Sync latency 3s
  • In most cases, the sync latency is within 3s.
  • It takes at most 1 minute to create an index.
Number of rows 50,000,000,000 To increase the number of returned rows,submit a ticket.
Total size 50 TB To increase storage capacity,submit a ticket.

Additional limits

Search indexes are available in the following regions: China (Hangzhou),China (Shanghai), China (Beijing), China (Zhangjiakou), China (Shenzhen), China (Hong Kong), Singapore (Singapore), Australia (Sydney), Germany (Frankfurt), UK (London), US (Silicon Valley), US (Virginia), and India (Mumbai).

Note To use a wider range of regions,submit a ticket. When you submit a ticket, you must describe the limits and the limit values. You must also describe the scenarios where the new limits are used and the reasons why the new limits are required. Your requirements on the tickets will be considered during future development.