datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

Support array sort for nested array

Open jayzhan211 opened this issue 1 year ago • 0 comments

Is your feature request related to a problem or challenge?

Follow up on #8279 Benefit #9234

query error DataFusion error: Arrow error: Compute error: List\(Field \{ name: "item", data_type: Int64, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: \{\} \}\) not supported in rank
select array_sort([[[1, 0, 2]], [[1, 2, 2]], [[1, 1, 2]]]);

query ?
select array_sort([[1, 0, 2], [1, 2, 2], [1, 1, 2]]);
----
[[1, 0, 2], [1, 1, 2], [1, 2, 2]]

We can handle 2D array but fails on the higher dimension. The error xxx not supported in rank is due to arrow-rs, so this feature might need to fix the upstream first.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

File ticket upstream after the issue is clarified

jayzhan211 avatar Feb 16 '24 15:02 jayzhan211