是否可以从BigQuery表中删除Partition filter = Required设置? [英] Is it possible to remove the Partition filter=Required setting from BigQuery table?

问题描述

我已经存在一个设置为Partition filter=Required的表 我想禁用它，这样我就可以在表上运行查询，而不必在WHERE中指定分区列.

I have existed table with setting of Partition filter=Required I want to disable it so I can run queries on the table without having to specify the partition column in the WHERE.

是否可以或者必须创建一个新表并将数据复制到该表?

Is it possible or must I create a new table and copy data to it?

推荐答案

是否可以或者必须创建一个新表并将数据复制到该表中?

Is it possible or must I create a new table and copy data to it?

是的，您可以使用 ALTER命令来更改您的表，如下所示:

Yes, You can use an ALTER command to alter your table as follow:

#standardSQL
ALTER TABLE IF EXISTS mydataset.newtable
SET OPTIONS(
    require_partition_filter = false
)

如果需要，可以使用同一命令将require_partition_filter更改回true

You can change the require_partition_filter back to true if needed using the same command

这篇关于是否可以从BigQuery表中删除Partition filter = Required设置?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！