Skip to content
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

Add require_partition_filter in bigquery.external_config.HivePartitioningOptions #255

Closed
asokratis opened this issue Sep 1, 2020 · 0 comments · Fixed by #257
Closed

Add require_partition_filter in bigquery.external_config.HivePartitioningOptions #255

asokratis opened this issue Sep 1, 2020 · 0 comments · Fixed by #257
Assignees
@HemangChothani
Labels
api: bigquery Issues related to the googleapis/python-bigquery API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@asokratis
Copy link

I want to force partition filters when user run queries on external tables that uses HivePartitioning.

Please add property require_partition_filter within bigquery.external_config.HivePartitioningOptions()

I tried using table.require_partition_filter = True, but I get an error when my table contains hive_partitioning within external_data_configuration:

google.api_core.exceptions.BadRequest: 400 POST require_partition_filter has been set for a hive-partitioned table without using the HivePartitioningOptions. To configure external, hive-partitioned tables -- including setting require_partition_filter -- please use the HivePartitioningOptions. Setting require_partition_filter on the top-level table definition, or via the TimePartitioning field, does not configure hive-partitioned tables.
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery API. label Sep 1, 2020
@yoshi-automation yoshi-automation added the triage me I really want to be triaged. label Sep 2, 2020
@HemangChothani HemangChothani added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. and removed triage me I really want to be triaged. labels Sep 3, 2020
@HemangChothani HemangChothani self-assigned this Sep 3, 2020
@HemangChothani HemangChothani mentioned this issue Sep 4, 2020
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@HemangChothani HemangChothani

Labels
api: bigquery Issues related to the googleapis/python-bigquery API. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat: expose require_partition_filter for hive_partition MaxxleLLC/python-bigquery
3 participants
@asokratis @yoshi-automation @HemangChothani