-
-
Notifications
You must be signed in to change notification settings - Fork 92
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
CREATE TABLE with PARTITION BY is unsupported #152
Comments
It seems that any feature related to |
Encounter something similar |
The same is true for me. Are there any updates on this issue ? |
At the moment, I can create a partitioned table using the client libraries. At least, I won't get an error (what already helps in tests and local emulation!). The emulator, however, accepts queries that would not work with BigQuery for the schema. Here's an example. Given the following table definition {
"type": "TABLE",
"schema": {
"fields": [
{
"mode": "REQUIRED",
"name": "value",
"type": "DATE"
}
]
},
"timePartitioning": {
"field": "value",
"type": "DAY",
"expirationMs": 315569260000,
"requirePartitionFilter": true
}
} BigQuery would reject a query that does not contain the I guess it is a lot of work to support all the partitioning features of BigQuery, but I could imagine that it's easier to check if the query is valid according to |
Are there any updates on this topic ? |
Any attempt to create a table with a partition column[s] specified produces this error.
For example:
CREATE TABLE test_events_date (ID date) PARTITION BY ID
Result:
PS: used docker image ghcr.io/goccy/bigquery-emulator:0.2.13
The text was updated successfully, but these errors were encountered: