Skip to content

HivePartitioningOptions does not have option to set require partition filter #251

@hidarapaneni

Description

@hidarapaneni

in bigquery API i see four options mode,uriprefix,requirepartitionfilter & fields.. but in java client i just see two options(first 2).. not sure if this was intentional..

https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#hivepartitioningoptions

requirePartitionFilter (boolean)

enabling requirepartition filter out side of hivepartitionoptions throws out error ---> Caused by: com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
{
"code" : 400,
"errors" : [ {
"domain" : "global",
"message" : "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.",
"reason" : "invalid"
} ],
"message" : "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.",
"status" : "INVALID_ARGUMENT"
}

Metadata

Metadata

Assignees

Labels

api: bigqueryIssues related to the googleapis/java-bigquery API.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions