进入hive表：

use hive;

#修改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;