I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB.
Is this an expected behavior of this smart service?
Is there any way to import or read a csv file with null values?
Discussion posts and replies are publicly visible
Hi,
Yes, it works with nulls only if the database columns allow null values. If columns are NOT NULL, it fails with "Error executing SQL." Update DB schema or preprocess the CSV to fix it.