search

Azure / azure-sqldb-spark

This project provides a client library that allows Azure SQL DB or SQL Server to act as an input source or output sink for Spark jobs.
MIT License
75 stars 52 forks source link

Bulk copy issues withe numeric data type #51

Closed david-nguyen closed 4 years ago

david-nguyen commented 4 years ago

Using the dataset I'm able to perform a basic insert against the dataframe with no issue. However, when switching the command to use bulkCopyToSQLDB I experience issues with the data type: com.microsoft.sqlserver.jdbc.SQLServerException: One or more values is out of range of values for the decimal SQL Server data type

Narrowing it down to just one column for troubleshooting the max value in the column is 1328569.91 and the column definition is numeric(15,6). Is there something to be aware of when working with Azure SQL DW?