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.

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

Failed to execute 'CreateSchema' statements #167

Closed
fargoun opened this issue Mar 18, 2023 · 1 comment
Closed

Failed to execute 'CreateSchema' statements #167

fargoun opened this issue Mar 18, 2023 · 1 comment

Comments

@fargoun
Copy link

fargoun commented Mar 18, 2023

I ran a BigQuery simulator with project 'test' using the following command:
bigquery-emulator-darwin-amd64 --project=test--log-level=info
I then tried to execute a 'CREATE SCHEMA' statment that looked like this:
bq --api http://0.0.0.0:9050 query --project_id=test "CREATE SCHEMA bla"

but that failed with:
BigQuery error in query operation: Error processing job 'test:bqjob_r149afc08a272eda2_00000186f6ea6546_1': failed to analyze: INVALID_ARGUMENT: Statement not supported: CreateSchemaStatement [at 1:1]

There were no useful logs from the simulator, just:
2023-03-19T00:50:01.949+0200 INFO contentdata/repository.go:161 {"query": "CREATE SCHEMA bla", "values": []}

I did look a bit into ZetaSql, but it seems that it does support the Create Schema statement, so this seems like a specific issue in BigQuery simulator

@goccy
Copy link
Owner

goccy commented Mar 24, 2023

A list of supported features of Google Standard SQL can be found here. Create Schema is currently not supported

https://github.com/goccy/go-zetasqlite#status

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

No branches or pull requests

2 participants