build inverted index for array field

[zhu3359]

想验证下array字段是否可以建倒排索引，创建一个collection，代码如下
schema = MilvusClient.create_schema(
auto_id=False,
enable_dynamic_field=True,
)

3.2. Add fields to schema

schema.add_field(field_name="id", datatype=DataType.INT64, is_primary=True)
schema.add_field(field_name="vector", datatype=DataType.FLOAT_VECTOR, dim=5)
schema.add_field(field_name="color", datatype=DataType.VARCHAR, max_length=512)
schema.add_field(field_name="entity", datatype=DataType.ARRAY, element_type=DataType.VARCHAR, max_capacity=5, max_length=512)
client.create_collection(
collection_name=collection_name,
schema=schema,
)

index_params = MilvusClient.prepare_index_params()
index_params.add_index(
field_name="color",
index_type="INVERTED",
index_name="color_index"
)
index_params.add_index(
field_name="entity",
index_type="INVERTED",
index_name="inverted_entity"
)
index_params.add_index(
field_name="vector",
metric_type="IP",
index_type="IVF_FLAT",
index_name="vector_index",
params={ "nlist": 2 }
)
client.create_index(
collection_name=collection_name,
index_params=index_params,
sync=False
)

data=[
{"id": 0, "vector": [0.3580376395471989, -0.6023495712049978, 0.18414012509913835, -0.26286205330961354, 0.9029438446296592], "color": "pink_8682", "entity" : ["手机","智能手机"]},
{"id": 1, "vector": [0.19886812562848388, 0.06023560599112088, 0.6976963061752597, 0.2614474506242501, 0.838729485096104], "color": "red_7025", "entity" : ["电脑","平板电脑"]},
{"id": 2, "vector": [0.43742130801983836, -0.5597502546264526, 0.6457887650909682, 0.7894058910881185, 0.20785793220625592], "color": "orange_6781", "entity" : ["耳机","蓝牙耳机"]},
{"id": 3, "vector": [0.3172005263489739, 0.9719044792798428, -0.36981146090600725, -0.4860894583077995, 0.95791889146345], "color": "pink_9298", "entity" : ["耳机","蓝牙耳机"]},
{"id": 4, "vector": [0.4452349528804562, -0.8757026943054742, 0.8220779437047674, 0.46406290649483184, 0.30337481143159106], "color": "red_4794", "entity" : ["电脑","平板电脑"]},
{"id": 5, "vector": [0.985825131989184, -0.8144651566660419, 0.6299267002202009, 0.1206906911183383, -0.1446277761879955], "color": "yellow_4222", "entity" : ["电脑"]},
{"id": 6, "vector": [0.8371977790571115, -0.015764369584852833, -0.31062937026679327, -0.562666951622192, -0.8984947637863987], "color": "red_9392", "entity":["自行车", "山地自行车"]},
{"id": 7, "vector": [-0.33445148015177995, -0.2567135004164067, 0.8987539745369246, 0.9402995886420709, 0.5378064918413052], "color": "grey_8510", "entity":["手机"]},
{"id": 8, "vector": [0.39524717779832685, 0.4000257286739164, -0.5890507376891594, -0.8650502298996872, -0.6140360785406336], "color": "white_9381", "entity":["耳机"]},
{"id": 9, "vector": [0.5718280481994695, 0.24070317428066512, -0.3737913482606834, -0.06726932177492717, -0.6980531615588608], "color": "purple_4976", "entity":["自行车"]}
]
res = client.insert(
collection_name=collection_name,
data=data
)

在创建的过程中没有报错，但是创建完成后在ui界面上看entity字段没有展示索引类型

是否意味着array类型不能创建倒排索引？

[xiaofan-luan]

应该是可以构建的。
@shanghaikid could you help on this?

[zhu3359]

@xiaofan-luan array field构建inverted index后ARRAY_CONTAINS这些操作会变快吗

[shanghaikid]

请升级新版attu。

[zhu3359]

@yhmo 咨询一下，array field构建inverted index后ARRAY_CONTAINS这些操作会变快吗？

[yhmo]

会的。INVERTED index对这几个操作都可以加速：array_contains/array_contains_all/array_contains_any