Eric Hanson created HIVE-4687:
---------------------------------
Summary: incorrect result for max aggregate over int column
Key: HIVE-4687
URL: https://issues.apache.org/jira/browse/HIVE-4687
Project: Hive
Issue Type: Sub-task
Components: Query Processor
Affects Versions: vectorization-branch
Reporter: Eric Hanson
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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
