Query_string search exact phrase causes performance issues

Elastic Stack Elasticsearch
1

Hi all,

When I make query_string search exact phrase in Elasticsearch,

POST /myindex_*/_search
{
    "query": {
      "query_string": {
        "query": "\"Classe A\""
     }
}

The query is run and shows hits, but shows below performance issue:

"failed to create query: field expansion for [*] matches too many fields, limit: 1024, got: 1779"

If I increase field limit, it may again cause performance issue.

Anyway we can overcome this issue for the query.

2

Most likely you have a lot of fields in your mapping, right?
May be search within the needed fields only?

3

I have only 2 indices for an index pattern and both have 1500 + fields.

4

Which is more than the default allowed : 1024.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.