Google Bigquery: Incompatible table partitioning s

问题:

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; 

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.

回答1:

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>