-
1. Re: MongoDB translator and allowDiskUse:true
rareddy Oct 8, 2014 4:24 PM (in response to asdfasdfhgentry)Can you point me to representative query option in MongoDB? and an example?
I do not think we added any option like that, but if I see there query, may be can implement such feature to MongoDB translator.
Ramesh..
-
2. Re: MongoDB translator and allowDiskUse:true
asdfasdfhgentry Oct 9, 2014 9:27 AM (in response to rareddy)The SQL query I'm trying to do is:
SELECT * FROM sales JOIN inventory ON sales.sku=inventory.sku LIMIT 100
Both of these tables are Mongo tables.
In Mongo queries, sorts are limited to 100MiB of memory usage, so my query into these gigantic databases fails. However, setting allowDiskUse:true allows the db to use the disk to store information during the sort. An example of this would be:
db.runCommand(
{ aggregate: "stocks",
pipeline: [
{ $project : { cusip: 1, date: 1, price: 1, _id: 0 } },
{ $sort : { cusip : 1, date: 1 } }
],
allowDiskUse: true
}
)
Example from http://docs.mongodb.org/manual/reference/command/aggregate/
What I'm looking for is a way to set this property on every query into the Mongo db.
-
3. Re: MongoDB translator and allowDiskUse:true
rareddy Oct 9, 2014 9:33 AM (in response to asdfasdfhgentry)I can see if I can add a hint based support to send those options to MongoDB. Can log an enhancement JIRA?
-
5. Re: MongoDB translator and allowDiskUse:true
rareddy Oct 9, 2014 3:09 PM (in response to asdfasdfhgentry)Thanks Harrison.
I am interested in knowing how has been your experience in using the MongoDB in Teiid so far? I always looking for ways to improve this further.
Thanks
Ramesh..
-
6. Re: MongoDB translator and allowDiskUse:true
asdfasdfhgentry Oct 9, 2014 3:37 PM (in response to rareddy)I've been using it for a few weeks now and it has been pretty simple so far. The only trouble I have is when I fail to notice that a Teiid Designer tutorial or documentation is for a different version than the one I'm using. The occasional reference to a button or menu that doesn't exist slows me down a bit. But now that everything is set up, it's very smooth.
-
7. Re: MongoDB translator and allowDiskUse:true
asdfasdfhgentry Oct 10, 2014 8:49 AM (in response to asdfasdfhgentry)Also, I do have one question; is there a way to see the Mongo query that the translator generates? I can't seem to find it in any logs.
-
8. Re: MongoDB translator and allowDiskUse:true
rareddy Oct 10, 2014 8:58 AM (in response to asdfasdfhgentry)"org.teiid.CONNECTOR" at debug level at DEBUG level, if not TRACE level. See standlone-teiid.xml file for log configuration or use web-console.
-
9. Re: MongoDB translator and allowDiskUse:true
rareddy Oct 21, 2014 4:44 PM (in response to asdfasdfhgentry)The fix is available in Teiid 8.9 CR1 for TEIID-3166