I had deployed Trino using helm on k8's cluster. After that I have added catalogs for MySQL and MongoDB. You can see catalogs for MongoDB
AdditionalCatalogs:
Mongodb |-
Connector.name=mongodb
Mongodb.Connection-url=mongodb://username:password@hostip:27017/?authsource=admin
I’m able to get query tables inside MySQL, but I'm facing issue getting some tables in MongoDB. Actually in MongoDB, I can see tables only in information-schema, but not in my Envision. In MongoDB Compass, I am able to see data with connecting to its instance. The data is having 4 schemas- envision, admin, config, information-schema. And I'm unable to see config and admin as well through Trino.
How can I fix this?