Filter by subset

[shabeerak]

Hi,
I see Milvus supports filtering array filtering with contains all.
filter="ARRAY_CONTAINS_ALL(color_coord, [7, 8])"

Is there a way to filter if color_coord is a subset of an input array filter.
Say, all elements of color_coord is a member of the input array filter?

thanks!

[yhmo]

No such operator.

[xiaofan-luan]

can't you do ARRAY_CONTAINS_ALL([7, 8], color_coord)?

[yhmo]

Will get an error: "cannot parse expression: ARRAY_CONTAINS_ALL([7], arr), error: contains_all operation are only supported on json or array fields now, got: [7]: invalid parameter"

[xiaocai2333]

Currently, filtering with a field as a subset is not supported, an issue has been logged: #35134 .