Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

QUALIFY clause without WHERE or GROUP_BY or HAVING #123

Closed
anugna21 opened this issue Sep 29, 2023 · 1 comment · Fixed by #201
Closed

QUALIFY clause without WHERE or GROUP_BY or HAVING #123

anugna21 opened this issue Sep 29, 2023 · 1 comment · Fixed by #201

Comments

@anugna21
Copy link

anugna21 commented Sep 29, 2023 •
edited
Loading

Hello,

Currently seeing this error for queries with QUALIFY clause without a WHERE:

INVALID_ARGUMENT: QUALIFY clause must be used in conjunction with WHERE or GROUP BY or HAVING clause

Looks like there is a workaround for this in zetasql as discussed here: google/zetasql#124

Any plans on adopting this change to parse queries executed from BigQuery?
@ohaibbq
Copy link
Contributor

ohaibbq commented Mar 25, 2024

@goccy Could you assign this to me?

@ohaibbq ohaibbq mentioned this issue Mar 28, 2024
Merged
@goccy goccy closed this as completed in #201 Apr 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Enable QUALIFY without GROUP BY / WHERE / HAVING Recidiviz/go-zetasqlite
2 participants
@ohaibbq @anugna21