[
https://issues.apache.org/jira/browse/FLINK-41342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ramin Gharib reassigned FLINK-41342:
------------------------------------
Assignee: Ramin Gharib
> Add VARIANT_STRIP_NULLS
> -----------------------
>
> Key: FLINK-41342
> URL: https://issues.apache.org/jira/browse/FLINK-41342
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API, Table SQL / Runtime
> Reporter: Ramin Gharib
> Assignee: Ramin Gharib
> Priority: Major
>
> {code:sql}
> VARIANT_STRIP_NULLS(variant [, include_arrays]) -- VARIANT
> VARIANT_STRIP_NULLS(v)
> --
> {"items":[{"qty":2,"sku":"A1"}],"order_id":17,"user":{"email":"[email protected]","name":"ada"}}
> {code}
> Scope:
> * Removes every variant null at every depth. Removing an array element shifts
> later elements left.
> * With include_arrays = FALSE, nulls inside arrays stay.
> * A SQL NULL argument gives NULL.
> * Table API and PyFlink expressions, SQL and Table API tests, docs.
> Depends on FLINK-41338
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
