看起来您正在附加到已启用自动检测的现有表。禁用自动检测可能会解决此问题

2024-09-28 18:45:46 发布

您现在位置:Python中文网/ 问答频道 /正文

我想使用python将append数据转换为大查询。它对我来说一直都很好,但现在突然出现了如下错误:

It looks like you are appending to an existing table with autodetect enabled. Disabling autodetect may resolve this.

我试着把autodetect改成False,如下所示,但也不起作用,我该怎么办?你知道吗

# Job configuration
    self.job_config.source_format = bigquery.SourceFormat.CSV
    self.job_config.skip_leading_rows = 1
    self.job_config.autodetect = False
    if self.schema != None:
        self.job_config.schema = self.schema
    if self.disposition == 'truncate':
        self.job_config.write_disposition = bigquery.WriteDisposition.WRITE_TRUNCATE
    elif self.disposition == 'append':
        self.job_config.write_disposition = bigquery.WriteDisposition.WRITE_APPEND

Tags: 数据selfconfigfalseifschema错误job