如何使用标准sql从BigQuery表中删除分区? [英] How to drop a partition from BigQuery table using standard sql?

问题描述

从table_name中删除，其中_PARTITIONTIME =(条件)是不需要的，因为删除/更新具有配额

delete from table_name where _PARTITIONTIME = (condition) is not needed as delete/update has quota

推荐答案

如果还没有，并且您的情况基于时间-您应该考虑设置

If not yet, and your condition is time based - you should consider setting partition expiration

更多选项(仍然取决于您的用例):

More options (still depends on your use case):

• copy 逐个分区并附加到新表中(免费操作，但每个项目的配额问题"与DML相似，而每个表的配额更好-)；
• 从select中创建表并具有各自的条件(全表扫描-各自的成本)

• copy partition by partition into new table with append (free of charge operation but have similar quota "issue" as DML per project, whereas much better quota for per table - );
• create table from select with respective conditions (full table scan - respective cost)

这篇关于如何使用标准sql从BigQuery表中删除分区?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！