topic Loading data from MySQL in Connectivity & Data Prep

Loading data from MySQL

oskuvuorinem — Mon, 13 Dec 2021 21:45:12 GMT

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

Re: Loading data from MySQL

dplr-rn — Wed, 21 Aug 2019 13:28:25 GMT

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

Re: Loading data from MySQL

oskuvuorinem — Wed, 21 Aug 2019 13:46:37 GMT

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