Internal Server Error when using Zonemaps
Details
| Detail name | Value |
|---|---|
| Changelog Number | 19310 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.24.0 |
| Fix Versions | Exasol 8.25.0 |
| Resolution Date | 2024-02-15 |
Description
In some cases, queries containing columns that use the Zonemaps feature may fail with the following error:
Successfully reconnected after internal server error, transaction was rolled back
You can verify if a column is using Zonemaps with the following queries:
SELECT COLUMN_NAME, COLUMN_IS_ZONEMAPPED FROM EXA_ALL_COLUMNS WHERE COLUMN_TABLE = 'my_table';
or
DESCRIBE my_table;
Workaround
Set the database parameter -zonemapUseForFilterRaw=0.
Fix
In these instances, the query runs as expected.
