Unable to write Data frame to Azure Synapse Table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2022 09:36 AM
When I am trying to insert records into the azure synapse Table using JDBC Its throwing below error
com.microsoft.sqlserver.jdbc.SQLServerException: The statement failed. Column 'COMPANY_ADDRESS_STATE' has a data type that cannot participate in a columnstore index.
In Database this table have column [COMPANY_ADDRESS_STATE] datatype as Varchar(50)
df.write.format("jdbc").mode("append") \
.option('url', sqlURL)\
.option('dbTable', tableName)\
.option('user', synUser)\
.option('password',jdbcPassword).save()Can someone please guide me with the correct approach
Labels:
- Labels:
-
Azure
-
Azure databricks
-
AzureSynapse
-
Synapse