idea连接hive查询表时字段别名出现中文乱码

问题:查询数据时给字段起别名,运行MR程序后出现中文乱码

//查询"01"课程比"02"课程成绩低的学生的信息及课程分数:
select a1.*,s.c_id `01课程`,s.s_score `01课程成绩`,s2.c_id `02课程`,s2.s_score `02课程成绩`
from student a1
join score s on a1.s_id = s.s_id and s.c_id='01'
join score s2 on a1.s_id = s2.s_id and s2.c_id='02'
where s.s_score < s2.s_score;

解决:

  第一步:修改idea编码为UTF-8,找到 settings 选项

   第二步:将font修改为Monospaced或者NSimSun或者SimHei或者SimSun

原文地址:https://www.cnblogs.com/LzMingYueShanPao/p/14762538.html