yzeng1618 commented on issue #10155: URL: https://github.com/apache/seatunnel/issues/10155#issuecomment-3615127825
> > <img alt="Image" width="944" height="311" src="https://private-user-images.githubusercontent.com/200727089/522373980-7af894a9-c39a-4013-b642-ba916d7f8b5f.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjQ4OTkwMjIsIm5iZiI6MTc2NDg5ODcyMiwicGF0aCI6Ii8yMDA3MjcwODkvNTIyMzczOTgwLTdhZjg5NGE5LWMzOWEtNDAxMy1iNjQyLWJhOTE2ZDdmOGI1Zi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMjA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTIwNVQwMTM4NDJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wMmNmMDZiYTdmODI4ZjFiM2Y4MWZhNDkzZGRiNDE5OTBjZDEyNzUzZjkxMGRjMjVkOWNiYzkwMmViYWE5OWYzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.XXvoeVR8PDCBH9lAk2J29GFRYQPuuDpOoI-rdxwO3nY";> > > Hello, based on the current check, it seems that the issue is that the sink side does not support the GEOMETRY type. It should be resolved simply by changing the data type on the sink side to string. As can be seen from the figure above, the data type mapping is GEOMETRY --> string. It is recommended to set the corresponding type on the sink side to string and have a try. > > After changing to string type, the synchronized data is incorrect, and non-CDC PostgreSQL synchronization of the GEOMETRY type works normally. If possible, could you also please provide detailed information? For example, after modifying "sink" to "string" (or similar), what the content should be and what the actual content is—could you provide detailed desensitized data and table creation statements? Does "non-CDC PostgreSQL" refer to the offline pgsql2pgsql? Is this normal? Could you provide the desensitized pipeline? -- 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]
![https://private-user-images.githubusercontent.com/200727089/522373980-7af894a9-c39a-4013-b642-ba916d7f8b5f.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjQ4OTkwMjIsIm5iZiI6MTc2NDg5ODcyMiwicGF0aCI6Ii8yMDA3MjcwODkvNTIyMzczOTgwLTdhZjg5NGE5LWMzOWEtNDAxMy1iNjQyLWJhOTE2ZDdmOGI1Zi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMjA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTIwNVQwMTM4NDJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wMmNmMDZiYTdmODI4ZjFiM2Y4MWZhNDkzZGRiNDE5OTBjZDEyNzUzZjkxMGRjMjVkOWNiYzkwMmViYWE5OWYzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.XXvoeVR8PDCBH9lAk2J29GFRYQPuuDpOoI-rdxwO3nY"](https://private-user-images.githubusercontent.com/200727089/522373980-7af894a9-c39a-4013-b642-ba916d7f8b5f.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjQ4OTkwMjIsIm5iZiI6MTc2NDg5ODcyMiwicGF0aCI6Ii8yMDA3MjcwODkvNTIyMzczOTgwLTdhZjg5NGE5LWMzOWEtNDAxMy1iNjQyLWJhOTE2ZDdmOGI1Zi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUxMjA1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MTIwNVQwMTM4NDJaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wMmNmMDZiYTdmODI4ZjFiM2Y4MWZhNDkzZGRiNDE5OTBjZDEyNzUzZjkxMGRjMjVkOWNiYzkwMmViYWE5OWYzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.XXvoeVR8PDCBH9lAk2J29GFRYQPuuDpOoI-rdxwO3nY"){kind=link}