hive字符集问题
原因:含中文注释
解决:
sudo mysql
mysql> use hive;
# 修改字段注释字符集
mysql> alter table COLUMNS_V2 modify COMMENT varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 50263 rows affected (0.69 sec)
# 修改表注释字符集
mysql> alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
Query OK, 13340 rows affected (0.25 sec)
# 修改分区注释字符集
mysql> alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8;
Query OK, 4039 rows affected (0.09 sec)