Combining QueryParameters in ElasticSearch Java APi

Question

I have json object i want to search through it looks like this
I currently am able to do a range of price search but i want to add search by city , which is a property of departure object so i decided to do a nested query but i get error

My ES logs shows

e_synonyms_phrase_query":true,"boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}},"path":"departure","ignore_unmapped":false,"score_mode":"avg","boost":1.0}}],"adjust_pure_negative":true,"boost":1.0}}}}] lastShard [true]
org.elasticsearch.transport.RemoteTransportException: [AoBfpnE][127.0.0.1:9300][indices:data/read/search[phase/query]]
Caused by: org.elasticsearch.index.query.QueryShardException: failed to create query: {
  "bool" : {
    "filter" : [
      {
        "range" : {
          "price" : {
            "from" : 1300,
            "to" : 5000,
            "include_lower" : true,
            "include_upper" : true,
            "boost" : 1.0
          }
        }
      },
      {
        "nested" : {
          "query" : {
            "bool" : {
              "must" : [
                {
                  "match" : {
                    "departure.city" : {
                      "query" : "minsk",
                      "operator" : "OR",
                      "prefix_length" : 0,
                      "max_expansions" : 50,
                      "fuzzy_transpositions" : true,
                      "lenient" : false,
                      "zero_terms_query" : "NONE",
                      "auto_generate_synonyms_phrase_query" : true,
                      "boost" : 1.0
                    }
                  }
                }
              ],
              "adjust_pure_negative" : true,
              "boost" : 1.0
            }
          },
          "path" : "departure",
          "ignore_unmapped" : false,
          "score_mode" : "avg",
          "boost" : 1.0
        }
      }
    ],
    "adjust_pure_negative" : true,
    "boost" : 1.0
  }
}
    at org.elasticsearch.index.query.QueryShardContext.toQuery(QueryShardContext.java:320) ~[elasticsearch-6.3.2.jar:6.3.2]
    at org.elasticsearch.index.query.QueryShardContext.toQuery(QueryShardContext.java:303) ~[elasticsearch-6.3.2.jar:6.3.2]

Val · Accepted Answer · 2018-08-03 08:59:02Z

2

The correct query looks like this:

    QueryBuilder range = QueryBuilders.rangeQuery("price")
            .from(minPrice)
            .to(maxPrice)
            .includeLower(true)
            .includeUpper(true);

    QueryBuilder city = QueryBuilders.matchQuery("departure.city", city);

    QueryBuilder query = QueryBuilders.boolQuery()
            .filter(range)
            .filter(city);

    ...

    searchSourceBuilder.query(query);

answered Aug 3, 2018 at 8:59

Val

218k14 gold badges377 silver badges384 bronze badges

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

13 Comments

valik Over a year ago

thanks actually it works for parameters such as nights, people but not for city , I think because city belongs to an object , so when i run your code it retruns empty but if i change departure.city to nights and give it value it returns data

Val Over a year ago

If departure is not of type nested but object it should work. What's the mapping of the departure field?

valik Over a year ago

so the whole data is mapped to a Tour class while departure is a object that Tour is composed off

Val Over a year ago

what do you get when running GET your_index ?

valik Over a year ago

Caused by: java.lang.IllegalStateException: [nested] nested object under path [departure] is not of nested type

|

Collectives™ on Stack Overflow

Combining QueryParameters in ElasticSearch Java APi

1 Answer 1

13 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

13 Comments

Your Answer

Sign up or log in

Post as a guest

Related