This patch fixes this, please note that the patch from this post, http://kimsnetblog.blogspot.com/2010/02/infobright-exporter-lines-terminated-by.html, have to be applied first.
This patch allows you to use the Infobright importer while defining a line terminator, like this:
LOAD DATA INFILE '/tmp/outfile.csv' INTO TABLE ibtest LINES TERMINATED BY '\t'By default the Infobright importer supports \r\n and \n as line terminators, and figures it out automatically, but if another line terminator are used, importing the file will fail.
The patch has to be applied in the Infobright source root.
importLinesTerminated.patch (4 KB)
Patch file for ICE 3.3.1:
importLinesTerminatedBy331.patch (4 KB)