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?