[
https://issues.apache.org/jira/browse/HAWQ-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko updated HAWQ-1054:
--------------------------------------
Description:
Looks like real values are being incorrectly rounded:
{code}
SELECT t1, r FROM pxf_hive_orc_types WHERE r = 7.7;
t1 | r
----+---
(0 rows)
SELECT t1, r FROM pxf_hive_orc_types WHERE r > 7.6;
t1 | r
----------------------+------
row1 | 7.7
row2 | 8.7
row3 | 9.7
row4 | 10.7
row5 | 11.7
row6 | 12.7
row7 | 7.7
row8 | 7.7
row9 | 7.7
row10 | 7.7
row11 | 7.7
row12_text_null | 7.7
row13_int_null | 7.7
row14_double_null | 7.7
row15_decimal_null | 7.7
row16_timestamp_null | 7.7
row18_bigint_null | 7.7
row19_bool_null | 7.7
row20_tinyint_null | 7.7
row21_smallint_null | 7.7
row22_date_null | 7.7
row23_varchar_null | 7.7
row24_char_null | 7.7
row25_binary_null | 7.7
(24 rows)
{code}
> Real/float4 rounding issues for HiveORC profile
> -----------------------------------------------
>
> Key: HAWQ-1054
> URL: https://issues.apache.org/jira/browse/HAWQ-1054
> Project: Apache HAWQ
> Issue Type: Bug
> Components: PXF
> Reporter: Oleksandr Diachenko
> Assignee: Goden Yao
> Priority: Critical
> Fix For: 2.0.1.0-incubating
>
>
> Looks like real values are being incorrectly rounded:
> {code}
> SELECT t1, r FROM pxf_hive_orc_types WHERE r = 7.7;
> t1 | r
> ----+---
> (0 rows)
> SELECT t1, r FROM pxf_hive_orc_types WHERE r > 7.6;
> t1 | r
> ----------------------+------
> row1 | 7.7
> row2 | 8.7
> row3 | 9.7
> row4 | 10.7
> row5 | 11.7
> row6 | 12.7
> row7 | 7.7
> row8 | 7.7
> row9 | 7.7
> row10 | 7.7
> row11 | 7.7
> row12_text_null | 7.7
> row13_int_null | 7.7
> row14_double_null | 7.7
> row15_decimal_null | 7.7
> row16_timestamp_null | 7.7
> row18_bigint_null | 7.7
> row19_bool_null | 7.7
> row20_tinyint_null | 7.7
> row21_smallint_null | 7.7
> row22_date_null | 7.7
> row23_varchar_null | 7.7
> row24_char_null | 7.7
> row25_binary_null | 7.7
> (24 rows)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
