hive中文分区字段设置

hive存数据是中文分区字段,需要设置

查看是否都是utf-8
show variables like '%char%';
如不是需配置my.cnf(/etc/my.cnf或/usr/my.cnf)
    [mysqld]
    character-set-server=utf8
重启mysql
    service mysql restart

#修改hive database编码
alter database hive default character set utf8;
#修改table编码
alter table PARTITIONS default character set utf8;
alter table PARTITION_KEY_VALS default character set utf8;
alter table SDS default character set utf8;
#修改字段编码
alter table PARTITIONS modify column PART_name varchar(190) character set utf8;
alter table PARTITION_KEY_VALS modify column PART_KEY_VAL varchar(256) character set utf8;
alter table SDS modify column LOCATION varchar(4000) character set utf8;