You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/10/26 18:45:27 UTC
[jira] [Resolved] (DRILL-3914) Support geospatial queries
[ https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-3914.
-----------------------------------
Resolution: Fixed
Fix Version/s: 1.3.0
> 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
> Fix For: 1.3.0
>
>
> 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)