问Python大查询错误: google.api_core.exceptions.BadRequest: 400无法在使用dml语句的作业中设置目标表

EN

from google.cloud import bigquery

# TODO(developer): Construct a BigQuery client object.
client = bigquery.Client()

# TODO(developer): Set table_id to the ID of the destination table.
table_id = "ny.test.blue_test"

job_config = bigquery.QueryJobConfig(destination=table_id)
job_config.write_disposition = 'WRITE_APPEND'

sql = """
    Delete 
    FROM 
    `ny.test.blue` 
    WHERE name = 'Beat';
"""

# Start the query, passing in the extra configuration.
query_job = client.query(sql, job_config=job_config)  # Make an API request.
query_job.result()  # Wait for the job to complete.

print("Query results loaded to the table {}".format(table_id))