cgqfzy commented on issue #821: URL: https://github.com/apache/sedona/issues/821#issuecomment-1517318371
> Spark doesn't recognize the geometry type in Postgis. It will encode the geometry in EWKB format. When I tested on my machine it was even hex encoded. > > Does it work if you change the type of geom to string and then create a view converting it to a geometry with ST_GeomFromWKB? > > CREATE TEMPORARY table test_polygon ( geom string ) .... CREATE VIEW polygon as SELECT ST_GeomFromWKB(geom) FROM test_polygon Yes, I can read the data in postgis with this method, but it will report an error when writing the geometry in sedona to postgis. Do you have any better suggestions? -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
