Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 8 Oct 2015 09:39:26 +0000 (UTC)
From: "Karol Potocki (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.12903314.1444297125000.55180.1444297166696@Atlassian.JIRA>
In-Reply-To: <JIRA.12903314.1444297125000@Atlassian.JIRA>
References: <JIRA.12903314.1444297125000@Atlassian.JIRA>
 <JIRA.12903314.1444297125257@arcas>
Subject: [jira] [Created] (DRILL-3914) Support geospatial queries
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Karol Potocki created DRILL-3914:
------------------------------------

             Summary: 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)