Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

[#1]

I want to query the Elasticsearch through Apache Nifi processor (JsonQueryElasticsearch) but giving me java.lang.integer issue.

Nifi Flow:

Error when executing processor: JsonQueryElasticsearch

Query which I am executing through processor:

{

"query": {

"bool": {

"must": {

"match_all": {}

},

"filter": {

"term": {

"DestCityName": "Sydney"

}

}

}

}

}

Please help me to identify the issue.

Thanks!!

[#2]

The above was originally posted in the Community Help Track. On Mon May 20 16:25 UTC 2019, a member of the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help Track is intended for questions about using the HCC site itself.

[#3]

I'm having the same issue, using nifi-1.9.2 and Elasticsearch v7.0

My guess is that the response from ES differs slightly from v6.x (but have not tested)

[#4]

Many thanks Chris for your reply!!

I tested it with ES version: 5.6 and nifi version:1.9.1. It is working fine.

Thanks for the solution.