[jira] [Created] (SPARK-32587) SPARK SQL writing to JDBC target with bit datatype using Dataframe is writing NULL values

["Mohit Dave (Jira)" <ji...@apache.org>]

Mohit Dave created SPARK-32587:
----------------------------------

             Summary: SPARK SQL writing to JDBC target with bit datatype using Dataframe is writing NULL values
                 Key: SPARK-32587
                 URL: https://issues.apache.org/jira/browse/SPARK-32587
             Project: Spark
          Issue Type: Bug
          Components: Spark Core
    Affects Versions: 2.4.5
            Reporter: Mohit Dave


While writing to a target in SQL Server using Microsoft's SQL Server driver using dataframe.write API the target is storing NULL values for BIT columns.

 

Table definition

Azure SQL DB 

1)Create 2 tables with column type as bit

2)Insert some record into 1 table

Create a SPARK job 

1)Create a Dataframe using spark.read with the following query

select <bit_column> from <source_table>

2)Write the dataframe to a target table with bit type  as column.

 

Observation : Bit type is getting converted to NULL at the target

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org