New: Dremio GIS Project

1

Hey guys,

Anyone here wish to perform GIS queries via Dremio? Well, good news. I have ported the excellent drill-gis project to run in Dremio:

See the tests/ folder on the github page for example usage.

You can download the JAR from here: https://github.com/christyharagan/dremio-gis/releases/download/0.0.3/dremio-gis-0.0.3-SNAPSHOT.jar

Then copy the JAR to the jars/3rdparty folder of every node in your Dremio cluster, and restart the cluster.

Christy

7 Likes
2

Good job. Thank you.

1 Like
3

Hello
Is there any chance, the project started by kelly becomes official and supported ?
regards

4

any update on methods to query geo data?

1 Like
5

That would be great !

6

If anyone reaches this thread, I re-ported this functionality again to match with modern Dremio code:

Comes complete with maven central artifacts generation and Dremio CE version compatibility, caveat mapping , as well as updated dependencies.

Dremio UDF GIS

Cheers :sunglasses:

2 Likes
7

Updates: This project is gaining maturity.

ESRI API upgraded to JTS,
Modernized APIs
WKB/EWKB support for reading geom directly from PostGIS is also confirmed to work.

Dremio UDF GIS

2 Likes
8

Updates:

  • JTS Upgraded to 1.19.0
  • Dremio 21.2 and 22.0 support added
  • Lots of GIS functionality added:
    • ST_Perimeter
    • ST_IsCollection,
    • ST_IsEmpty,
    • ST_Collect (Both dual argument and aggregate variant implementations are supported),
    • ST_Centroid,
    • ST_ConvexHull
    • ST_Intersection
    • ST_Transform (3 variants)
    • ST_Angle (3 variants)
    • ST_Azimuth
    • ST_Union aggregative variant
  • Massive update to the WIKI usage page

Versions for available either on github or in maven central

Dremio UDF GIS

2 Likes