[
https://issues.apache.org/jira/browse/HAWQ-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko reassigned HAWQ-1054:
-----------------------------------------
Assignee: Oleksandr Diachenko (was: Goden Yao)
> 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: Oleksandr Diachenko
> 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}
> The same query works fine in Hive:
> {code}
> hive> select f from hive_orc_all_types where f = 7.7;
> OK
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> 7.7
> Time taken: 0.032 seconds, Fetched: 19 row(s)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
