Andrew Lamb

> This is not surprising to me. During the sort we are probably building a string array and probably using some kind of resize-on-append string building that is doubling and...

@Kontinuation has a PR with a proposed fix: - https://github.com/apache/datafusion/pull/14644/

We have similar special functions for this type of function in InfluxDB (needed to get the max by time, for example) in case that helps this We call them selector...

`FIRST_VALUE` / `LAST_VALUE` with `ORDER BY` is a great call. Here is the code if anyone is interested: https://github.com/apache/datafusion/blob/main/datafusion/functions-aggregate/src/nth_value.rs

> As I'm thinking about it, I'm not sure you can get around doing the sort since you have an arbitrary number of ordering clauses. I think what you've proposed...

Thanks everyone

Marking as draft as I think this PR is no longer waiting on feedback. Please mark it as ready for review when it is ready for another look

I suggest we revive this PR as it seems to have gotten lost / not reviewed 😢

> I have created the follow-up issues for #11268: Awesome -- thank you @goldmedal -- I added them to the ticket description too (as I think this then generates back...

It looks to me like we have completed most of the planned work here and it is no longer active so closing it down to clean up our tickets a...