[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=13000617#comment-13000617 ] 

Ivan Chan edited comment on TEIID-2848 at 9/9/14 6:38 PM:
----------------------------------------------------------

I am still a little bit confused.  For example, if I have a mongodb document like the following:

{
  _id: 1,
  FirstName: "John",
  LastName: "Doe"
  Score: [89, "ninety", 91.0]
}

what should I use for database type for Score in database schema?  Should I use arraytable?  Like the following:

CREATE FOREIGN TABLE Customer (
    customer_id integer,
    FirstName varchar(25),
    LastName varchar(25),
    Score, arraytable,
    PRIMARY KEY (FirstName, LastName)
) OPTIONS(UPDATABLE 'TRUE');






was (Author: ichanjasper):
I am still a little bit confused.  For example, if I have a mongodb document like the following:

{
  _id: 1,
  FirstName: "John",
  LastName: "Doe"
  Score: [89, "ninety", 91.0]
}

what should I use for database type for Score in database schema?  Should I use arraytable?  Like the following:

CREATE FOREIGN array Customer (
    customer_id integer,
    FirstName varchar(25),
    LastName varchar(25),
    Score, arraytable,
    PRIMARY KEY (FirstName, LastName)
) OPTIONS(UPDATABLE 'TRUE');





> 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)