[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-2848: ---------------------------------- Hi, I can't get it to work. I have a document like the following: { "_id": { "$oid" : "52e99e1f15ed1a0064000001" }, "name": "Rosalind Lutece", "products": "ADAM", "array": [ "String", 6, true, "01/29/2014 16:37 -08:00", 99 ] } And I create a schema like: CREATE FOREIGN TABLE customers ( id varchar(25) PRIMARY KEY, name varchar(25), products varchar(25), array object[] ) OPTIONS(UPDATABLE 'TRUE'); And I ran into the following exception: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "25), [*]array[*] object[" at line 5, column 5. Was expecting: "constraint" | "foreign" | "primary" | "unique" | id I am using Teiid 8.8.1 Thanks, Ivan -- This message was sent by Atlassian JIRA (v6.3.1#6329)