Hive - show create table 乱码

执行 show create table时乱码

查看元数据的编码格式, 是不是latin导致
```
show create table hive.COLUMNS_V2;
```
查看字符编码格式, 是不是utf-8
```
show variables like '%char%';
```

修改元数据格式(mysql的hive库)

alter table CLOUMNS_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_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8; 

alter table PARTITION_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;

alter table INDEX_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;

修改Hive-site.xml

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://metastore_ip/hive?useUnicode=true&characterEncoding=UTF-8</value>
</property>

重新建表, 中文可正常显示

summerflowerying / blog-summer

Hive - show create table 乱码 #66