lipzhu commented on issue #24091: [SPARK-27159][SQL]update mssql server dialect 
to support binary type
URL: https://github.com/apache/spark/pull/24091#issuecomment-473127184
 
 
   > What's the difference in SQL Server? I'm just wondering if there are any 
compatibility problems with older versions, or whether there's an upside to 
changing the type?
   
   
   
   > What's the difference in SQL Server? I'm just wondering if there are any 
compatibility problems with older versions, or whether there's an upside to 
changing the type?
   
   @srowen This is a bug fix for writing binary data back to MsSql Server. 
   #24099 
   
https://github.com/apache/spark/blob/9ee60a6fe0eed6e6d4e1b4387f51849bda0c6b9c/external/docker-integration-tests/src/test/scala/org/apache/spark/sql/jdbc/MsSqlServerIntegrationSuite.scala#L170
   
   `===== FINISHED o.a.s.sql.jdbc.MsSqlServerIntegrationSuite: 'Basic write 
test' =====
   
   - Basic write test *** FAILED ***
     com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or 
variable #5: Cannot find data type BLOB.
     at 
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:868)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:768)
     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
     at 
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2930)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
     at 
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:711)
     at 
org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.createTable(JdbcUtils.scala:868)`

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to