Background
We have an indexed metadata field called group
. The cardinality of the field is 10,000. We need the ability to query vectors that only match some group
values, so we’re using the $in
operator as per:
Problem
The problem is that we need to specify 1,000s of values for the $in
set. For example:
{
"group": {"$in":["a1","a2", ..., "a1000"]}
}
What are the maximum constraints that apply to a query like this? Is there a maximum number of terms that are allowed for the $in
set? Is there a maximum byte size for the query? If so what are those limits?