[
https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14949357#comment-14949357
]
ASF GitHub Bot commented on DRILL-3914:
---------------------------------------
Github user k255 commented on the pull request:
https://github.com/apache/drill/pull/191#issuecomment-146679625
I added some general tests to check if geometry functions work as expected.
I'm happy that you like it. Currently it's quite simple but it can grow.
One direction is to take care of limited size of varbinary (introduce new
type or extend size of existing one) because it limits geometry to just simple
shapes.
> 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)
