You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Tony Murphy (JIRA)" <ji...@apache.org> on 2013/06/11 21:06:20 UTC
[jira] [Updated] (HIVE-4714) Vectorized Sum of scalar subtract
column returns negative result when positive exected
[ https://issues.apache.org/jira/browse/HIVE-4714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tony Murphy updated HIVE-4714:
------------------------------
Summary: Vectorized Sum of scalar subtract column returns negative result when positive exected (was: Vectorized Sum of scalar subtract column numbers returns negative result when positive exected)
> Vectorized Sum of scalar subtract column returns negative result when positive exected
> --------------------------------------------------------------------------------------
>
> Key: HIVE-4714
> URL: https://issues.apache.org/jira/browse/HIVE-4714
> Project: Hive
> Issue Type: Sub-task
> Reporter: Tony Murphy
> Attachments: sum_data.zip
>
>
> Actual: -5701157.669591231
> Expected: 5701157.663489044
> {noformat}
> drop table LINEITEM_ORC;
> create external table LINEITEM_ORC(L_DISCOUNT float )
> ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
> STORED AS
> INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.CommonOrcInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';
> {noformat}
> {noformat}
> SELECT Sum(1 - l_discount) FROM Lineitem_orc
> {noformat}
--
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