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

[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ] 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'); -- This message was sent by Atlassian JIRA (v6.3.1#6329)