[
https://issues.apache.org/jira/browse/FLINK-35964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dylan He updated FLINK-35964:
-----------------------------
Description:
Add STARTSWITH function.
----
Returns if {{expr}} begins with {{startExpr}}.
Example:
{code:sql}
> SELECT STARTSWITH('SparkSQL', 'Spark');
true
> SELECT STARTSWITH('SparkSQL', 'spark');
false
{code}
Syntax:
{code:sql}
STARTSWITH(expr, startExpr)
{code}
Arguments:
* {{expr}}: A STRING or BINARY expression.
* {{startExpr}}: A STRING or BINARY expression.
Returns:
A BOOLEAN.
{{expr}} and {{startExpr}} should have same type.
If {{expr}} or {{startExpr}} is NULL, the result is NULL.
If {{startExpr}} is empty, the result is true.
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/startswith.html]
was:
Add STARTSWITH function.
----
Returns if {{expr}} begins with {{startExpr}}.
Example:
{code:sql}
> SELECT STARTSWITH('SparkSQL', 'Spark');
true
> SELECT STARTSWITH('SparkSQL', 'spark');
false
{code}
Syntax:
{code:sql}
STARTSWITH(expr, startExpr)
{code}
Arguments:
* {{expr}}: A STRING or BINARY expression.
* {{startExpr}}: A STRING or BINARY expression.
Returns:
A BOOLEAN.
{{expr}} and {{startExpr}} should have same type.
If {{expr}} or {{startExpr}} is NULL, the result is NULL.
If {{startExpr}} is the empty, the result is true.
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/startswith.html]
> Add STARTSWITH function
> -----------------------
>
> Key: FLINK-35964
> URL: https://issues.apache.org/jira/browse/FLINK-35964
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dylan He
> Priority: Major
>
> Add STARTSWITH function.
> ----
> Returns if {{expr}} begins with {{startExpr}}.
> Example:
> {code:sql}
> > SELECT STARTSWITH('SparkSQL', 'Spark');
> true
> > SELECT STARTSWITH('SparkSQL', 'spark');
> false
> {code}
> Syntax:
> {code:sql}
> STARTSWITH(expr, startExpr)
> {code}
> Arguments:
> * {{expr}}: A STRING or BINARY expression.
> * {{startExpr}}: A STRING or BINARY expression.
> Returns:
> A BOOLEAN.
> {{expr}} and {{startExpr}} should have same type.
> If {{expr}} or {{startExpr}} is NULL, the result is NULL.
> If {{startExpr}} is empty, the result is true.
> 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/startswith.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
