You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by Rajasekhar B <ra...@live.com> on 2016/09/18 18:14:04 UTC

Using MongoDb ObjectID in where clause

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