question

sakuraime avatar image
0 Votes"
sakuraime asked SaurabhSharma-msft commented

Azure synapse sparkdb collation

I have a external table from synapse serverless pool (serverlesstable1) and also I have another table in sparkdb (sparktable)


when I join these two tables serverlesstable1 inner join sparktable . and it tells me collation mismatch


Latin1_General_100_BIN2_UTF8 <<< this should be the spark database collation


SQL_Latin1_General_CP1_CI_AS <<< this should be the serverless database collation


how to deal with it ?

azure-synapse-analytics
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@sakuraime Thanks for using Microsoft Q&A !!
I am able to join the tables across spark and synapse serverless pool. Collation is same as yours - SQL_Latin1_General_CP1_CI_AS for serverless and Latin1_General_100_BIN2_UTF8 for Spark. Could you please share the exact error message over here ? Also, what are the datatypes of the joining columns ?

0 Votes 0 ·

@sakuraime Following up if you were able to look into my previous response.

0 Votes 0 ·

@sakuraime I am following up as I have not heard back from you.

0 Votes 0 ·
Show more comments

0 Answers