apache / datafusion

Apache DataFusion SQL Query Engine
https://datafusion.apache.org/
Apache License 2.0
5.5k stars 1.02k forks source link

General ticket for Array/List data type #6863

Open izveigor opened 1 year ago

izveigor commented 1 year ago

Is your feature request related to a problem or challenge?

This is a common ticket for all other tickets. The ticket was created for the next purposes:

Describe the solution you'd like

Tickets:

Array creating:

Array functions:

Array operators:

Cast:

Concept:

Other:

Discussions:

Describe alternatives you've considered

Additional context

ahirner commented 2 months ago

Any idea whether aggregations on array elements are covered in this epic? I had no success so far:

> select max(unnest([1,3,5]));
type_coercion
caused by
Internal error: Unnest should be rewritten to LogicalPlan::Unnest before type coercion.
This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker
jayzhan211 commented 2 months ago

Yes! But since we are working on strengthening existing function, so not yet works on these.

On Fri, May 3, 2024, 11:50 AM Alexander Hirner @.***> wrote:

Any idea whether aggregations on array elements are covered in this epic? I had no success so far:

select max(unnest([1,3,5])); type_coercion caused by Internal error: Unnest should be rewritten to LogicalPlan::Unnest before type coercion. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker

— Reply to this email directly, view it on GitHub https://github.com/apache/datafusion/issues/6863#issuecomment-2092073806, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADZCLR4DOSM7XTQZL2F5CDLZAMCQ7AVCNFSM6AAAAAA2AGNMUKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAOJSGA3TGOBQGY . You are receiving this because you are subscribed to this thread.Message ID: @.***>