EXPORT to Azure Blob Storage does not work with multibyte CSV separators or delimiters

Detail name	Value
Changelog Number	19711
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0, Exasol 8.0.0
Fix Versions	Exasol 7.1.26, Exasol 8.26.0
Resolution Date	2024-03-15

Description

Exasol normally supports multibyte CSV column separators and delimeters, as shown in the documentation. EXPORT into Azure Blob Storage, however, does not work with multibyte CSV column separators or delimiters.

Example EXPORT statement

EXPORT table1 INTO CSV AT CLOUD AZURE BLOBSTORAGE 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net' user 'user1' identified by 'user1pw' file 'testcontainer/test.csv' column separator='||' column delimiter='%%';

Example error message

[URL rejected: Bad hostname],[3],[URL using bad/illegal format or missing URL]]

Workaround

As a workaround, use single-byte column separators and delimiters when EXPORTing into Azure Blob Storage.

Fix

EXPORT into Azure Blob Storage works as expected with multibyte CSV column separators or delimiters.