[
https://issues.apache.org/jira/browse/HIVE-4536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
sutao bian updated HIVE-4536:
-----------------------------
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.
was:
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,string(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,string(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.
> INSERT OVERWRITE LOCAL DIRECTORY sum() function will write error result to
> local file
> -----------------------------------------------------------------------------------------
>
> Key: HIVE-4536
> URL: https://issues.apache.org/jira/browse/HIVE-4536
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.8.1
> Reporter: sutao bian
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
