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

Michael Farwell (JIRA) issues at jboss.org
Mon Aug 25 15:57:59 EDT 2014


    [ https://issues.jboss.org/browse/TEIID-3038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12995574#comment-12995574 ] 

Michael Farwell edited comment on TEIID-3038 at 8/25/14 3:57 PM:
-----------------------------------------------------------------

Ramesh,

Thanks for implementing these functions.  The geoPolygonIntersects() function works great, but I'm having trouble with the other functions.

SELECT * FROM tracks WHERE mongo.geoIntersects(loc, 'Polygon', ((-77.800884, 43.300259), (-77.794790, 43.300259), (-77.794790, 43.297886), (-77.800884, 43.297886), (-77.800884, 43.300259)))

throws the following exception: 
Error: can't serialize class java.math.BigDecimal

I get the exception when there is a BigDecimal in the BasicDBList object representing the coordinates.  See MongoDBSelectVisitor.buildGeoFunction().  MongoDB does not support the BigDecimal type.  The query works if I convert the BigDecimals to Doubles in this method.  






was (Author: mdfspiff):
Ramesh,

Thanks for implementing these functions.  The geoPolygonIntersects() function works great, but I'm having trouble with the other functions.  
:

Error: can't serialize class java.math.BigDecimal.  



> 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
>             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)


More information about the teiid-issues mailing list