使用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;