You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "dalongliu (Jira)" <ji...@apache.org> on 2022/03/31 06:27:00 UTC

[jira] [Created] (FLINK-26939) Add TRANSLATE supported in SQL & Table API

dalongliu created FLINK-26939:
---------------------------------

             Summary: 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


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.1#820001)