[teiid-issues] [JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support

[Ivan Chan (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13000628#comment-13000628 ] 

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

> MongoDB: Provide Array support 
> -------------------------------
>
>                 Key: TEIID-2848
>                 URL: https://issues.jboss.org/browse/TEIID-2848
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: CR1
>             Fix For: 8.8, 8.7.1
>
>
> Provide array support for primitive data types in MongoDB  translator. The arrays are supported but as embedded documents in the one-2-many situation.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)