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

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

Hi Ramesh,

I get passed the syntax error after I renamed my mongodb item from "array" to something else.  But now I ran into a different error:

Caused by: org.teiid.translator.TranslatorException: TEIID18027 Any operations on array type column LanguageClass are not supported currently.
 
Here is my sql:

select c.CustomerID, c.FirstName, c.LastName, x.col1, x.col2, x.col3 FROM (select CustomerID, FirstName, LastName, LanguageClass FROM MongoDB_Array.TeiidArray) c, ARRAYTABLE(c.LanguageClass COLUMNS col1 string, col2 string, col3 string) x

What did I do wrong this time?  Any clue?

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)