[Feature][SDK] Transform SQL support Concat_ws function - Githubissues

apache / inlong

Apache InLong - a one-stop, full-scenario integration framework for massive data

https://inlong.apache.org/

Apache License 2.0

1.4k stars 530 forks source link

[Feature][SDK] Transform SQL support Concat_ws function #10881

Closed MOONSakura0614 closed 2 months ago

MOONSakura0614 commented 2 months ago

Description

parent issue https://github.com/apache/inlong/issues/10796

CONCAT_WS(string1, string2, string3,…)

Returns a string that concatenates STRING2, STRING3, … with a separator STRING1. The separator is added between the strings to be concatenated.
Returns NULL If STRING1 is NULL.
Compared with concat(), concat_ws() automatically skips NULL arguments.

Use case

concat_ws(’~’, ‘AA’, Null(STRING), ‘BB’, ‘’, ‘CC’) ---> “AA~BB~~CC”

Are you willing to submit PR?

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

Code of Conduct

[X] I agree to follow this project's Code of Conduct

github-actions[bot] commented 2 months ago

Hello @MOONSakura0614, thank you for opening your first issue in InLong 🧡 We will respond as soon as possible ⏳ If this is a bug report, please provide screenshots or error logs for us to reproduce your issue, so we can do our best to fix it. If you have any questions in the meantime, you can also ask us on the InLong Discussions 🔍