[
https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jackylau updated CALCITE-5778:
------------------------------
Description:
h3.
[array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]
array_join(array, delimiter[, nullReplacement]) - Concatenates the elements of
the given array using the delimiter and an optional string to replace nulls. If
no value is set for nullReplacement, any null value is filtered.
*Examples:*
{code:java}
> SELECT array_join(array('hello', 'world'), ' ');
hello world
> SELECT array_join(array('hello', null ,'world'), ' ');
hello world
> SELECT array_join(array('hello', null ,'world'), ' ', ',');
hello , world{code}
h3.
[arrays_overlap|https://spark.apache.org/docs/latest/api/sql/index.html#arrays_overlap]
arrays_overlap(a1, a2) - Returns true if a1 contains at least a non-null
element present also in a2. If the arrays have no common element and they are
both non-empty and either of them contains a null element null is returned,
false otherwise.
*Examples:*
{code:java}
> SELECT arrays_overlap(array(1, 2, 3), array(3, 4, 5));
true {code}
was:
h3.
[array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]
array_join(array, delimiter[, nullReplacement]) - Concatenates the elements of
the given array using the delimiter and an optional string to replace nulls. If
no value is set for nullReplacement, any null value is filtered.
*Examples:*
{code:java}
> SELECT array_join(array('hello', 'world'), ' ');
hello world
> SELECT array_join(array('hello', null ,'world'), ' ');
hello world
> SELECT array_join(array('hello', null ,'world'), ' ', ',');
hello , world{code}
> Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect
> ------------------------------------------------------------
>
> Key: CALCITE-5778
> URL: https://issues.apache.org/jira/browse/CALCITE-5778
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.35.0
> Reporter: jackylau
> Assignee: jackylau
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.35.0
>
>
> h3.
> [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join]
> array_join(array, delimiter[, nullReplacement]) - Concatenates the elements
> of the given array using the delimiter and an optional string to replace
> nulls. If no value is set for nullReplacement, any null value is filtered.
> *Examples:*
> {code:java}
> > SELECT array_join(array('hello', 'world'), ' ');
> hello world
> > SELECT array_join(array('hello', null ,'world'), ' ');
> hello world
> > SELECT array_join(array('hello', null ,'world'), ' ', ',');
> hello , world{code}
> h3.
> [arrays_overlap|https://spark.apache.org/docs/latest/api/sql/index.html#arrays_overlap]
> arrays_overlap(a1, a2) - Returns true if a1 contains at least a non-null
> element present also in a2. If the arrays have no common element and they are
> both non-empty and either of them contains a null element null is returned,
> false otherwise.
> *Examples:*
> {code:java}
> > SELECT arrays_overlap(array(1, 2, 3), array(3, 4, 5));
> true {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
