drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3914) Support geospatial queries
Date Thu, 15 Oct 2015 12:21:05 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14958814#comment-14958814

ASF GitHub Bot commented on DRILL-3914:

Github user k255 commented on the pull request:

    Fixed bug with complex geometries caused by to small buffer. Now it's possible to build
more complex geometries.Would be nice if somebody could check the way I handled it (buffer
    I also have some progress on integration with gis tools as shown here: http://bit.ly/1Rcvrjd

> Support geospatial queries
> --------------------------
>                 Key: DRILL-3914
>                 URL: https://issues.apache.org/jira/browse/DRILL-3914
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Client - JDBC, Functions - Drill
>            Reporter: Karol Potocki
> Implement spatial query functionality in Drill to provide location based queries and
filtering. It could be similar to PostGIS for Postgres and allow queries like:
> select * from
>     (select columns[2] as location, columns[4] as lon, columns[3] as lat,
>         ST_DWithin(ST_Point(-121.895, 37.339), ST_Point(columns[4], columns[3]), 0.1)
as isWithin
>         from dfs.`default`.`/home/k255/drill/sample-data/CA-cities.csv`
>     )
>     where isWithin = true;
> Working proposal is available at http://github.com/k255 (see drill-gis and drill fork).

This message was sent by Atlassian JIRA

View raw message