Query error on mongodb collection with embedded document

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

1 Like

I have the same problem

did you solve it?

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

1 Like

hello, have you been able to review this topic ?

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