Support array sort for nested array #9252
Description
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