Dan Hansen
Dan Hansen
Hi, last I checked it was not supported by google/zetasql. `MAX_BY` and `MIN_BY` functions are synonymous with `ANY_VALUE(x HAVING MAX y)` or `ANY_VALUE(x HAVING MIN y)`, you can use those...
I've released a fix for this in the Recidiviz fork of the emulator - version `v0.6.6-recdiviz.2` https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.2
I've released a fix for this in the Recidiviz fork of the emulator - version `v0.6.6-recdiviz.2` https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.2
Support for the copy configuration handler has been implemented and released in the Recidiviz fork of the emulator https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.0
Hi @orlevyhs, are you sure this is incorrect behavior? Running the query in the BigQuery console and with the bq CLI shows the following: ### `query.txt` ``` CREATE TEMP TABLE...
Is there any chance you're running into #335? Could you try replicating this against the Recidiviz fork which has #335 merged? https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.4.4-recidiviz.26
No problem :) I maintain that fork. Hopefully we'll get the repositories consolidated soon.
A fix for using reserved keywords as struct keys has been implemented and released in the Recidiviz fork of the emulator https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.0
I've implemented and released fixes that harden functions when passed null arrays in the Recidiviz fork https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.0
This was fixed and released in the Recidiviz fork of the emulator `v0.6.6-recidiviz.1` https://github.com/Recidiviz/bigquery-emulator/releases/tag/v0.6.6-recidiviz.1