Google Bigquery Specification: Incompatible Table

When sending a copy job from a temporary table that is not split into a destination table with a partition for the day, I get

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 restrictions on the input table for the task of copying to a partitioned table and how can they be overcome? A temporary table is created inside the adoop superdocument class using Load job. And JobConfigurationLoad does not have a TimePartitioning specification at all.

+1
source share
1 answer

- ? , . - :

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

Source: https://habr.com/ru/post/1679437/


All Articles