You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Taraka Rama Rao Lethavadla (Jira)" <ji...@apache.org> on 2024/03/25 16:39:00 UTC

[jira] [Created] (HIVE-28148) Implement array_compact UDF to remove all nulls from an array

Taraka Rama Rao Lethavadla created HIVE-28148:
-------------------------------------------------

             Summary: Implement array_compact UDF to remove all nulls from an array
                 Key: HIVE-28148
                 URL: https://issues.apache.org/jira/browse/HIVE-28148
             Project: Hive
          Issue Type: Sub-task
          Components: Hive
            Reporter: Taraka Rama Rao Lethavadla
            Assignee: Taraka Rama Rao Lethavadla


*array_compact(array)*

Removes NULL elements from {{{}array{}}}.

 
{noformat}
SELECT array_compact(array(1, 2, NULL, 3, NULL, 3));
=> [1, 2, 3, 3]
{noformat}
 



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