[
https://issues.apache.org/jira/browse/FLINK-35910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dylan He updated FLINK-35910:
-----------------------------
Description:
Add BTRIM function as the same in Spark, where 'B' stands for BOTH.
----
Returns {{str}} with leading and trailing characters removed.
Example:
{code:sql}
> SELECT BTRIM(' test ');
test
> SELECT BTRIM('test', 't');
es
{code}
Syntax:
{code:sql}
BTRIM(str[, trimStr])
{code}
Arguments:
* {{{}str{}}}: A STRING expression.
* {{{}trimStr{}}}: An optional STRING expression with characters to be
trimmed. The default is a space character.
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/btrim.html]
was:
Add BTRIM function as the same in Spark, where 'B' stands for BOTH.
----
Returns {{str}} with leading and trailing characters removed.
Syntax:
{code:sql}
BTRIM(str[, trimStr])
{code}
Arguments:
* {{{}str{}}}: A STRING expression.
* {{{}trimStr{}}}: An optional STRING expression with characters to be
trimmed. The default is a space character.
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/btrim.html]
> Add BTRIM function
> ------------------
>
> Key: FLINK-35910
> URL: https://issues.apache.org/jira/browse/FLINK-35910
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dylan He
> Priority: Major
>
> Add BTRIM function as the same in Spark, where 'B' stands for BOTH.
> ----
> Returns {{str}} with leading and trailing characters removed.
> Example:
> {code:sql}
> > SELECT BTRIM(' test ');
> test
> > SELECT BTRIM('test', 't');
> es
> {code}
> Syntax:
> {code:sql}
> BTRIM(str[, trimStr])
> {code}
> Arguments:
> * {{{}str{}}}: A STRING expression.
> * {{{}trimStr{}}}: An optional STRING expression with characters to be
> trimmed. The default is a space character.
> 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/btrim.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
