Tablestore:Data type mappings

Field data type in search indexes

Field data type in data tables

Description

Long

Integer

A 64-bit long integer.

Double

Double

A 64-bit double-precision floating-point number.

Boolean

Boolean

A Boolean value.

Keyword

String

A string that cannot be tokenized.

Text

String

A string or text that can be tokenized. For more information, see Tokenization.

Date

Integer and String

The Date data type. You can specify the format of data of the Date type. For more information, see Types of date data.

Geo-point

String

The coordinate pair of a geographical location, in the latitude,longitude format. Valid values of the latitude: [-90,+90]. Valid values of the longitude: [-180,+180]. Example: 35.8,-45.91.

Vector

String

The vector type. The value of a field of the Vector type is a string in the Float32 array format. The length of the array is the same as the number of dimensions of the field. For example, the number of dimensions of the vector string [1, 5.1, 4.7, 0.08] is 4.

Nested

String

The nested type. Example: [{"a": 1}, {"a": 3}].

Attribute

Type

Description

IsArray

Boolean

Specifies whether the value of the field is an array.

A value of true specifies that the value of the field is an array. Data written to the field must be a JSON array. Example: ["a","b","c"].

You do not need to specify the IsArray attribute for a nested field because a nested field is an array.

Data of the Array type can be used in all queries because arrays do not affect queries.

isVirtualField

Boolean

Specifies whether the field is a virtual column.

• If you set this attribute to true, the field is a virtual column. If the field is a virtual column, you must specify the source field that is mapped to the field in the data table. For more information, see Virtual columns.

• If you set this attribute to false, the field is not a virtual column. In this case, the data type of the field in the search index must match the data type of the column in the data table.