1. SQL:
select '201804' month_id,
'-1' std_prvnce_cd,
'-1' std_latn_cd,
sum(case
when t.billing_cycle_id = '201804' and
t.target_code = 'M1101100001' then
t.target_value
end) n_dy_yd_cz,
sum(case
when t.billing_cycle_id = '201803' and
t.target_code = 'M1101100001' then
t.target_value
end) n_sy_yd_cz
from ods_db.ta_collect_target_m t
where t.billing_cycle_id in ('201804', '201803', '201704')
and t.target_code in
('M1101100001', 'M1103100012', 'M1290100001', 'M1290100002')
group by '201804', '-1', '-1';
--201804 -1 -1 -1.0 2.85372191E8 <--result
2.SQL Explain Result:
Version：Hive 1.1, CDH 5.4.7
3.Problem:
*As we can see from the first picture, the fourth column in result should
be a double type, but it shows -1.0, this is incorrect.*
*The second picture, value expressions should be two double type, but it
shows string and double.*
*This problem has been resolved in 5.7.2, we want to know the related JIRAs
or reason.*
*Thanks!*
