Skip to content

Supports NULL in arrays #6556

@izveigor

Description

@izveigor

Is your feature request related to a problem or challenge?

Follow on to #6384

The function make_array was implemented in arrow-datafusion without supporting null elements, I think it would be better to take the concept to support NULLS in different arrays and their methods.

All methods should support this feature, especially the method array_to_string (See PR: #6384) should support null_string argument to replace NULL with it.

Describe the solution you'd like

I suggest to consider use try_new method (See https://docs.rs/arrow/latest/arrow/array/struct.PrimitiveArray.html#method.try_new)

Examples:

select make_array(NULL);
----
NULL
select make_array(1, NULL, 2, 3, NULL);
----
1 NULL 2 3 NULL
select array_to_string(make_array(1, NULL, 2, 3, NULL), ',', '*');
----
1,*,2,3,*

Describe alternatives you've considered

No response

Additional context

Simillar Issues:
#6119

Simillar PR:
#3122
#3199

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions