Google Bigquery:不兼容的表分区规范 [英] Google Bigquery: Incompatible table partitioning specification

问题描述

从未分区的临时表提交复制作业到按天分区的最终表时，我收到

While submitting a copy job from a temporary table that isn't partitioned to the final table that has partition by day, I recieve

cause:java.io.IOException: ErrorMessage: Incompatible table partitioning specification. Expects partitioning specification interval(type:day), but input partitioning specification is none; 

那么对于将作业复制到分区表的输入表是否有任何限制，如何克服这些限制?临时表是使用 Load 作业在 hadoop bigquery-connector 类中创建的.而且 JobConfigurationLoad 根本没有 TimePartitioning 的规范.

So are there any limitations on the input table for copy job to partitioned table and how can they be overcome? Temporary table is created inside hadoop bigquery-connector class using Load job. And JobConfigurationLoad doesn't have specification of TimePartitioning at all.

推荐答案

能否请您暂时尝试使用所需日期的分区元表?我已经在内部提交了一个问题来支持这种情况.类似以下的内容应该可以工作:

Can you please try using the partition meta-table for the desired day for the time being? I have filed an issue internally to support this scenario. Something like the following should work:

bq --project_id=<project> cp <source_table> <destination_partitioned_table$20160809>

这篇关于Google Bigquery:不兼容的表分区规范的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！