[JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-2848:
----------------------------------
Caused by: org.teiid.translator.TranslatorException: TEIID18027 Any operations on array type column LanguageClass are not supported currently.
at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:210)
at org.teiid.language.ColumnReference.acceptVisitor(ColumnReference.java:72)
at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:85)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.getExpressionAlias(MongoDBSelectVisitor.java:770)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:786)
at org.teiid.language.IsNull.acceptVisitor(IsNull.java:49)
at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:85)
at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:500)
at org.teiid.language.Select.acceptVisitor(Select.java:103)
at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51)
at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:61)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107)
> 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)
11 years, 6 months
[JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-2848:
----------------------------------
It seems like Teiid appends "IS NOT NULL" at the end of the SQL
org.teiid.query.sql.lang.Query:SELECT MongoDB_Array.TeiidArray.CustomerID, MongoDB_Array.TeiidArray.FirstName, MongoDB_Array.TeiidArray.LastName, MongoDB_Array.TeiidArray.LanguageClass FROM MongoDB_Array.TeiidArray WHERE MongoDB_Array.TeiidArray.LanguageClass IS NOT NULL
org.teiid.jdbc.TeiidSQLException: TEIID30504 2051904800: TEIID18027 Any operations on array type column LanguageClass are not supported currently.
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667)
at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63)
at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515)
at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:511)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:393)
at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:327)
at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.getColumnsFromJDBCQuery(BaseJdbcMetaDataFactoryImpl.java:180)
at com.jaspersoft.ji.semantic.action.DomainDesignerAction.runJDBCQuery(DomainDesignerAction.java:2111)
> 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)
11 years, 6 months
[JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2848:
-------------------------------------
"array" is a reserved type, if you want you that as column name, it needs to be in double quotes.
As per next one, can you see what is source command that is being submitted to the MongoDB translator from COMMAND_LOG?
> 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)
11 years, 6 months
[JBoss JIRA] (TEIID-2848) MongoDB: Provide Array support
by Ivan Chan (JIRA)
[ 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)
11 years, 6 months
[JBoss JIRA] (TEIID-3123) Exception when using dense_rank() in Teiid Development
by Joseph CHIDIAC (JIRA)
Joseph CHIDIAC created TEIID-3123:
-------------------------------------
Summary: Exception when using dense_rank() in Teiid Development
Key: TEIID-3123
URL: https://issues.jboss.org/browse/TEIID-3123
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.8
Reporter: Joseph CHIDIAC
Assignee: Steven Hawkins
Fix For: 8.9, 9.x, 8.8
SELECT DISTINCT
subQueryTable.jiraissue_ASSIGNEE AS jiraissue_ASSIGNEE,
dense_rank() over(order by subQueryTable.jiraissue_ID DESC) as CalculatedField1
FROM jiraissue
LEFT OUTER JOIN
(SELECT jiraissue_sub.ASSIGNEE AS jiraissue_ASSIGNEE,
COUNT(IFNULL(jiraissue_sub.ID, -2147483648))
AS jiraissue_ID
FROM jiraissue jiraissue_sub
WHERE ((jiraissue_sub.RESOLUTIONDATE BETWEEN NULL
AND PARSETIMESTAMP(
'2014-09-10 18:46:28',
'yyyy-MM-dd HH:mm:ss')))
GROUP BY jiraissue_sub.ASSIGNEE) subQueryTable
ON jiraissue.ASSIGNEE =
subQueryTable.jiraissue_ASSIGNEE
The query sent to the JDBC :
SELECT DISTINCT DENSE_RANK() OVER (ORDER BY NULL DESC) FROM "JIRADB"."dbo"."jiraissue" g_0
and i got this error :
java.sql.SQLException: Windowed functions do not support constants as ORDER BY clause expressions.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 6 months