[teiid-issues] [JBoss JIRA] (TEIID-3166) Allow allowDiskUse setting in MongoDB translator

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-3166.
---------------------------------
    Fix Version/s: 8.11
       Resolution: Done


There is no regression, the way it was designed previously was the default version of the MongoDB is set to 2.4, and useDisk option is defined to work with version 2.6. If you need to use it you need to define a translator override property "DatabaseVersion" to "2.6", and that will use the useDisk feature.

But as part of this defect, now I moved the default version of the MongoDB to 2.6, so one does not have to define the "DatabaseVersion" property to use the "useDisk" feature. Also, I made sure that this will work even for future updates of MongoDB versions that are >= 2.6.

This also exposed a error in $near and $nearSphere methods not supporting the "$minDistance" parameter when used with 2.6 version. I fixed to code, such that Teiid will generate right query based on 2.4 or >= 2.6 versions.

> Allow allowDiskUse setting in MongoDB translator
> ------------------------------------------------
>
>                 Key: TEIID-3166
>                 URL: https://issues.jboss.org/browse/TEIID-3166
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Harrison Gentry
>            Assignee: Ramesh Reddy
>            Priority: Minor
>              Labels: CR1
>             Fix For: 8.11, 8.9
>
>
> When querying a MongoDB, steps of computation are limited to 100MiB. Querying large databases can easily exceed this limit, so usually allowDiskUse:true is passed in the aggregate query:
> http://docs.mongodb.org/manual/reference/command/aggregate/
> In Teiid, however, there is currently no way to specify this with SQL.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)