-
Notifications
You must be signed in to change notification settings - Fork 1.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Feature][PostgreSQL-jdbc] Supports GEOMETRY data type for PostgreSQL #4652
Comments
I'd like to finish it thanks |
|
I understand it's just converted to String on the Source side because we don't know what type is downstream, right |
|
Closing issues |
Search before asking
Description
Currently, the Pg source connector does not support the GEOMETRY data type. We can convert the GEOMETRY data type to the String data type in Zeta to support the reading of GEOMETRY data types, like pg(GEOMETRY) -> zeta(String).
You may need to modify the following files in the JDBC connector:
src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/psql/PostgresTypeMapper.java
src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/dialect/psql/PostgresJdbcRowConverter.java
When testing, note that Pg needs to install the PostGIS plugin:
Create a table and insert data:
Add the GEOMETRY data type in the e2e test and check the synchronized results.
Usage Scenario
No response
Related issues
No response
Are you willing to submit a PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: