Elasticsearch Java API - building queries

Question

I have looked through the docs for the Search API but find them not descriptive enough (even though they are very well written). I am trying to build a query but understand little about all the different options available and cannot find information on the matter, when building a query and I am unable to translate queries I can run in Sense to queries I can run using the Java API.

In Sense I have the following:

GET index/_search
{
  "query": {
    "match" : {
      "name" : "some string"
    }
  }
}

And in my Java code I have:

node = nodeBuilder().client(true).clusterName(CLUSTER_NAME).node();
client = node.client();
QueryBuilder qb = QueryBuilders.termQuery("name", "some string");
SearchResponse response = client.prepareSearch("index") //
    .setQuery(qb) // Query
    .execute().actionGet();

But they produce different search results. What is the difference as I cannot see it? Also is there a good source of information that might be of use?

John Petrone · Accepted Answer · 2014-06-15 05:13:18Z

If you want the two queries to return the same results you need to use the same type of query. In your Sense query you are performing a match query:

"query": {
    "match" : {
      "name" : "some string"
    }
  }

but in your Java code you are performing a termQuery:

QueryBuilder qb = QueryBuilders.termQuery("name", "some string");

So to answer your question use a match query instead in your Java code:

QueryBuilder qb = QueryBuilders.matchQuery("name", "some string");

Regarding your second question, it's a bit broad. I'd certainly try going thru the documentation and searching here on StackOverflow. Regarding the Java API I'd look here for the overview and here for the info on the query dsl thru Java.

I think a good general understanding of how Elasticsearch works and some comfort with the query mechanism thru the REST API would be very helpful in getting to understand the Java API. Good places to start:

http://joelabrahamsson.com/elasticsearch-101/

http://exploringelasticsearch.com/

http://java.dzone.com/articles/elasticsearch-getting-started

Thanks your fix worked. Regarding the docs I have read and reread all but one of the links you provided, I'm just trying to iron out the finer points, I guess I'll get there eventually.
Yeah I've found I need to keep reading some of this over and over to get the details nailed. ES is pretty easy to start using but the complexity underneath can be daunting at times.
@John Petrone, how to manually pass query in java like these {"query": {"bool": {"must": [{"range": {"sessionTime": {"gte": 1000, "lt": 5000}}}, {"match_phrase": {"os": "Windows"}}], "must_not": [], "should": []}}.

Collectives™ on Stack Overflow

Elasticsearch Java API - building queries

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related