Skip to content

Time partitioning on DATE column fails with type_="DAY" #1056

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.

Sign up for GitHub

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

Jump to bottom
Closed
bnaul opened this issue Apr 5, 2024 · 0 comments · Fixed by #1074
Closed

Time partitioning on DATE column fails with type_="DAY" #1056

bnaul opened this issue Apr 5, 2024 · 0 comments · Fixed by #1074
Assignees
@chalmerlowe
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API.

Comments

@bnaul
Copy link
Contributor

bnaul commented Apr 5, 2024 •
edited by chalmerlowe
Loading

Changing field="timestamp_c" to field="date_c" in test_create_table (

python-bigquery-sqlalchemy/tests/system/test_sqlalchemy_bigquery.py

Line 584 in 7a4c3c2

field="timestamp_c",
) gives the following error:

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.
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. label Apr 5, 2024
@bnaul bnaul mentioned this issue Apr 5, 2024
Closed
bnaul added a commit to replicahq/pybigquery that referenced this issue Apr 5, 2024
@bnaul
fix: Fix partitioning by DATE column
43ac9e8 
Fixes googleapis#1056.
@chalmerlowe chalmerlowe self-assigned this Apr 8, 2024
@chalmerlowe chalmerlowe mentioned this issue Apr 8, 2024
Closed
@chalmerlowe chalmerlowe mentioned this issue May 2, 2024
Open
bnaul added a commit to replicahq/pybigquery that referenced this issue May 9, 2024
@bnaul
fix: Fix partitioning by DATE column
8c13404 
Fixes googleapis#1056.
bnaul added a commit to replicahq/pybigquery that referenced this issue May 9, 2024
@bnaul
fix: Fix partitioning by DATE column
3da9bee 
Fixes googleapis#1056.
bnaul added a commit to bnaul/python-bigquery-sqlalchemy that referenced this issue May 13, 2024
@bnaul @chalmerlowe
fix: Fix partitioning by DATE column
6cb65cd 
Fixes googleapis#1056.

Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>
@bnaul bnaul mentioned this issue May 13, 2024
Merged
chalmerlowe added a commit that referenced this issue May 13, 2024
@bnaul @chalmerlowe
fix: Fix partitioning by DATE column (#1074)
ad69c63 
Fixes #1056.

Co-authored-by: Chalmer Lowe <chalmerlowe@google.com>
@bnaul bnaul mentioned this issue Sep 19, 2024
Open
@chalmerlowe chalmerlowe mentioned this issue Mar 17, 2025
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@chalmerlowe chalmerlowe

Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API.
Projects
None yet
Milestone
No milestone
2 participants
@bnaul @chalmerlowe