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

[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2848: ------------------------------------- You need to use Object[] there like {code} CREATE FOREIGN TABLE Customer ( customer_id integer, FirstName varchar(25), LastName varchar(25), Score object[], PRIMARY KEY (FirstName, LastName) ) OPTIONS(UPDATABLE 'TRUE'); {code} here you can use {code} select * from Customer {code} If you want to decode the each element of the Object[] then you need to use the ARRAYTABLE, for Ex: {code} select c.customer_id, c.FirstName, c.LastName, x,col1, x,col2, x.col3 FROM (select customer_id, FirstName, LastName, Score) c, ARRATTABLE(c.Score COLUMNS col1 integer, col2 string, col3 double) x {code} If you want, you can create a view out the above SQL and normalize the schema. -- This message was sent by Atlassian JIRA (v6.3.1#6329)