Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.8.1
-
None
-
None
-
None
Description
When i use insert overwrite local directory to sum, it will write a error result
729.4000000000001 . the correct result is 729.4.
sometimes it will write correct result ,sometimes it write erro result.
hive S -e " INSERT OVERWRITE LOCAL DIRECTORY '/opt/data/data1' select concat(year,'',month,'',day),flog_appid,case when flog_country ='null' then 'UNKNOW' else flog_country end,sum(flog_expense) from tbl_ad_finance_log where year='${YEAR}' and month='${MONTH}' and day='${DAY}' group by flog_appid,case when flog_country ='null' then 'UNKNOW' else flog_country end,concat(year,'',month,'-',day)"
2013-05-09^A72665@5136b689dc317bc003000003^AIN^A729.4000000000001
hive S -e " INSERT OVERWRITE LOCAL DIRECTORY '/opt/data/data2' select concat(year,'',month,'',day),flog_appid,case when flog_country ='null' then 'UNKNOW' else flog_country end,sum(flog_expense) from tbl_ad_finance_log where year='${YEAR}' and month='${MONTH}' and day='${DAY}' group by flog_appid,case when flog_country ='null' then 'UNKNOW' else flog_country end,concat(year,'',month,'-',day)"
2013-05-09^A72665@5136b689dc317bc003000003^AIN^A729.4
Thanks in advance.