This content has been marked as final.
Show 2 replies
-
1. Re: MongoDB: A few schema configuration questions
rareddy Jan 30, 2014 8:59 PM (in response to broitman)Assaf,
- Nested documents - I see nesting is supported but require a reference to the parent ID. If my documents do not have this parent ID, is there still a way to map it? (in our example below, map casePhoneNumbers
Unfortunately Yes, it does require a parent ID, also it requires in the DBRef format. Like this
{ "_id" : "1002", "first_name" : "John", "last_name" : "Doe", "Address" : { "street" : "123 Main St", "city" : "Chicago", "state" : "IL", "zipcode" : "60659", "_id" : DBRef("Customer", "1002") } }
As I mentioned on the document, it is harder for existing documents to map to use translator with out some amount of re-work to data or re-write using the Teiid. The translator requires the documents to be in certain format so that it can generate queries effectively from SQL.
Right now the "location" will also be an issue, as we have not added "Array" support. If you want you can open a JIRA for support of this.
Geospatial data support is also lacking in current version, you can certainly add JIRA for this too.
Sorry could not be much help.
Ramesh..