Hive表描述乱码

1.打开mysql查看当前编码

mysql> s

看到当前编码格式

2.接着输入下面语句查看

mysql> show variables like "char%";

vim /etc/my.cnf

在mysqld里面添加下面的属性

[mysqld]

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

然后重启mysql

service mysqld restart

mysql> show variables like "char%";

然后进入hive元数据库

mysql> use hive;

#修改表字段注解和表注解
mysql> alter table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8
mysql> alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8
#修改分区字段注解：
mysql> alter table PARTITION_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8 ;
mysql> alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8;
#修改索引注解：
mysql> alter table INDEX_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;

乱码问题解决