Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

Add FIRST/LAST aggregations #718

Closed
smola opened this issue May 21, 2019 · 2 comments · Fixed by #749
Closed

Add FIRST/LAST aggregations #718

smola opened this issue May 21, 2019 · 2 comments · Fixed by #749
Assignees
Labels

Comments

@smola
Copy link
Collaborator

smola commented May 21, 2019

  • Let's consider adding FIRST/LAST aggregations.
  • Present in Spark SQL, not sure if in MySQL.
  • In gitbase, these are useful, for example, to get all blobs with any of their associated file names. In our case, running in gitbase-spark-connector without push down may be fine (I'm playing with that now).
@smola smola added the feature label May 21, 2019
@juanjux
Copy link
Contributor

juanjux commented May 29, 2019

There doesn't seem to be implementation of these in MySQL but there are the window functions FIRST_VALUE and LAST_VALUE. Would be nice to have them in go-mysql-server anyway.

@erizocosmico
Copy link
Contributor

erizocosmico commented Jun 5, 2019

FIRST_VALUE and LAST_VALUE require windows (not the OS), which we don't have and is significantly more complex.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants