Is there a way to increase maxClauseCount

Ruud_van_Buul · 2024-08-21T11:07:39.876Z

We have a query that needs to filter by a long list of ids.

I get the error: “Query contains too many nested clauses; maxClauseCount is set to 1024”

Can I increase the maxClauseCount for a local atlas deployment?

Fabio_Ramohitaj · 2024-08-21T12:44:45.370Z

Hi @Ruud_van_Buul,
I am not an expert on this topic, but I found the following answer:

Hi @Wayne_Smallman, Thanks for providing the search details and the error message. I assume you’re getting this error against an M0, M2 or M5 tier cluster - please correct me if I am wrong here. This assumption is based off the Atlas Search M0 (Free Cluster), M2, and M5 Limitations documentation which states: Lucene’s default clause limit of 1024 applies to any BooleanQuery created for searches. More details on the clause error and its possible cause(s) can be found in the Lucene document…

i hope it will be useful!

Best Regards

Ruud_van_Buul · 2024-08-21T15:14:18.502Z

Yes I know. But can I overwrite the default somehow? The M10+ clusters don’t have this limitation. So my tests are breaking but it works in clusters.

Fabio_Ramohitaj · 2024-08-21T15:24:27.544Z

Hi @Ruud_van_Buul,
I have not found in the documentation a parameter that can be set and thus can overwrite the default one, so I suppose not.

Regards

Ruud_van_Buul · 2024-08-23T14:24:27.718Z

Can we make feature requests for local atlas somewhere?

Fabio_Ramohitaj · 2024-08-23T15:45:38.182Z

Hi @Ruud_van_Buul,
I think here:
https://feedback.mongodb.com/

Best Regards

Ruud_van_Buul · 2024-08-27T12:08:39.933Z

Thanks for your help!