[jira] [Created] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

[jackylau (Jira)]

jackylau created CALCITE-5734:
---------------------------------

             Summary: Add ARRAY_COMPACT for Spark dialect
                 Key: CALCITE-5734
                 URL: https://issues.apache.org/jira/browse/CALCITE-5734
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.35.0
            Reporter: jackylau
             Fix For: 1.35.0


rray_compact(array) - Removes null values from the array.

*Examples:*

 

{{> SELECT array_compact(array(1, 2, 3, null));}}

{{ [1,2,3]}}

{{> SELECT array_compact(array("a", "b", "c"));}}

{{ ["a","b","c"]}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)