[
https://issues.apache.org/jira/browse/FLINK-40357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shengyao He updated FLINK-40357:
--------------------------------
Priority: Major (was: Minor)
> Add ARRAY_FLATTEN function
> --------------------------
>
> Key: FLINK-40357
> URL: https://issues.apache.org/jira/browse/FLINK-40357
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Reporter: Shengyao He
> Priority: Major
>
> Add ARRAY_FLATTEN function to flatten nested arrays into a single array,
> similar to Snowflake, Redshift, and RisingWave.
> h2. Syntax
> {code:sql}
> ARRAY_FLATTEN(array)
> {code}
> h2. Example
> {code:sql}
> SELECT ARRAY_FLATTEN(ARRAY[ARRAY[1, 2], ARRAY[3, 4]]);
> -- Returns: [1, 2, 3, 4]
> SELECT ARRAY_FLATTEN(ARRAY[ARRAY['a', 'b'], ARRAY['c']]);
> -- Returns: ['a', 'b', 'c']
> {code}
> h2. Use Cases
> - Processing nested JSON data
> - Simplifying array aggregation results
> - Data transformation pipelines
> h2. Reference Implementations
> -
> [Snowflake|https://docs.snowflake.com/en/sql-reference/functions/array_flatten]
> - [AWS
> Redshift|https://docs.aws.amazon.com/redshift/latest/dg/array_flatten.html]
> - [RisingWave|https://docs.risingwave.com/sql/functions/array]
> I can contribute this implementation if approved.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
