Am using the mysql bulk exec to load a .csv to a mysql db. I have about 1800 records in the file, but only 900 are being loaded (exactly half). I have several other jobs using the same logic running fine.
Doing a straight import from phpMyAdmin works fine using the same .csv, so not sure what the issue is.
Are there any rejected rows which are not processed by your MySql DB? Could you please show us your job design screenshots on community which will be helpful for us to understand your situation very well?
screen shots attached...I have the error log set to write to a file, but there are no errors. Just doesn't make sense that I can import the .csv source without issue in phpmyadmin but the load job from talend doesn't work.
We are supposing that there are null values for your columns which cannot be loaded and handled. What does your rejected rows look like?
From your screenshots, there is only one tmysqlbulkexec in your workflow?
The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database. These two steps are fused together in the tMysqlOutputBulkExec component.
