hive 视图中出现中文乱码

create view view_test1 as
select 
case sex when 0 then '女' when 1 then '男' else '' end as sex ,
case level when 1 then '一级' when 2 then '二级' else '' end as `level`
from tablename1

查询结果：

解决方式：

ALTER TABLE `TBLS` MODIFY COLUMN VIEW_EXPANDED_TEXT mediumtext CHARACTER SET utf8;
ALTER TABLE `TBLS` MODIFY COLUMN VIEW_ORIGINAL_TEXT mediumtext CHARACTER SET utf8;