Summary/Reported Issue
User encountered an issue where the ObjectID in a MongoDB collection did not match the expected Object in Dremio.
This is how it looked in MongoDB:
And this is how it looked in Dremio:
Relevant Versions
Dremio 25.2.x
Cause
- The issue was determined to be caused by a type mismatch.
- The ObjectID field in MongoDB is a special type in Mongo and it is read as a binary type in Dremio
Steps to Resolve
Use the TO_HEX function to convert the column and make it readable:
For example, try the following query:
select TO_HEX(_id) as _id from your.table
The output will now be the same as the ObjectID in MongoDB: