Does the Teiid MongoDB translator support the varbinary datatype?

[mdfspiff]

Versions:
Teiid 8.8

MongoDB 2.6.3

vdb.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="tracks" version="1">
  <model name="tracks">
    <source name="tracks" translator-name="mongodb" connection-jndi-name="java:/mongoDS"/>
    <metadata type="DDL"><![CDATA[
      CREATE FOREIGN TABLE  track_points (
        name varchar(25),
        id integer,
        ts timestamp,
        uuid varbinary(100)
      )
      OPTIONS(UPDATABLE 'TRUE');]]>
    </metadata>
  </model>
</vdb>

db.track_points.find()

{ "_id" : 1, "uuid" : BinData(3,"FKKq1/oBQKSKgAQkK5Ru5A=="), "name" : "point 1", "id" : 1, "ts" : ISODate("2013-01-01T00:00:01Z") }

Query:
select * from track_points

Error:
TEIID10076 Invalid conversion from type class java.lang.Object with value 'a44001fa-d7aa-a214-e46e-942b2404808a' to type class org.teiid.core.types.BinaryType

[rareddy]

Michael,

Looks like Teiid did not add support for varbinary yet, you can open a enhancement JIRA at Teiid - JBoss Issue Tracker and will add it to next revision. Right now it is treating like Object type. You can try modeing as Blob and that should work. However that uses GridFS functionality to store in MongoDB.

Ramesh..

[shawkins]

Teiid does have support for varbinary, but it's basic mapping is to a java byte array - typically less than 8kb. 

However in this case you have a UUID object and Teiid does not know how to convert from UUID to byte[]/varbinary.  Are you expecting the value to be the serialized bytes or some other byte representation?

A side note is that the MongoDB translator when reporting its own metadata will map byte[] to blob.

[rareddy]

Added [TEIID-3061] MongoDB: Support VARBINARY type - JBoss Issue Tracker