[HAWQ-1054] Real/float4 rounding issues for HiveORC profile

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Won't Fix
• Fix Version/s: 2.1.0.0-incubating
• Component/s: PXF
• Assignee: Oleksandr Diachenko
• Reporter: Oleksandr Diachenko
• Created: 15/Sep/16 00:30
• Updated: 18/Feb/17 05:26
• Resolved: 27/Sep/16 19:27

Description

Looks like real values are being incorrectly rounded:

 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)

The same query works fine in Hive:

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)