exasol / exasol-virtual-schema-lua

Virtual Schema from Exasol to Exasol implemented in Lua
MIT License
1 stars 1 forks source link

Specifiy import data types explicitly #32

Closed redcatbear closed 1 year ago

redcatbear commented 1 year ago

Situation

In #21 we implemented import from a remote Exasol database. So far the IMPORT statement that the adapter generates does not contain a column type list. While that works for getting the data, it has the downside of letting the ExaLoader pick the column types. Those do not always match the ones the database expects.

What we need is to take the data types the core database in the request element selectListDataTypes and explicitly state them in the IMPORT.

Acceptance Criteria