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

Ivan Chan commented on TEIID-2848:
----------------------------------

Yes, Object[] is a good solution.  And maybe you guys can also consider to provide 2 different ways to handle mongoDB array object.

1.  map mongoDB array to java object array

2. flatten the data to create separate column for each array element  (similar to unwind):
>From the example above:

CREATE FOREIGN TABLE  Sample (
    CustomerId integer PRIMARY KEY,
    name varchar(25),
    array_0 varchar(25),
    array_1 integer,
    array_2, timestamp,
    array_3, integer,
    num varchar(6),
) 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
>
> 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.2.3#6260)