Does the Teiid MongoDB translator support the varbinary type?
Versions:
Teiid 8.8
MongoDB 2.4
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(3)
)
OPTIONS(UPDATABLE 'TRUE');]]>
</metadata>
</model>
<translator name="mongodb" type="mongodb">
<property name="SupportsDirectQueryProcedure" value="true"/>
</translator>
</vdb>
db.track_points.find()
{ "_id" : ObjectId("53c03fe86c2d58b8c581ff80"), "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