question Re: Mongo jason query is failing to execute by runMangoAggregation Processor Nifi in Support Questions

Mongo jason query is failing to execute by runMangoAggregation Processor Nifi

murali2425 — Wed, 13 May 2020 19:30:32 GMT

Hi Friends,

I have mongo query which running perfectly fine from mongo shell.

b.test650.aggregate(
[
{
$group: {
"_id": {
X: "$X",
Y_DT: "$Y_DT",
Z: "$Z"
},
adj: {$sum: "$adj" },
bjc: {$sum: "$bjc" },
jbc: {$sum: "$jbc" },
mnk: {$sum: "$mnk"}
}
}
]
)

The same query when in ran from Nifi , RunMangoAggregation throwing out error, though the mongo aggregation query changed to json type query ...

{
"$group": {
"_id": {
"X": "$X",
"Y_DT": "$Y_DT",
"Z": "$Z"
},
"adj": {"$sum": "$adj" },
"bjc": {"$sum": "$bjc" },
"jbc": {"$sum": "$jbc" },
"mnk": {"$sum": "$mnk"}
}
}

Getting following error ..

error run mongodb aggregation query.: com.fasterxml.jackson.databind.exc.MismatchedInputException:canot deserialize instace of java.util.ArayList' out of START_OBJECT token

Nifi workflow..

Processor(runMangoAggregation) configuration

What is the change I need to do in json query which supposed to executed @ runMongoAggregation processor?

Re: Mongo jason query is failing to execute by runMangoAggregation Processor Nifi

murali2425 — Thu, 14 May 2020 16:44:05 GMT

Hi friends,

Help me out get out this situation

Re: Mongo jason query is failing to execute by runMangoAggregation Processor Nifi

murali2425 — Mon, 18 May 2020 08:27:45 GMT

The issue is with the missing of square brackets at starting and @ ending ..

The working query is ..

[{
"$group": {
"_id": {
"X": "$X",
"Y_DT": "$Y_DT",
"Z": "$Z"
},
"adj": {"$sum": "$adj" },
"bjc": {"$sum": "$bjc" },
"jbc": {"$sum": "$jbc" },
"mnk": {"$sum": "$mnk"}
}
}]