擅长:python、mysql、java
<p>在BigQuery<a href="https://cloud.google.com/bigquery/docs/exporting-data#export_limitations" rel="nofollow noreferrer">export limitations</a>中,提到CSV不支持嵌套和重复的数据。因此,请尝试导出到Avro或JSON:</p>
<pre><code>from google.cloud import bigquery
client = bigquery.Client()
bucket_name = 'your_bucket'
project = 'bigquery-public-data'
dataset_id = 'samples'
table_id = 'shakespeare'
destination_uri = 'gs://{}/{}'.format(bucket_name, '<your_file>')
dataset_ref = client.dataset(dataset_id, project=project)
table_ref = dataset_ref.table(table_id)
configuration = bigquery.job.ExtractJobConfig()
#For AVRO
#configuration.destination_format ='AVRO'
#For JSON
#configuration.destination_format ='NEWLINE_DELIMITED_JSON'
extract_job = client.extract_table(
table_ref,
destination_uri,
job_config=configuration,
location='US')
extract_job.result()
</code></pre>
<p>希望有帮助。在</p>