elasticsearchamazon-dynamodbdynamodb-queriesopensearchamazon-cloudsearch

Is there a limit on the number of filters that can be passed to DynamoDB query

I’d like to search for something like

Field “Id” has a value in [Long list of IDs]

This long list of Ids can hit over 1000 Ids.

should I expect a problem with that? Is there a limit on how long the query can be?

I am looking at cloudsearch and it seems to have a limit of 1024 clauses and wondering if it should just be done from DynamoDB if there are no limits on it.

At that point, I guess I should also ask if Elastic search/Open search has such limits,

Solution

  • You can review the various DynamoDB limits at https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ServiceQuotas.html. Here's two that will impact you:

    The maximum length of any expression string is 4 KB.

    The maximum number of operands for the IN comparator is 100.