zhilinli123 commented on PR #4673: URL: https://github.com/apache/incubator-seatunnel/pull/4673#issuecomment-1526837008
> 1. When obtaining the GEOMETRY type directly through (AbstractJdbcRowConverter.toInternal), you can only get a string of numbers that are not understandable. > > https://github.com/apache/incubator-seatunnel/blob/5430ca9621ffdd7f7ec183235eed29764ecd6205/seatunnel-connectors-v2/connector-jdbc/src/main/java/org/apache/seatunnel/connectors/seatunnel/jdbc/internal/converter/AbstractJdbcRowConverter.java#L53-L55 > > Therefore, it is necessary to introduce the PostGIS dependency, and then obtain the PGgeometry instance through the rs.getObject method and then call toString to get an understandable string. > > ``` > <dependency> > <groupId>net.postgis</groupId> > <artifactId>postgis-jdbc</artifactId> > <version>2.5.0</version> > </dependency> > ``` > > 2. Spatial data types not only include GEOMETRY but also GEOGRAPHY, which also needs to be supported. Done -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@seatunnel.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
