In recent updates #64, we updated the Exasol JDBC driver version, that is able to query INTERVAL YEAR [(p)] TO MONTH and INTERVAL DAY [(p)] TO SECOND [(fp)] data types. However, these are converted into Spark StringType in the dataframe schema when reading a table from Exasol.
To make it robust, we should check that when saving a dataframe, the connector correctly converts interval type types into Exasol interval types.
Acceptance Criteria
Unit tests for interval type conversion exists.
Integration tests for interval type conversions is available.
Test for interval types with default behavior and with precision exists.
redcatbear
commented
2 years ago
Situation
In recent updates #64, we updated the Exasol JDBC driver version, that is able to query
INTERVAL YEAR [(p)] TO MONTHandINTERVAL DAY [(p)] TO SECOND [(fp)]data types. However, these are converted into SparkStringTypein the dataframe schema when reading a table from Exasol.To make it robust, we should check that when saving a dataframe, the connector correctly converts interval type types into Exasol interval types.
Acceptance Criteria