hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Hanson (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4687) incorrect result for max aggregate over int column
Date Fri, 07 Jun 2013 21:10:21 GMT
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

Mime
View raw message