解决hue&hive中文报错问题

　　在Hue中创建表或进行查询时有中文语句时会报错，这是因为hue默认字符集不支持中文造成的，修改Hue的数据库相关表字符编码即可解决
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;

2.修改hive库

alter table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8;
alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8;