Re: how convert mongodb _id into string

[Andries Engelbrecht]

See what is returned if you query _id from sqlline to see.

Also you can use Drill Explorer that ships with the ODBC driver and see what is 
returned from the ODBC driver.

This may help you to troubleshoot where the conversion is done, mongo plugin, 
ODBC driver or Tableau.

--Andries



> On Jul 7, 2016, at 7:57 AM, Vladimir Morozov  wrote:
> 
> 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

how convert mongodb _id into string

[Vladimir Morozov]

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