[teiid-issues] [JBoss JIRA] (TEIID-3243) MongoDB: doens't support more than 1 aggregation in SQL

[Ivan Chan (JIRA)]

Ivan Chan created TEIID-3243:
--------------------------------

             Summary: 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: Steven Hawkins


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
(v6.3.8#6338)