We have a database in mongodb whose collections have arrays of objects (JSON), arrays of ObjectIds and their fields of ObjecIid´s.
When we connect Mongodb with Trino all those fields are not recognized.
How could we help to recognize the scheme of these collections?
The version of Trino server and client is 410 and the version of Mongodb is 5.3
Can you show an example of how to solve this problem?
thank you so much