You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Remus Rusanu (JIRA)" <ji...@apache.org> on 2013/06/12 15:59:20 UTC
[jira] [Resolved] (HIVE-4687) incorrect result for max aggregate
over int column
[ https://issues.apache.org/jira/browse/HIVE-4687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Remus Rusanu resolved HIVE-4687.
--------------------------------
Resolution: Duplicate
Duplicate of HIVE-4686
> 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
> Assignee: Remus Rusanu
>
> 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