GeoServer Compatibility

apache / pinot

Apache Pinot - A realtime distributed OLAP datastore

https://pinot.apache.org/

Apache License 2.0

5.53k stars 1.3k forks source link

GeoServer Compatibility #12805

Open robertzych opened 7 months ago

robertzych commented 7 months ago

"GeoServer is an open-source server for sharing geospatial data. Designed for interoperability, it publishes data from any major spatial data source using open standards." GeoServer depends on GeoTools, an open-source Java library that supports Postgres/PostGIS, Oracle, SQL Server, and other databases.

PostGISDialect.java references the following geospatial functions that are not supported by Pinot:

ST_Dimension
ST_Envelope
ST_EstimatedExtent
ST_Extent
ST_Force2D
ST_NDims
ST_Simplify
ST_SimplifyPreserveTopology
ST_SRID

xiangfu0 commented 7 months ago

cc: @ankitsultana @yupeng9 can you help evaluate the effort for this task?

robertzych commented 7 months ago

GeoServer doesn't strictly require the missing functions. Implementing the missing functions would offload the work from GeoServer to Pinot and could therefore improve query performance.

Except for ST_SimplifyPreserveTopology which may require JTS/GEOS, most of the remaining functions may be simple to implement.

mghildiy commented 7 months ago

I may give it a try if its still looking for contribution.

mghildiy commented 7 months ago

Any lead on which part should I first look into to implement it?

PeterCorless commented 4 months ago

@robertzych ☝️