擅长:python、mysql、java
<p>菲利佩的建议应该行得通。另一种可能性是,如果您能够修改要加载到BigQuery中的CSV,则在加载作业上使用<a href="https://developers.google.com/bigquery/docs/reference/v2/jobs#configuration.load.ignoreUnknownValues" rel="nofollow">ignoreUnknownValues</a>标志:</p>
<blockquote>
<p>[Optional] Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false which treats unknown values as errors. For CSV this ignores extra values at the end of a line. For JSON this ignores named values that do not match any column name.</p>
</blockquote>
<p>但是,使用此标志将需要重新排序CSV中的列或将数据格式化为JSON。在</p>