Query error on mongodb collection with embedded document

[iskdet]

Hello Community,

I am new with dremio, I have this challenge of dremio returning unknown null , when I query a collection with an embedded document. When I remove the embedded document from the query everything works and I get an output.

it works well with arrays but returns an error when the embedded document is present in the document

I have attached a sample of my docment

Your input is highly appreciated thank you.

Sam

[jlcornejo]

I have the same problem

I get a null value from a mongoDB document (object is not null)

I can’t get the values ​​from a document in mongoDB. db.getCollection('ticket').aggregate([{$match:{switchBackup:true}},{$match:{"_id":2535}}]) result [image] /* 1 */ { "_id" : 2535, "status" : "rejected", "countries" : [ 3, 5 ], "switchFunctionality" : false, "switchDownService" : false, "switchLowEnvironmentTest" : false, "switchVersioning" : true, "switchSap" : false, "switchMonitoring" : true, "switchBackup" : true, "impa…

did you solve it?

[balaji.ramaswamy]

@jlcornejo I have checked with our Mongo plugin team and will get back to you once I hear back

[jlcornejo]

hello, have you been able to review this topic ?

[balaji.ramaswamy]

@jlcornejo We tested your exact same one you did and it did not give us nulls, we even tried on the OSS version