解决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;