Cast between array elements

[izveigor]

Is your feature request related to a problem or challenge?

Arter Pull Request: #6384, In arrow-datafusion casting between arrays elements stopped working. The feature could be of great help when working with different types of data.

Describe the solution you'd like

All rules should be simillar to the cast function in arrow-rs (See https://docs.rs/arrow/latest/arrow/compute/kernels/cast/index.html)

For example, if we create new array with Int32Type and Int64Type should return Int64Array.

select make_array(Int32(1), Int64(2));
----
Int64(1), Int64(2)

Describe alternatives you've considered

No response

Additional context

Simillar Issues:
#6119
#6075

Simillar PR:
#6384

[jayzhan211]

How to determine the final data type? For example, make_array(int, uint, float), what should be the result data type?

[izveigor]

@jayzhan211 arrow-datafusion has rules for data type coercion (See https://github.com/apache/arrow-datafusion/blob/main/datafusion/expr/src/type_coercion/binary.rs)
For your instance, the result should be float data type (because Int -> UInt and UInt -> Float)

[jayzhan211]

I will take this