首页 > 代码库 > The expression after ELSE should have the same type as those after THEN: "bigint" is expected but "i
The expression after ELSE should have the same type as those after THEN: "bigint" is expected but "i
hive中执行sql语句:
select pc.category_id, sum(case when t.so_month between 3 and 5 then t.order_item_num else 0 end) as spring, sum(case when t.so_month between 6 and 8 then t.order_item_num else 0 end) as summer, sum(case when t.so_month between 9 and 11 then t.order_item_num else 0 end) as autumn, sum(case when t.so_month=12 or t.so_month<=2 then t.order_item_num else 0 end) as winnter from product_category pc join (select si.product_id, si.order_item_num, month(si.order_create_time) as so_month from so_item si where si.ds between '2013-05-01' and '2014-04-30' and si.is_gift=0) t on pc.product_id=t.product_id group by pc.category_id;
其中t.order_item_num是bigint类型
执行sql,提示错误
“The expression after ELSE should have the same type as those after THEN: "bigint" is expected but "int" is found”
解决办法:
把else后面的0改为0L即可!
select pc.category_id, sum(case when t.so_month between 3 and 5 then t.order_item_num else 0L end) as spring, sum(case when t.so_month between 6 and 8 then t.order_item_num else 0L end) as summer, sum(case when t.so_month between 9 and 11 then t.order_item_num else 0L end) as autumn, sum(case when t.so_month=12 or t.so_month<=2 then t.order_item_num else 0L end) as winnter from product_category pc join (select si.product_id, si.order_item_num, month(si.order_create_time) as so_month from so_item si where si.ds between '2013-05-01' and '2014-04-30' and si.is_gift=0) t on pc.product_id=t.product_id group by pc.category_id;
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。