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)
