[
https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14948411#comment-14948411
]
ASF GitHub Bot commented on DRILL-3914:
---------------------------------------
GitHub user k255 opened a pull request:
https://github.com/apache/drill/pull/191
[DRILL-3914]: support for geospatial query functionality
Sample dataset is provided on classpath, after building from fork
repository, you can query it like:
select * from cp.`sample-data/CA-cities.csv` limit 5;
For details on current geospatial functionality please see:
https://github.com/k255/drill-gis
Currently the solution works on common use cases, but is based on varbinary
data type which has limitations for more complex geometries (size limit).
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/k255/drill master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/191.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #191
----
commit dc19cb732645b2d168f04eec521848992807cf07
Author: potocki <k...@gmx.com>
Date: 2015-10-08T06:10:33Z
gis contrib module with basic spatial queries functionality
----
> 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
(v6.3.4#6332)
