IMPORT/EXPORT using Azure Blob Storage may fail
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11708 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.5 |
| Fix Versions | Exasol 7.0.8 |
| Resolution Date | 2021-03-16 |
Description
Due to improperly verified SSL certificates, the following commands may fail if HTTPS is used:
IMPORT INTO table1 FROM CSV AT CLOUD AZURE BLOBSTORAGE 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net' USER '<AccountName>' IDENTIFIED BY '<AccountKey>' FILE '<container>/<blob>'
EXPORT table1 INTO CSV AT CLOUD AZURE BLOBSTORAGE 'DefaultEndpointsProtocol=https;EndpointSuffix=core.windows.net' USER '<AccountName>' IDENTIFIED BY '<AccountKey>' FILE '<container>/<blob>'
In these cases, the error message will contain 'Error in SSL handshake'.
Using HTTP as the DefaultEndpointsProtocol is not affected.
Workaround
Use HTTP instead of HTTPS.
IMPORT INTO table1 FROM CSV AT CLOUD AZURE BLOBSTORAGE 'DefaultEndpointsProtocol=http;EndpointSuffix=core.windows.net' USER '<AccountName>' IDENTIFIED BY '<AccountKey>' FILE '<container>/<blob>'
HTTP does not provide encryption.
Fix
IMPORT/EXPORT with Azure Blob Storage will work with HTTPS
