We recently updated Knime to 4.3 and the new CSV Writer is causing an error when we try to update our Azure Synapse SQL using the CSV on Azure Blob Storage.
To clarify, the previous version of the CSV Writer node would always quote the missing values for strings. So, the missing string values would be like “” on the csv file.
The new version doesn’t do that, instead it asks you how you would handle the missing values. When you choose to quote them. It also quotes the numeric fields.
Afterwards, when you execute the insert from temp table to table it results the following error:
ERROR DB SQL Executor 0:480 Execute failed: HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: HadoopExecutionException: Could not find a delimiter after string delimiter.
Do you know how to fix that using the new node?