CDH6集群安装完毕,查看hive建表语句时,表注释、字段注释均显示乱码,这是因为hive的元数据库字符集编码集设置不当造成乱码。
解决如下:
0、查看mysql元数据库中hive库的原字符集编码
mysql> show create database hive;
+----------+---------------------------------------------------------------+
| Database | Create Database |
+----------+---------------------------------------------------------------+
| hive | CREATE DATABASE `hive` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1、修改database 编码集![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/ab551ee07c0d3de839790914158f849f.png)
或执行sql:
alter database metastore default character set latin1;
2、修改 hive 核心表编码集为utf8
进入hive的metastore库,执行如下sql:
use metastore;
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;