• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tmysqlbulkexec 'IGNORE' statement setting

#1 2009-09-16 11:11:26

jamesm
Member
Registered: 2009-08-11
Posts: 18

tmysqlbulkexec 'IGNORE' statement setting

Hi everyone,

from mysql docs http://dev.mysql.com/doc/refman/5.0/en/load-data.html :
"LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
<...>
If you specify IGNORE, input rows that duplicate an existing row on a unique key value are skipped" - that is exactly what i need,
but the tmysqlbulkexec component seems to only offer the insert/replace/update options for advanced setting
"Action of data". Insert is without either of REPLACE|IGNORE, replace is with REPLACE, update creates temporary table and UPDATES
all the rows from the source table with the rows of temporary table having same keys. But i'd like to have the IGNORE statement.

is that possible?
if not, should i fill in an issue in a bugtracker?

thanks,
jamesm

Offline

#2 2009-09-17 05:48:11

shong
Talend team
Registered: 2007-08-29
Posts: 10294
Website

Re: tmysqlbulkexec 'IGNORE' statement setting

Hello
Yes, you are right. You can report a new feature on our bugtracker.

Thanks for you support!

Best regards

          shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tmysqlbulkexec 'IGNORE' statement setting

Board footer

Powered by FluxBB