using query_string query with bool in elastic search causing parsing exception

Question

Why is this query giving me a parsing exception? If I remove the bool it does seem to work. But I need the bool there with the query_string. How can I make this work?

{
    "query": {
        "filtered": {
            "query": {
                "bool": {
                    "must": [
                        {
                            "terms": {
                                "status_type": [
                                    "5"
                                ]
                            }
                        }
                    ]
                }
            },
            "filter": {
                "query_string": {
                    "fields": [
                        [
                            "name",
                            "message"
                        ]
                    ],
                    "query": "Arnold AND Schwarz"
                }
            }
        }
    },
    "sort": [
        {
            "total_metrics": {
                "order": "desc"
            }
        }
    ]
}

Can you show the parsing exception you get?

Val
– Val

2015-08-03 04:19:11 +00:00
Commented Aug 3, 2015 at 4:19 — Val
– Val, Commented Aug 3, 2015 at 4:19

Mateusz Dymczyk · Accepted Answer · 2015-08-03 15:17:56Z

2

You should use the query filter which wraps any query into a filter. Otherwise you will get the parse error you get No filter registered for [query_string].

You need to change your filter part to:

"filter": {
  "query": { // <- wraps a query as a filter
    "query_string": {
      "fields": [
        [
          "name",
          "message"
        ]
      ],
      "query": "Arnold AND Schwarz"
    }
  }
}

@Edit: since I see people might have problems noticing that I only pasted the changed part of the whole query including the filter part (not the whole filtered) here's the whole thing after modification:

{
    "query": {
        "filtered": {
            "query": {
                "bool": {
                    "must": [
                        {
                            "terms": {
                                "status_type": [
                                    "5"
                                ]
                            }
                        }
                    ]
                }
            },
            "filter": {
                "query": { // <- the only difference!
                    "query_string": {
                        "fields": [
                            [
                                "name",
                                "message"
                            ]
                        ],
                        "query": "Arnold AND Schwarz"
                    }
                }
            }
        }
    },
    "sort": [
        {
            "total_metrics": {
                "order": "desc"
            }
        }
    ]
}

edited Aug 3, 2015 at 15:17

answered Aug 3, 2015 at 4:29

Mateusz Dymczyk

15.2k10 gold badges63 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Horse Voice Over a year ago

How would i include the bool? you didn't provide bool query in the example

Mateusz Dymczyk Over a year ago

@HorseVoice notice I only changed the filter part not the whole filtered, just substitute your filter part of the whole query with what I shown.

Horse Voice Over a year ago

Awesome!! is there some blog or guide that simply explains what can go into what? What I mean is, for example, I get confused whether a query can go into a bool, or a filter can go into a query or a bool can go into a filter etc. Really confusing. And the documentation doesn't properly describe these rules of query formulation. Should I open a new question on this topic and you can answer there? I'll select your answer there too. Let me know. Thank you!

Mateusz Dymczyk Over a year ago

@HorseVoice well actually personally I've been always using their documentation and found it pretty reasonable but maybe because I've read it all? I mean they don't have much data redundancy and if you don't read it all carefully you indeed will miss a lot of important information.

Horse Voice Over a year ago

I posted the question. You see I have to read through the documentation on a per query basis, but I'm actually trying to write an internal sql like api that will build up the elastic dsl. So I need the rules defined for what goes into what in an elastic query.

|

Val · Accepted Answer · 2015-08-03 04:26:10Z

2

The parsing exception you get should tell you something like No filter registered for [query_string]

Actually, there is no query_string filter, there is a query_string query, though. So if you swap the filter and the query it will work:

{
  "query": {
    "filtered": {
      "query": {
        "query_string": {         <--- move query_string in the query part
          "fields": [
            [
              "accountIdentifier",
              "accountName"
            ]
          ],
          "query": "Arnold AND Schwarz"
        }
      },
      "filter": {
        "bool": {                 <--- move the bool in the filter part
          "must": [
            {
              "terms": {
                "quantity": [
                  "5"
                ]
              }
            }
          ]
        }
      }
    }
  },
  "sort": [
    {
      "total_metrics": {
        "order": "desc"
      }
    }
  ]
}

answered Aug 3, 2015 at 4:26

Val

218k14 gold badges377 silver badges384 bronze badges

1 Comment

Horse Voice Over a year ago

I posted the question. You see I have to read through the documentation on a per query basis, but I'm actually trying to write an internal sql like api that will build up the elastic dsl. So I need the rules defined for what goes into what in an elastic query

Collectives™ on Stack Overflow

using query_string query with bool in elastic search causing parsing exception

2 Answers 2

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related