Skip to content

Failed to execute 'CreateSchema' statements #167

@fargoun

Description

@fargoun

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions