![]() Other bulk copy options can be set as options on the dataframe and will be passed to bulkcopy APIs on write Performance comparisonĪpache Spark Connector for SQL Server and Azure SQL is up to 15x faster than generic JDBC connector for writing to SQL Server. Implements an insert with TABLOCK option to improve write performanceĭisables strict data frame and sql table schema check when set to false Set this value to data source name to write a data pool table in Big Data Clusters None implies the value is not set and the connector should write to SQL Server single instance. NO_DUPLICATES implements an reliable insert in executor restart scenarios In addition following options are supported OptionīEST_EFFORT or NO_DUPLICATES. The Apache Spark Connector for SQL Server and Azure SQL supports the options defined here: SQL DataSource JDBC Reliable connector support for Sql Server Single Instance. ![]() Support for write to SQL Server Single instance and Data Pool in SQL Server Big Data Clusters. ![]()
0 Comments
Leave a Reply. |