Hello team, I have started using calcite for one of my projects and trying to write views to work with MongoDb adaptor.
However I am not able to figure out which data type is correct for ObjectID of mongo collection. I used MAP, ANY. Which is correct? I am also not able to use the ObjectID value in SQL where clause. Any guidance or help is greatly appreciated. Rajasekhar