8:20 p.m.
[
https://issues.jboss.org/browse/TEIID-2887?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-2887.
---------------------------------
Labels: Beta3 teiid (was: teiid)
Resolution: Done
The issue was MongoDB does not like names with "." in the top level projections,
which is done using $group phase. Since the names were derived from tables columns, in
this case the name was from child table so name pattern is "name.childname" thus
failing.
Corrected the code such that it always builds an alias for all the column references.
This also need to be pulled into 8.4.1 roll-up
MongoDB: mongodb DBCollection aggregate error
----------------------------------------------
Key: TEIID-2887
URL: https://issues.jboss.org/browse/TEIID-2887
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7
Environment: Teiid 8.7 Beta1 with MongoDB
Reporter: Ivan Chan
Assignee: Ramesh Reddy
Labels: teiid, Beta3
Fix For: 8.7
Here is my simple JSON object:
"addresst" { "_id": 0,
"name": "Duke Grant",
"age": 38,
"gender": "male",
"address": { "_id": 0,
"street": "345 Burnett Street",
"city": "Nash",
"state": "Rhode Island",
"zip": 7384 }
}
And I define a schema like following:
REATE FOREIGN TABLE addresst (custid integer PRIMARY KEY, name varchar(25), age integer,
gender varchar(25)) OPTIONS(UPDATABLE 'TRUE');
CREATE FOREIGN TABLE address (custid integer PRIMARY KEY, street varchar(50), city
varchar(25), state varchar(25), zipcode varchar(6), FOREIGN KEY (custId) REFERENCES
addresst (custid)) OPTIONS(UPDATABLE 'TRUE' , "teiid_mongo:MERGE"
'addresst');
Got exception when trying to execute a query like following:
select "MongoDB_addresst"."gender" as
"MongoDB_addresst_gender",
"MongoDB_address"."state" as "MongoDB_address_state"
from "MongoDB"."addresst" "MongoDB_addresst"
inner join "MongoDB"."address" "MongoDB_address" on
("MongoDB_addresst"."custid" =
"MongoDB_address"."custid")
group by "MongoDB_addresst"."gender",
"MongoDB_address"."state"
order by "MongoDB_addresst_gender", "MongoDB_address_state"
limit 1000
Exception:
Caused by: com.mongodb.CommandFailureException: { "serverUsed" :
"qa-mongodb.jaspersoft.com/172.17.1.48:27017" , "errmsg" :
"exception: dotted field names are only allowed at the top level" ,
"code" :
16405 , "ok" : 0.0}
at com.mongodb.CommandResult.getException(CommandResult.java:71)
at com.mongodb.CommandResult.throwOnError(CommandResult.java:110)
at com.mongodb.DBCollection.aggregate(DBCollection.java:1308)
at
org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:99)
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:317)
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)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
... 3 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira