InfoBright LOAD DATA INFILE Wrong data or column definition
You can use SET clause of LOAD DATA INFILE to truncate values that are being read from file on the fly

LOAD DATA INFILE '/path/o/your/file.txt'
INTO TABLE table_name
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"' 
  LINES TERMINATED BY '\n'
(column1, @column2, column3, ...) -- first you read a value into a variable
SET column2 = LEFT(@column2, 100) -- then you assign truncated value to the column