[HIVE-4687] incorrect result for max aggregate over int column

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: vectorization-branch
• Component/s: Query Processor
• Assignee: Remus Rusanu
• Reporter: Eric N. Hanson
• Created: 07/Jun/13 21:09
• Updated: 12/Jun/13 13:57
• Resolved: 12/Jun/13 13:57

Description

select max(dnumbertables23008) from factsqlengineam_vec_orc where ddate = "2013-01-08 00:00:00";

result: 241012

select max(dnumbertables23008) from factsqlengineam_orc where ddate = "2013-01-08 00:00:00";

result: 1052436

Result is also 1052436 for text version of table.

Also, for this query:

select ddate, max(dnumbertables23008) from factsqlengineam_vec_orc group by ddate;

the MAX result is correct for all ddate values (about 365 of them) except for ddate = "2013-01-08 00:00:00", when compared with the result for text.

Let me know if you need help to set up this repro.

Issue Links

• duplicates: HIVE-4686 Max on float returning wrong results