drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AnilKumar B <akumarb2...@gmail.com>
Subject Re: Execute Mongo functions through Drill
Date Tue, 31 Oct 2017 17:05:31 GMT
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 <
ext-jose.castiblanco@here.com> 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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message