Polybase has a maximum row size of 32 KB in SQL Server (or 1 MB in Azure Synapse Analytics). As a good rule of thumb, when creating NVARCHAR columns with the CREATE EXTERNAL TABLE statement, set the size to 255 unless you need more space. This will also help to make processing times faster and avoid using more resources than necessary.
ODBC drivers in Polybase: Avoiding issues with NVARCHAR columns
This topic has been closed for replies.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.