[
https://issues.apache.org/jira/browse/FLINK-35987?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dylan He updated FLINK-35987:
-----------------------------
Description:
Add ELT function.
----
Returns the n-th expression.
Example:
{code:sql}
> SELECT ELT(1, 'scala', 'java');
scala
{code}
Syntax:
{code:sql}
ELT(index, expr...)
{code}
Arguments:
* {{index}}: An INTEGER expression.
* {{expr}}: A STRING or BINARY expression. One expr is required as least.
Returns:
The result has the type of the least common type of all {{expr}}.
{{index}} must be between 1 and the number of {{expr}}. Otherwise, the function
returns an error.
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/elt.html]
*
[MySQL|https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_elt]
was:
Add ELT function.
----
Returns the n-th expression.
Example:
{code:sql}
> SELECT ELT(1, 'scala', 'java');
scala
{code}
Syntax:
{code:sql}
ELT(index, expr...)
{code}
Arguments:
* {{index}}: An INTEGER expression.
* {{expr}}: Any expression that shares a least common type with all {{expr}}..
Returns:
The result has the type of the least common type of all {{expr}}.
{{index}} must be between 1 and the number of {{expr}}. Otherwise, the function
returns an error.
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/elt.html]
*
[MySQL|https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_elt]
> Add ELT function
> ----------------
>
> Key: FLINK-35987
> URL: https://issues.apache.org/jira/browse/FLINK-35987
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dylan He
> Priority: Major
>
> Add ELT function.
> ----
> Returns the n-th expression.
> Example:
> {code:sql}
> > SELECT ELT(1, 'scala', 'java');
> scala
> {code}
> Syntax:
> {code:sql}
> ELT(index, expr...)
> {code}
> Arguments:
> * {{index}}: An INTEGER expression.
> * {{expr}}: A STRING or BINARY expression. One expr is required as least.
> Returns:
> The result has the type of the least common type of all {{expr}}.
> {{index}} must be between 1 and the number of {{expr}}. Otherwise, the
> function returns an error.
> 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/elt.html]
> *
> [MySQL|https://dev.mysql.com/doc/refman/8.4/en/string-functions.html#function_elt]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
