如何使用获取分区表在BQ命令行中设置大查询要求分区过滤器 [英] How to Set Big Query Require Partition Filter in BQ Commandline With Ingestion Partition Tables

问题描述

我正在尝试在创建表后将分区过滤器要求添加到表中.由于

  $ bq更新--require_partition_filter --time_partitioning_type = DAY灰色排序挑战:afl_ml.partition_filter_test表'grey-sort-challenge:afl_ml.partition_filter_test'已成功更新. 

I am trying to add a partition filter requirement to a table after creating it. I know one can do this for tables that are partitioned by a column thanks to this post and kennethmac2000 but I this solution doesn't appear to work for ingestion date partitioned tables.

At first I tried

bq update --require_partition_filter project:dataset.table

and I then I tried

bq update --time_partitioning_type DAY --require_partition_filter project:dataset.table

and both result in...

UpdateTable() got an unexpected keyword argument 'range_partitioning'

Any and all help would be greatly appreciated.

解决方案

It works fine for me on CLI version:

$ gcloud --version
Google Cloud SDK 215.0.0
beta 2018.07.16
bq 2.0.34
core 2018.09.04
gsutil 4.33

$ bq update --require_partition_filter --time_partitioning_type=DAY grey-sort-challenge:afl_ml.partition_filter_test
Table 'grey-sort-challenge:afl_ml.partition_filter_test' successfully updated.

这篇关于如何使用获取分区表在BQ命令行中设置大查询要求分区过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！