Is it possible to get string representation of mongodb object id (_id) inside Drill sql statement? I have problems with representing _id in Tableau where it is converted into uppercase string , e.g. MongoDb "_id" : ObjectId("577e4a2e081d4b0fb59ac96e") become '577E4A2E081D4B0FB59AC96E' Tableau value ,not sure if it is ODBC or Tableau conversion bug
Thanks Vlad