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.