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.

How to write mongoDb query in Apache Nifi GetMongo Processor ?

Solved Go to solution
Highlighted

How to write mongoDb query in Apache Nifi GetMongo Processor ?

Explorer

I am trying to fetch some data from mongodb using Nifi and I am using GetMongo processor. I am trying to write a query inside GetMongo but I dont have any idea how t write query inside this processor.
This is my sample query

db.Person.find({
$and:[
{"createdAt":{$ne:null}},
{"updatedAt":{$ne:null}}
]
})

when I write this query it shows the exclamation marks over the processor showing that "Query validated against .... is invalid because JSON was expecting a value but find db." Help me with the correct expression variables at least a good sample will be helpful.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.

{
"createdAt":{$ne:null},
"updatedAt" : {$ne:null}
}

View solution in original post

3 REPLIES 3
Highlighted

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.

{
"createdAt":{$ne:null},
"updatedAt" : {$ne:null}
}

View solution in original post

Highlighted

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

@Vivek Singh did the suggestion worked for you?

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

Explorer

@Rahul Soni Yes Mr. Soni thanks its working. Thanks for your time.

Don't have an account?
Coming from Hortonworks? Activate your account here