You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "sutao bian (JIRA)" <ji...@apache.org> on 2013/05/10 11:47:16 UTC
[jira] [Updated] (HIVE-4536) INSERT OVERWRITE LOCAL DIRECTORY
sum() function will write error result to local file
[ 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