Dylan He created FLINK-35915:
--------------------------------
Summary: Add MASK function
Key: FLINK-35915
URL: https://issues.apache.org/jira/browse/FLINK-35915
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: Dylan He
Add MASK function as the same in Spark.
----
Returns a masked version of the input str.
Example:
{code:sql}
> SELECT MASK('AaBb123-&^ % 서울 Ä');
XxXxnnn-&^ % 서울 X
> SELECT MASK('AaBb123-&^ % 서울 Ä', 'Z', 'z', '9', 'X');
ZzZz999XXXXXXXXXZ
{code}
Syntax:
{code:sql}
MASK(str[, upperChar[, lowerChar[, digitChar[, otherChar]]]])
{code}
Arguments:
* {{str}}: A STRING expression.
* {{upperChar}}: A single character STRING literal used to substitute upper
case characters. The default is 'X'. If upperChar is NULL, upper case
characters remain unmasked.
* {{lowerChar}}: A single character STRING literal used to substitute lower
case characters. The default is 'x'. If lowerChar is NULL, lower case
characters remain unmasked.
* {{digitChar}}: A single character STRING literal used to substitute digits.
The default is 'n'. If digitChar is NULL, digits remain unmasked.
* {{otherChar}}: A single character STRING literal used to substitute any
other character. The default is NULL, which leaves these characters unmasked.
Returns:
A STRING.
See also:
*
[Spark|https://spark.apache.org/docs/3.5.1/sql-ref-functions-builtin.html#string-functions]
*
[Databricks|https://docs.databricks.com/en/sql/language-manual/functions/mask.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
