You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by "emptyOVO (via GitHub)" <gi...@apache.org> on 2024/09/27 14:29:58 UTC
[I] [Feature][SDK] Transform support COALESCE() function [inlong]
emptyOVO opened a new issue, #11219:
URL: https://github.com/apache/inlong/issues/11219
### Description
* parent issue: #10796
* from flinksql: https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/#string-functions
* COALESCE(value1 [, value2]*)--Returns the first argument that is not NULL.
If all arguments are NULL, it returns NULL as well. The return type is the least restrictive, common type of all of its arguments. The return type is nullable if all arguments are nullable as well.
### Use case
```
-- Returns 'default'
COALESCE(NULL, 'default')
-- Returns the first non-null value among f0 and f1,
-- or 'default' if f0 and f1 are both NULL
COALESCE(f0, f1, 'default')
```
### 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](https://www.apache.org/foundation/policies/conduct)
--
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: dev-unsubscribe@inlong.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org