1:21 a.m.
[
https://issues.jboss.org/browse/TEIID-3243?page=com.atlassian.jira.plugin...
]
Juraj Duráni reopened TEIID-3243:
---------------------------------
Setting translator property *SupportsAggregatesCount* fails.
{code:plain|title=Exception}
08:15:26,455 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed
to start service jboss.teiid.vdb.mongo_enhancements.1:
org.jboss.msc.service.StartException in service jboss.teiid.vdb.mongo_enhancements.1:
TEIID50035 TEIID40028 No setSetSupportsAggregatesCount method found for translator
property setSupportsAggregatesCount
at org.teiid.jboss.VDBService.createConnectorManagers(VDBService.java:299)
at org.teiid.jboss.VDBService.start(VDBService.java:129)
at
org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980)
[jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
at
org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913)
[jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0-internal]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0-internal]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
Caused by: org.teiid.core.TeiidException: TEIID40028 No setSetSupportsAggregatesCount
method found for translator property setSupportsAggregatesCount
at org.teiid.deployers.TranslatorUtil.getSetter(TranslatorUtil.java:207)
at org.teiid.deployers.TranslatorUtil.injectProperties(TranslatorUtil.java:167)
at org.teiid.deployers.TranslatorUtil.buildExecutionFactory(TranslatorUtil.java:123)
at org.teiid.jboss.VDBService.getExecutionFactory(VDBService.java:320)
at org.teiid.jboss.VDBService$5.getExecutionFactory(VDBService.java:292)
at
org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManager(ConnectorManagerRepository.java:134)
at
org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManagers(ConnectorManagerRepository.java:108)
at org.teiid.jboss.VDBService.createConnectorManagers(VDBService.java:296)
... 6 more
{code}
{code:xml|title=Translator override}
<translator name="mongodb-no-count-over" type="mongodb">
<property name="SupportsAggregatesCount" value="false"/>
</translator>
{code}
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)
2948
days inactive
2948
days old
0 comments
1 participants
participants (1)
-
Juraj Duráni (JIRA)