Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3914

Support geospatial queries

    XMLWordPrintableJSON

Details

    Description

      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).

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              k255 Karol Potocki
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: