Discover schema form mongodb to Trino

Trino
1

Hello,

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

2

You may need to configure the schema manually - see MongoDB connector — Trino 422 Documentation. Trino does support mapping MongoDB arrays to the Trino ARRAY type.