Hive中文注释乱码问题解决

在Hive元数据库(MySQL)按照如下修改即可

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_PARAMS  modify column PARAM_VALUE varchar(4000) character set utf8;
alter table PARTITION_KEYS  modify column PKEY_COMMENT varchar(4000) character set utf8;
alter table INDEX_PARAMS  modify column PARAM_VALUE  varchar(4000) character set utf8;

建库的comment也中文乱码，不过没解决，尽量使用英文描述。

参考：https://www.jianshu.com/p/fd4ce1374015

Hive元数据表说明：
https://mp.weixin.qq.com/s?__biz=MzA3ODUxMzQxMA==&mid=2663993556&idx=1&sn=0e5291bd63426d747f32a7fd05128caa&scene=21#wechat_redirect
https://www.cnblogs.com/qingyunzong/p/8710356.html