[ 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} > 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} -- This message was sent by Atlassian Jira (v8.20.10#820010)