Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or RO

使用kettle将hive数据导出至MySQL，报错

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

解决：

进入mysql数据库，修改参数

set global innodb_file_per_table=1;

set global innodb_file_format=Barracuda;

修改表ROW_FORMAT为DYNAMIC或COMPRESSED

ALTER TABLE table_name ROW_FORMAT=COMPRESSED;