make json with elasticsearch functions in java

Question

I have a problem with understanding how to make json object in java. I have to get certain data from elasticsearch through java and I also have a json that functions, but I have no idea how to make such json with functions available.

Is it possible to do this with the SearchResponse class and its functions? Might QueryBuilder help?

This works with the Sense plugin in chrome:

GET _search 
{
 "query": {
     "constant_score": {
        "filter": {
            "and": {
               "filters": [
                  {"term": 
                    {"_type":"budget"}                      
                  },
                  {"term": 
                    {"_index":"dbs_project"}                      
                  },
                  {"term": 
                    {"month":"x"}                      
                  },
                  {"term": 
                    {"account_id":"y"}                      
                  }
               ]
            }
        }            
     }
  }
}

ygh · Accepted Answer · 2016-05-01 13:28:40Z

1

QueryBuilder should definitely work for you. To build a query like you require using the API, you will need to do something like this:

QueryBuilder query = QueryBuilders.constantScoreQuery(FilterBuilders.andFilter(FilterBuilders.termFilter("_type", "budget"),
                FilterBuilders.termFilter("_index", "dbs_project"), FilterBuilders.termFilter("month", "x"),
                FilterBuilders.termFilter("account_id", "y")));

And you will use SearchResponse to execute the query and fetch results like this:

SearchResponse response = client.prepareSearch(index).setTypes(type)
                .setQuery(query).execute()
                .actionGet();

where client is the instance of your TransportClient and index and type correspond to the elasticsearch index and type you want to query from.

answered May 1, 2016 at 13:28

ygh

5951 gold badge11 silver badges18 bronze badges

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

Comments

Dhruv Pal · Accepted Answer · 2016-04-30 20:52:44Z

0

Have you tried XContentBuilder.

https://www.elastic.co/guide/en/elasticsearch/client/java-api/1.6/generate.html

answered Apr 30, 2016 at 20:52

Dhruv Pal

9992 gold badges13 silver badges27 bronze badges

Collectives™ on Stack Overflow

make json with elasticsearch functions in java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related