seatunnel icon indicating copy to clipboard operation
seatunnel copied to clipboard

transform generates a uuid from a postgresql function and updates the ID field value in the database table

Open sandyustc opened this issue 1 year ago • 3 comments

Search before asking

  • [X] I had searched in the feature and found no similar feature requirement.

Description

In seatunnel, transform wants to read the sql function written by itself from the target database to generate uuid and update the target database field. How to write the plug-in, or is there another way to deal with it

Usage Scenario

No response

Related issues

No response

Are you willing to submit a PR?

  • [X] Yes I am willing to submit a PR!

Code of Conduct

sandyustc avatar Mar 21 '24 06:03 sandyustc

you can implement the UDF to generate uuid, please refer https://seatunnel.apache.org/docs/2.3.4/transform-v2/sql-udf

liunaijie avatar Mar 21 '24 09:03 liunaijie

you can implement the UDF to generate uuid, please refer https://seatunnel.apache.org/docs/2.3.4/transform-v2/sql-u

@liunaijie thanks

I have already done that, in fact, I have another idea, is to use plugins in the sink to handle business data, etc., that plugin should inherit from those classes, thanks!

sandyustc avatar Mar 22 '24 01:03 sandyustc

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

github-actions[bot] avatar Apr 22 '24 00:04 github-actions[bot]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.

github-actions[bot] avatar May 07 '24 00:05 github-actions[bot]