risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
7.06k stars 581 forks source link

Support geospatial data types during cdc replication #19519

Open darkcofy opened 21 hours ago

darkcofy commented 21 hours ago

Is your feature request related to a problem? Please describe.

We use geometric data types like point,polygon, lat long in our systems. Currently tables that contain this data can't be ingested using the select * statement in risingwave as the entire table is rejected automatically

Describe the solution you'd like

Support ingesting geospatial data types from source DB into risingwave and sinking them to downstream system like iceberg for further processing.

Describe alternatives you've considered

Currently there is no alternative as there's no workaround in risingwave

Additional context

Geospatial functions aren't as important as the ability to stream this data into the system and ingest into the lake house. Further processing can be done downstream by other engines like duckdb etc