hive中COMMENT乱码

1.问题描述

默认Hive中创建有中文注释的表时，无论是在Hive CLI还是Hue中该注释显示都会是乱码

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| amon               |
| cm                 |
| hive               |
| hue                |
| monitor            |
| mysql              |
| oozie              |
| performance_schema |
| sys                |
+--------------------+

mysql> use hive;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> alter  table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8;
Query OK, 8 rows affected (0.21 sec)
Records: 8  Duplicates: 0  Warnings: 0