-
Notifications
You must be signed in to change notification settings - Fork 219
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.
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
BigQuery Dialect - Qualify Usage Issue #124
Comments
Here is something that can help: #115. |
thank you for the response @pgrivachev - I forgot to mention, I already had this enabled |
@jrbangit , you can try this way :
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I am using ZetaSQL to parse queries executed from BigQuery. I came across this scenario.
Apparently, in BigQuery, when you use the QUALIFY function, whether you use it with or without a where clause, it is gonna push through. However, if you parse that query in ZetaSQL and the query utilizes QUALIFY function without the WHERE clause, it's gonna fail to parse it.
com.google.zetasql.io.grpc.StatusRuntimeException: INVALID_ARGUMENT: QUALIFY clause must be used in conjunction with WHERE or GROUP BY or HAVING clause
is this an expected scenario? which in case of BigQuery dialect, we will have to create a work around or adding WHERE 1=1 or something? just to add context, the queries we are parsing are from audit logs.
sample query:
The text was updated successfully, but these errors were encountered: