You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
DatabaseError: (google.cloud.bigquery.dbapi.exceptions.DatabaseError) 400
PARTITION BY expression must be
_PARTITIONDATE,
DATE(_PARTITIONTIME),
DATE(<timestamp_column>),
DATE(<datetime_column>),
DATETIME_TRUNC(<datetime_column>, DAY/HOUR/MONTH/YEAR),
a DATE column,
TIMESTAMP_TRUNC(<timestamp_column>, DAY/HOUR/MONTH/YEAR),
DATE_TRUNC(<date_column>, MONTH/YEAR),
or RANGE_BUCKET(<int64_column>, GENERATE_ARRAY(<int64_value>, <int64_value>[, <int64_value>]))
Passing e.g. type_="MONTH" works since that's a supported partitioning function.
The text was updated successfully, but these errors were encountered:
Changing
field="timestamp_c"
tofield="date_c"
intest_create_table
(python-bigquery-sqlalchemy/tests/system/test_sqlalchemy_bigquery.py
Line 584 in 7a4c3c2
Passing e.g.
type_="MONTH"
works since that's a supported partitioning function.The text was updated successfully, but these errors were encountered: