How to store date with year before 1900 in synapse delta lake table ?

Heta Desai 216 Reputation points
2022-09-06T06:58:50.603+00:00

I need to pull data from SQL Server and load into synapse delta lake table. In SQL Server table there is datetime column in which there is date with year before 1900. When I tried to load this data into synapse delta lake it throws and error that year can not be before 1900.

Please suggest me the way to store datetime value with year before 1900 in synapse delta lake table.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,884 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,302 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 30,506 Reputation points Microsoft Employee
    2022-09-07T14:45:49.063+00:00

    Hi @Heta Desai ,

    Thanks for posting query in Microsoft Q&A Platform.

    Kindly try to execute below code on Spark pool to make sure before 1900 dates also allowed on Spark. 

    spark.conf.set("spark.sql.legacy.parquet.int96RebaseModeInWrite", "CORRECTED")

    Please let us know how it goes.

    Hope this helps. Please let me know if any further queries.

    ------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    1 person found this answer helpful.