-
Type:
Sub-task
-
Status: Resolved
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: vectorization-branch
-
Fix Version/s: None
-
Component/s: Query Processor
-
Labels:None
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.
- duplicates
-
HIVE-4686 Max on float returning wrong results
-
- Resolved
-