解决hue窗口中文报错问题

在hue中查询条件加了中文,或者有中文注释都会报错
(1366, Incorrect string value:… for column search at row 1)

修改hue元数据库的字符编码

alter database hue character set latin1;alter table beeswax_queryhistory modify `query` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;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;