- 1672 Views
- 2 replies
- 1 kudos
How do I specify column types when writing to a MSSQL server using the JDBC driver (
I have a pyspark dataframe that I'm writing to an on-prem MSSQL server--it's a stopgap while we convert data warehousing jobs over to databricks. The processes that use those tables in the on-prem server rely on the tables maintaining the identical s...
- 1672 Views
- 2 replies
- 1 kudos
- 1 kudos
It's happenging to me too!Did you find any solution @jonathan-dufaul ?Thanks!!
- 1 kudos
- 3348 Views
- 1 replies
- 1 kudos
import of tables to a new metastore failed with schema mismatch "specified schema does not match the existing schema"
The error i get when importing certain delta table isThe specified schema does not match the existing schema at dbfs:/mnt/mart/tablenamehowever, when i check the metadata table in the old workspace and the exported file, they match. However, it seems...
- 3348 Views
- 1 replies
- 1 kudos
- 1 kudos
below is example error. however, in existing metadata i still see varchar 100 as the type. Specified metadata for field Percentage is different from existing schema:\n Specified: {}\n Existing: {\"HIVE_TYPE_STRING\":\"varchar(100)\"}\n\nIf your inte...
- 1 kudos