Tablestore:Data types

The Array data type is a composite data type and can be combined with primitive data types, such as Long, Double, Boolean, Keyword, Text, Date, and Geopoint, to construct complex data structures. For example, the combination of the Long data type with the Array data type is used to construct long arrays. A long array can contain multiple long integers. If one of the long integers is matched during a query, the corresponding row is returned. The Array data type is suitable for storing a collection of the same type of data.

If the data type of a field in a search index is a combination of the Array data type with a primitive data type, such as Long or Double, the field in the data table for which the search index is created must be of the String type, and the field in the search index must be of the corresponding primitive data type. For example, the price field is of the Double Array type. The value of the price field in the data table must be of the String type, the value of the price field in the search index must be of the Double type, and the isArray=true setting must be configured.

The following table describes the combinations of the Array data type with primitive data types in search indexes.

Data of the Nested type is nested documents. Nested documents are used when a row of data (document) contains multiple child rows (child documents). Multiple child rows are stored in a nested field. The Nested data type is suitable for storing data that has a hierarchical structure.

You must specify the schema of child rows in a nested field. The schema must include the fields of the child rows and the property of each field. The Nested data type can be used to store multiple values, which is similar to the JSON data type.

If a field in a search index is of the Nested type, the field in the data table for which the search index is created must be of the String type, and the field in the search index must be of the Nested type. You must perform nested queries to query fields of the Nested type.

When you write data to a field in a data table and the field corresponds to a nested field in the search index that is created for the data table, make sure that the field in the data table is of the JSON Array type. Example: [{"tagName":"tag1", "score":0.8}, {"tagName":"tag2", "score":0.2}].

Nested fields are classified into single-level and multi-level nested fields. The following table describes the two types.

[
    {
        "tagName": "tag1",
        "score": 0.8
    },
    {
        "tagName": "tag2",
        "score": 0.2
    }
]

[
    {
        name:"John",
        "age": 20,
        "phone": "1390000****",
        "address": [
            {
                "province": "Zhejiang",
                "city": "Hangzhou",
                "street": "1201 Xingfu Community, Sunshine Avenue"
            }
        ]
    }
]