[FLINK-9219] Add support for OpenGIS features in Table & SQL API

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor auto-unassigned
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 19/Apr/18 09:09
• Updated: 16/Jul/22 10:38

Description

CALCITE-1968 added core functionality for handling spatial/geographical/geometry data. It should not be too hard to expose these features also in Flink's Table & SQL API. We would need a new GEOMETRY data type and connect the function APIs.

Right now the following functions are supported by Calcite:

ST_AsText, ST_AsWKT, ST_Boundary, ST_Buffer, ST_Contains, ST_ContainsProperly, ST_Crosses, ST_Disjoint, ST_Distance, ST_DWithin, ST_Envelope, ST_EnvelopesIntersect, ST_Equals, ST_GeometryType, ST_GeometryTypeCode, ST_GeomFromText, ST_Intersects, ST_Is3D, ST_LineFromText, ST_MakeLine, ST_MakePoint, ST_MLineFromText, ST_MPointFromText, ST_MPolyFromText, ST_Overlaps, ST_Point, ST_PointFromText, ST_PolyFromText, ST_SetSRID, ST_Touches, ST_Transform, ST_Union, ST_Within, ST_Z