[teiid-issues] [JBoss JIRA] (TEIID-3243) MongoDB: doens't support more than 1 aggregation in SQL
Steven Hawkins (JIRA)
issues at jboss.org
Tue Dec 13 09:05:00 EST 2016
[ https://issues.jboss.org/browse/TEIID-3243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13337832#comment-13337832 ]
Steven Hawkins commented on TEIID-3243:
---------------------------------------
The change to add the support was with this issue, but I don't see what situations you would use that in?
The issue with the supports property is that the logic is a little inconsistent. It assumes that the property can be on a getter or setter, but then looks for the setter by always prepending "set". So yes that needs it's own issue.
> MongoDB: doens't support more than 1 aggregation in SQL
> --------------------------------------------------------
>
> Key: TEIID-3243
> URL: https://issues.jboss.org/browse/TEIID-3243
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.8
> Environment: MongoDB with Teiid
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: Alpha2
> Fix For: 8.10
>
>
> Got exception if I have more than 1 aggregation in SQL for MongoDB:
> Original SQL
> SELECT COUNT(MongoNestedDocDS.addresst.age) AS c_0, SUM(MongoNestedDocDS.addres
> st.age) AS c_1 FROM MongoNestedDocDS.addresst LIMIT 1000
> Got exception:
> Caused by: org.teiid.jdbc.TeiidSQLException: TEIID30504 -1880007235: TEIID18024 multiple aggregate symbols are not sup
> 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.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261)
> at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)
> Can we consider to use in memory engine instead if more than 1 aggregation?
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list