Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

Highlighted

Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

New Contributor

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

Nifi Flow:

108854-1558351243286.png


Error when executing processor: JsonQueryElasticsearch

108843-1558351380651.png

Query which I am executing through processor:

{

"query": {

"bool": {

"must": {

"match_all": {}

},

"filter": {

"term": {

"DestCityName": "Sydney"

}

}

}

}

}


Please help me to identify the issue.

Thanks!!

3 REPLIES 3

Re: Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

Rising Star

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.

Re: Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

New Contributor

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)

Re: Issue in querying the Elasticsearch through NiFi processor: JsonQueryElasticsearch

New Contributor

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.