语法: if(boolean testCondition, T valueTrue, T valueFalseOrNull)
说明: 当条件testCondition为TRUE时,返回valueTrue;否则返回valueFalseOrNull
实例1:
mysql
select source,if(source='猎聘',1,2) as flag from t_cal_dowell_resume
hive:
select a,b,c,if(b='上帝',1,2) as bb from tmp.csv_t1
实例2:
select if(1 is not null,'ttt',111) from ods.ods_cdd_r_t_callinof_info;
更多推荐
hive:函数:条件函数:if函数
发布评论