[teiid-issues] [JBoss JIRA] (TEIID-3038) Add spatial query support to the Teiid MongoDB translator

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy resolved TEIID-3038.
---------------------------------
        Labels: Beta1  (was: )
    Resolution: Done


Changed the function parameter types on all $geo functions to "double" from big integer. So to issue a query user needs to use format like

{code}
SELECT * FROM tracks WHERE mongo.geoIntersects(loc, 'Polygon', ((cast(-77.800884 as double), cast(43.300259 as double)), (cast(-77.794790 as double), cast(43.300259 as double)), (cast(-77.794790 as double), cast(43.297886 as double)), (cast(-77.800884 as double), cast(43.297886 as double)), (cast(-77.800884 as double), cast(43.300259 as double))))
{code}


> Add spatial query support to the Teiid MongoDB translator
> ---------------------------------------------------------
>
>                 Key: TEIID-3038
>                 URL: https://issues.jboss.org/browse/TEIID-3038
>             Project: Teiid
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: Misc. Connectors
>    Affects Versions: 8.8
>            Reporter: Michael Farwell
>            Assignee: Ramesh Reddy
>              Labels: Beta1
>             Fix For: 8.7.1, 8.9
>
>
> We'd like to be able to issue geoIntersects and geoWithin queries through the MongoDB translator.  See comment below on a proposed approach.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)