I am running a elastic search query which is attached via image with this topic, It's giving me too_many_clauses error, My question is would I have to increase the limit for maxClauseCount or am I doing anything wrong in query which can be improved ?
Elasticsearch can at a time process only 1024 clauses. Each element in the terms array corresponds to 1 clause. Either you may increase the max clause count parameter in the elasticsearch.yml or you make sure that the length of the terms array doesn't exceed 1024.