[
https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin...
]
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)