Hi, Seems Drill already has geospatial query support https://issues.apache.org/jira/browse/DRILL-3914.
Can you please take a look into https://github.com/k255/drill-gis and https://github.com/k255/drill-gis/blob/master/src/main/java/org/apache/drill/exec/expr/fn/impl/gis/STIntersects.java function? Thanks & Regards, B Anil Kumar. On Mon, Oct 30, 2017 at 1:29 PM, Castiblanco, Jose < [email protected]> wrote: > Hi, good afternoon. > We have a question regarding the MongoDB and Drill integration through the > Mongo storage plugin; we need to query and execute geospatial queries > through Drill using the MongoDB geospatial functions. That means we have > data in Mongo and using Drill we need to call those Mongo functions. > For example, consider we have a zones collection in Mongo with zones > information including a geojson. Directly in Mongo we can execute the > following query using the $geoIntersects Mongo function (find the zones > that intersects a specific Point) with successful results: > > db.getCollection('zones').find({ geom: { $geoIntersects: { $geometry: { > type: "Point", coordinates: [ -73.93414657, 40.82302903 ] } } } }) > > The main question: Is it possible to execute mongo functions using Drill > and how can we do it? > Also, if we want to execute the same query described above but using > Drill, is that possible? And if it is, how can we do it? > > Thanks for your help! > > Jose Luis. >
