Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with loading data from MySQL database. Most of the rows and values in dataset seem to load just fine, but some rows return with null values. This seems to occur when there is cell value that is null or some other unreadable character.
Is there a parameter that I can use to load data that will ignore nulls or other unreadable values in cells?
Best regards,
Osku Vuorinen
that sounds like an issue with the driver.
can you share an exmple/screenshot of the MySQL rows where this issue occurs? and you load script too
Load is just
Load * from Table;
and result is 2 rows of good data and 1 row that only has a right key value and rest of the values are null. Loading with exactly same script from mysql client results 3 rows of good data. On that one row there is a null value in the field that nullifies all fields that are loaded after the null field.
thank you in advance,
Osku