When exporting decimal values without trailing zeros, the scale is shifted.
For example:
EXPORT (select CAST(238316.38 AS DECIMAL(18,4)) as col1)
INTO SCRIPT CLOUD_STORAGE_EXTENSION.EXPORT_PATH WITH
...
the exported value results in 2383.1638 instead of 238316.3800.
This is due to mainly Exasol iterator returns decimal without trailing zeros, and the exporter use the unscaled value and scale when writing Parquet values.
This should be fixed by setting the returned scale after reading decimal values from ExaIterator.
Situation
When exporting decimal values without trailing zeros, the scale is shifted.
For example:
the exported value results in
2383.1638
instead of238316.3800
.This is due to mainly Exasol iterator returns decimal without trailing zeros, and the exporter use the unscaled value and scale when writing Parquet values.
This should be fixed by setting the returned scale after reading decimal values from ExaIterator.
Acceptance Criteria