-
-
Notifications
You must be signed in to change notification settings - Fork 167
Failed to execute 'CreateSchema' statements #167
Description
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