hive中注释乱码（设置数据库编码utf-8）

临时Mysql数据库设置编码格式

set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;

永久设置
修改 vi /etc/my.cnf

[mysqld]
character-set-server=utf8
character-set-filesystem = utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

之后重启mysql

hive的元数据库如果是mysql的话可以按照上述第二种方式，之后删除乱码的表重新创建。