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: [email protected]
For additional commands, e-mail: [email protected]
