[HIVE-9385] Sum a Double using an ORC table

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.13.1

Environment

HDP 2.x, Hive

• Assignee: Unassigned
• Reporter: Nick Martin
• Created: 15/Jan/15 02:40
• Updated: 20/Sep/17 10:26

Description

I’m storing a sales amount column as a double in an ORC table and when I do:

select sum(x) from sometable

I get a value like 4.79165141174808E9

A visual inspection of the column values reveals no glaring anomalies…all looks pretty normal.

If I do the same thing in a textfile table I get a perfectly fine aggregation of the double field.

Issue Links

• is duplicated by: HIVE-9384 Sum a Double using an ORC table