CODEWITHSUNDEEP
azure-cosmosdb
Sam
Sam

Reputation: 976

Maximum number of items in DocumentDb IN clause

I can't find mention anywhere in the documentation the maximum number of items supported by the IN keyword in DocumentDb.

I would make the assumption that there is a limit.

Can anyone point out in the documentation that is referenced?

Upvotes: 5

Views: 2265

Answers (2)

yaronyogev
yaronyogev

Reputation: 428

Currently the limit for AWS DocumentDB is 10K items (10,000) for $in operator:

OperationFailure
$in array size must not be greater than 10000

Upvotes: 0

Mimi Gentz
Mimi Gentz

Reputation: 1658

DocumentDB has virtually eliminated all limits by raising them to a level we don’t foresee our users surpassing, thus they are no longer documented. In this case, 1000 arguments can be in an IN clause.

Upvotes: 10

Related Questions