icexelloss commented on PR #34912: URL: https://github.com/apache/arrow/pull/34912#issuecomment-1505757739
> Also, how does first compare with something like LIMIT 1? I see them as different things. `limit` to me seems like "get partial results from the full results". `first` feels like a ordered required aggregation function, which can be used with group by, window aggregations. `limit` can only be used (IIRC) as the last statement in the query plan, while `first` can appear in the middle. > Do you think there is value in instead implementing something like nth_value? E.g. https://docs.snowflake.com/en/sql-reference/functions/nth_value I think there is value. I can look into if this is easy to do. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
