search

goccy / bigquery-emulator

BigQuery emulator server implemented in Go
MIT License
844 stars 108 forks source link

Support of UNPIVOT operator #309

Closed pavellety closed 6 months ago

pavellety commented 7 months ago

What would you like to be added?

Hi, could you please consider to support UNPIVOT operator? Here is a doc: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#unpivot_operator

Currently I am getting:

google.api_core.exceptions.InternalServerError: 500 failed to analyze: INVALID_ARGUMENT: UNPIVOT is not supported [at 48:13]; message: failed to analyze: INVALID_ARGUMENT: UNPIVOT is not supported [at 48:13], reason: jobInternalError

Thanks a lot, Pavel

ohaibbq commented 7 months ago

This was added in go-zetasqlite v0.19.2 https://github.com/goccy/go-zetasqlite/commit/0e394c948998f68ff8f5602fc60be8c5c89fc26d / bigquery-emulator v0.6.1. Are you on the latest versions?

pavellety commented 6 months ago

Sorry I did not try new version I am currently on v0.6.0 because a few days ago there was not docker image for arm64 architecture. Do you plan to release it? Thanks a lot for reply.

pavellety commented 6 months ago

Ok.. I have used --platform option as described in README.md. Sorry for stupid question :)