WrapperQueryBuilder - aggs query throwing Query Malformed exception

Question

I have a Json query string:
"\"query\":{\"match_all\": {}},\"aggs\":{\"avg1\":{\"avg\":{\"field\":\"age\"} } }";

When query is executed via Jest Client, aggregation values are available.

But when this query is converted into a Query Builder (WrapperQueryBuilder) object, getting the following exception.

; nested: QueryParsingException[[st1index] [_na] query malformed, must start with start_object]; }{[ixJ-6RHNR5C6fC7HfJHqaw][st1index][4]: SearchParseException[[st1index][4]: from[-1],size[-1]: Parse Failure [Failed to parse source [{
  "query" : {
    "wrapper" : {
      "query" : "InF1ZXJ5Ijp7Im1hdGNoX2FsbCI6IHt9fSwiYWdncyI6eyJhdmcxIjp7ImF2ZyI6eyJmaWVsZCI6ImFnZSJ9IH0gfQ=="
    }
  }
}]]]; nested: QueryParsingException[[st1index] [_na] query malformed, must start with start_object]; }]

How do i fix this?

Edit 1: Code analysis: Code analysis details added:

    public static void main(String[] args) throws Exception 
{
try{
    //Jest client building
            JestClientFactory factory = new JestClientFactory();
            HttpClientConfig config = new HttpClientConfig.
                    Builder("http://localhost:9201")
                    .connTimeout(10000)
                    .readTimeout(10000)
                    .multiThreaded(true).build();

            factory.setHttpClientConfig(config);
            JestClient jestClient = factory.getObject();

            String query ="{\"query\":{\"match_all\": {}},\"aggs\":{\"avg1\":{\"avg\":{\"field\":\"age\"} } }}";
             String query2 ="{\"match_all\": {}},\"aggs\":{\"avg1\":{\"avg\":{\"field\":\"age\"} } }}";

            WrapperQueryBuilder wrapQB = new WrapperQueryBuilder(query2);
            SearchSourceBuilder ssb = new SearchSourceBuilder();
            ssb.query(wrapQB);

//working code commented
            //   Search.Builder searchBuilder = new Search.Builder(query).addIndex("st1index").addType("st1type");

//code which needs to be fixed
            Search.Builder searchBuilder = new 
Search.Builder(ssb.toString()).addIndex("st1index").addType("st1type");
            SearchResult result = jestClient.execute(searchBuilder.build());
            System.out.println(result.getJsonString());
            }
            catch(Exception e)
            {
                System.out.println("inside exception block");
                e.printStackTrace();
            }

        }

with String query and with commented SearchSourceBuilder, aggs results are displayed. But by using WrapperQueryBuilder , unable to retrieve aggs results

Val · Accepted Answer · 2015-12-14T14:39:03.753

1

You're almost there, you're simply missing enclosing braces:

"{\"query\":{\"match_all\": {}},\"aggs\":{\"avg1\":{\"avg\":{\"field\":\"age\"}}}}";
 ^                                                                               ^
 |                                                                               |
this one...                                                         ...and this one

UPDATE

In the WrapperQueryBuilder, you can only pass the content of the query part, and not the aggregations part. You need to add the aggregation part directly on the SearchSourceBuilderlike this:

SearchSourceBuilder ssb = new SearchSourceBuilder();

// add the query part
String query ="{\"match_all\": {}}";
WrapperQueryBuilder wrapQB = new WrapperQueryBuilder(query);
ssb.query(wrapQB);

// add the aggregation part
AvgBuilder avgAgg = AggregationBuilders.avg("avg1").field("age");
ssb.aggregation(avgAgg);

edited Dec 14 '15 at 14:39

answered Dec 14 '15 at 07:39

Val

207,596
13
358
360

Modified the query and now I am not getting any exception. However, aggs data is still empty. When I run via Head plugin, I am getting the results - any thing i am missing -@Val – DecKno Dec 14 '15 at 11:24
to add more, I am using WrapperQueryBuilder. so query String I am passing is {\"match_all\": {},\"aggs\":{\"avg1\":{\"avg\":{\"field\":\"age\"} } }}. I need to skip "query" since it would be added by wrapper. I need to know how to make it work from here. – DecKno Dec 14 '15 at 11:34
Code analysis details added: – DecKno Dec 14 '15 at 12:17
1

Oh, indeed, you cannot add `aggs` inside `WrapperQueryBuilder`, since it's only for the `query` part. I've updated my answer. – Val Dec 14 '15 at 14:39
Invoking entire query String via any client (JEST) works fine. I do not wish to use AggregationBuilder since all the queries are dynamic and I want to pass it as JSON query string only. Also my requirement forces me to use QueryBuilder stuff. Is there any way to pass query + aggs as JSON string to QueryBuilder and still get aggs result? - @Val – DecKno Dec 15 '15 at 04:49
Is there any documentation to support the fact that aggregation in JSON string is not supported via TCP based java Client? Thanks in advance. – DecKno Dec 24 '15 at 12:30
I see you've created a [new question](http://stackoverflow.com/questions/34451988/aggregations-in-java-client-through-json-query-without-aggregationbuilder) for this so I'll answer there. – Val Dec 25 '15 at 05:28

WrapperQueryBuilder - aggs query throwing Query Malformed exception

1 Answers1