exasol/virtual-schema-common-document-files

Validate EDML to check for duplicate destination table name

Closed this issue · 0 comments

The S3VS allows specifying the following EDML mapping:

[{
"$schema": "https://schemas.exasol.com/edml-1.5.0.json",
"source": "file1.parquet",
"destinationTable": "TAB"
},
{
"$schema": "https://schemas.exasol.com/edml-1.5.0.json",
"source": "file2.parquet",
"destinationTable": "TAB"
}]

At runtime the VS will only include rows from the second file in the virtual table. This mapping is invalid as it uses the same destinationTable for multiple entries.

The recommended way to include multiple files in a virtual table is documented in the user guide.

See exasol/s3-document-files-virtual-schema#134 and release https://github.com/exasol/virtual-schema-common-document/releases/tag/9.4.3