You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "jackwangcs (Jira)" <ji...@apache.org> on 2022/05/11 01:52:00 UTC
[jira] [Updated] (FLINK-26939) Add TRANSLATE supported in SQL & Table API
[ https://issues.apache.org/jira/browse/FLINK-26939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jackwangcs updated FLINK-26939:
-------------------------------
Attachment: image-2022-05-11-09-51-21-400.png
> Add TRANSLATE supported in SQL & Table API
> ------------------------------------------
>
> Key: FLINK-26939
> URL: https://issues.apache.org/jira/browse/FLINK-26939
> Project: Flink
> Issue Type: Sub-task
> Reporter: dalongliu
> Priority: Critical
> Attachments: image-2022-05-11-09-51-21-400.png
>
>
> Syntax:
> translate(expr, from, to)
>
> Arguments:
> * {{{}expr{}}}: A STRING expression.
> * {{{}from{}}}: A STRING expression consisting of a set of characters to be replaced.
> * {{{}to{}}}: A STRING expression consisting of a matching set of characters to replace {{{}from{}}}.
> Return:
> A STRING
>
> Examples:
> {code:java}
> > SELECT translate('AaBbCc', 'abc', '123');
> A1B2C3
> > SELECT translate('AaBbCc', 'abc', '1');
> A1BC
> > SELECT translate('AaBbCc', 'abc', '');
> ABC {code}
> See more
> * [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf]
> * [Databricks|https://docs.databricks.com/sql/language-manual/functions/translate.html]
--
This message was sent by Atlassian Jira
(v8.20.7#820007)