search

microsoft / sql-spark-connector

Apache Spark Connector for SQL Server and Azure SQL
Apache License 2.0
273 stars 118 forks source link

Overwrite option question #171

Closed baatch closed 2 years ago

baatch commented 2 years ago

Hi,

I'm wondering about the overwrite option. Is it dropping/truncating the table and then inserting in a single transaction? Or will there be a time windows when the table does not exist or is truncated?

luxu1-ms commented 2 years ago

@baatch If the table exists, overwrite option with isTruncate=true will truncate the table, then insert to the table. Overwrite option with isTruncate not true will drop the table, then create the table, then insert to it.

luxu1-ms commented 2 years ago

close inactive incident