是否可以从 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屋！