解决hue查询中文报错问题

hue 4.0查询查询中包含中文报一下错误

(1366, Incorrect string value: \\xE4\\xBA\\xAC\\xE4\\xB8\\x9C... for column search at row 1)

解决方案如下：

ALTER TABLE desktop_document2 modify column name varchar(255) CHARACTER SET utf8;

ALTER TABLE desktop_document2 modify column description longtext CHARACTER SET utf8;

ALTER TABLE desktop_document2 modify column search longtext CHARACTER SET utf8;

转载于:https://www.cnblogs.com/wq920/p/7911845.html