Kettle PDI Error on creating DB Table from text file

When using a csv or txt file to populate a DB table with Kettle / PDI you may see an error like:

Couldn't execute SQL: ... BLOB/TEXT column 'COLUMNNAME' used in key specification without a key length

This is caused as Pentaho Kettle / PDI automatically set's CSV / Text fields to datatype "TINYTEXT"

Labels

pentaho pentaho Delete
kettle kettle Delete
pdi pdi Delete
index index Delete
mysql mysql Delete
csv csv Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.