hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Hanson (JIRA)" <>
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
             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:

View raw message