Elasticsearch: Filter Query not working

Question

I've been working to change my query to a filter in Elasticsearch using the java api. I've made sure that the fields I am running searches on are set to "not_analzed".

Here is the java code for the filter:

FilterBuilder andFilter = FilterBuilders.andFilter(FilterBuilders.termFilter("thread_name", keyword), FilterBuilders.termFilter("site_name", "test_site"));

    QueryBuilder filteredQuery = QueryBuilders.filteredQuery(QueryBuilders.matchAllQuery(), andFilter);

    SearchResponse threadResponse = client.prepareSearch("thread_and_messages").setQuery(filteredQuery).setSize(20).setFrom(firstRowOffset).execute().actionGet();

This then gets translated to this in JSON:

"filtered" : {
"query" : {
  "match_all" : { }
},
"filter" : {
  "and" : {
    "filters" : [ {
      "term" : {
        "thread_name" : "apple"
      }
    }, {
      "term" : {
        "site_name" : "test_site"
      }
    } ]
  }
}
}

When I try to do any searches it won't return the document I'm looking for which is thread_name: Apple and site_name: test_site.

Also when I run this using a curl command it won't find that document either.

Can anyone see what I'm doing wrong here?

Are you searching for apple or Apple. Please note the case. — Richa
– Richa, Commented Mar 17, 2016 at 11:26
Either, the thread_name field isn't analyzed so I assumed case wouldn't be an issue — Daniel Buckle
– Daniel Buckle, Commented Mar 17, 2016 at 11:35
That is the issue.. If it is not-analyzed. Case matters in term query. It looks for exact match. — Richa
– Richa, Commented Mar 17, 2016 at 11:37
On analyzed you will not be able to search for exact term. i.e . if you have red apple. you won't be able to search for red apple using term query. — Richa
– Richa, Commented Mar 17, 2016 at 11:41

Richa · Accepted Answer · 2016-03-17 12:02:52Z

1

You can use must clause.That will perform and operation

 "query": {
    "bool": {
        "must": [
           {
               "query_string": {
                  "default_field": "thread_name",
                  "query": "apple"
               }
           },
           {
               "query_string": {
                  "default_field": "site_name",
                  "query": "test_site"
               }

           }
        ]
    }
  }

answered Mar 17, 2016 at 12:02

Richa

7,6796 gold badges30 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch: Filter Query not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related