elasticsearch query string format

Question

I am using

SearchBuilder.searchSource.query(query_string).buildAsBytes()

to perform the query string on elasticsearch servers.

The problem is that I dont know what is the correct format of query string. For instance, I want to find all documents with country field to be US, I can use the restful api of

http://my.elastic.search.server/foo/dummy/_search?q=country:US

to get what I need. But in terms of java api, I tried country:US, q=country:US, and {\"country\":\"US\"}, but each time I got back SearchPhaseExecutionException.

ElasticSearch's documentation does not shed any lights on what could be the format of query string in this case, and I have exhausted Google results related to this topic. Can someone help me on this? Thanks!

Do you want to create json via java or do you want to use the Java API? — Karussell
– Karussell, Commented Jan 21, 2012 at 21:20
So the 'more contrived JSON' works and tje recommemded "country:US" doesn't work? — Dennis
– Dennis, Commented May 16, 2012 at 23:10

James Allman · Accepted Answer · 2012-01-18 03:15:17Z

4

Based upon your REST query the equivalent according to the Search Java API would be:

SearchResponse response = client.prepareSearch("foo")
    .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
    .setQuery(termQuery("country", "US"))
    .execute()
    .actionGet();

You could also use a pure query string as in your REST example:

    .setQuery(queryString("country:US"))

The best reference is the Javadoc available in the Maven repository.

edited Jan 18, 2012 at 3:15

answered Jan 18, 2012 at 2:44

James Allman

41.3k11 gold badges59 silver badges70 bronze badges

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

1 Comment

Chris Gerken Over a year ago

what is the source for termQuery() ?

Sheng · Accepted Answer · 2012-01-18 14:00:54Z

2

OK. seems like I need to pass in a more contrived json string

{ "query_string" : { "default_field": "anotherFoo", "query": "this AND that OR there" } }

It is useful in that I can pass in pure Lucene-style query against elasticsearch.

answered Jan 18, 2012 at 14:00

Sheng

1,7074 gold badges19 silver badges35 bronze badges

Comments

Karussell · Accepted Answer · 2012-01-21 21:20:06Z

2

I've written an overview on this topic recently:

http://karussell.wordpress.com/2012/01/19/birds-eye-view-on-elasticsearch-its-query-dsl/

answered Jan 21, 2012 at 21:20

Karussell

17.4k17 gold badges101 silver badges205 bronze badges

Comments

Abhijit Mazumder · Accepted Answer · 2015-06-14 07:26:10Z

Its an old question but as I struggled quite a bit with similar query , I thought I would add my two cents. First of all I could not find

SearchBuilder.searchSource.query(query_string).buildAsBytes()

As mentioned in the original question any more in ES java API.

My request body looked like

{
  "query": {
    "query_string": {
      "default_field": "file",
      "query": "Java"
    }
  },
  "highlight": {
    "fields": {
      "file": {

      }
    }
  }
}

I found this can be done in following two ways

    String queryString = "{" 
            + "\"query_string\": " 
                + "{"
                    + "\"default_field\":"
                + " \"file\","
                        + " \"query\": \"Email OR @gmail.com @yahoo.com\""
                        + "}"
                        + "}";

First Approach

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();        
    searchSourceBuilder.query(queryString); //or searchSourceBuilder.query(queryString).buildAsBytes();

    SearchRequestBuilder searchRequestBuilder = new SearchRequestBuilder( ESConnectionFactory.INSTANCE.getClient()) ;
    searchRequestBuilder.internalBuilder(searchSourceBuilder).setIndices("resume")
    .setTypes("docs").addHighlightedField("file");

Second Approach

SearchRequestBuilder searchRequestBuilder = client.prepareSearch()
                .setIndices("resume")
                .setTypes("docs").setQuery(queryString).addHighlightedField("file");

And then standard

SearchResponse response = searchRequestBuilder.execute().actionGet();

Keys things to note

Do not add "query" in the queryString
Do not add highlighted fields in query string. Use addHighlightedField

Raghu K Nair · Accepted Answer · 2016-03-04 01:01:50Z

1

I feel this should work.

QueryBuilder qb = QueryBuilders.queryStringQuery("pattern").field("field to search");
SearchRequestBuilder sreq = client.prepareSearch("INDEX").setTypes("TYPE").setQuery(qb);
SearchResponse response = sreq
                .setFrom("From page")
                .setSize("size")
                .execute().actionGet();

answered Mar 4, 2016 at 1:01

Raghu K Nair

3,9721 gold badge31 silver badges47 bronze badges

Collectives™ on Stack Overflow

elasticsearch query string format

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related