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] [Commented] (HIVE-4668) wrong results for query with modulo (%) in WHERE clause filter
Date Thu, 06 Jun 2013 21:10:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13677513#comment-13677513
] 

Eric Hanson commented on HIVE-4668:
-----------------------------------

See also https://issues.apache.org/jira/browse/HIVE-4678. The problem might be with AND, not
%.
                
> wrong results for query with modulo (%) in WHERE clause filter
> --------------------------------------------------------------
>
>                 Key: HIVE-4668
>                 URL: https://issues.apache.org/jira/browse/HIVE-4668
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Processor
>    Affects Versions: vectorization-branch
>            Reporter: Eric Hanson
>            Assignee: Sarvesh Sakalanaga
>
> select disinternalmsft16431, count(disinternalmsft16431) from factsqlengineam_vec_orc
where ddate >= "2012-12" and ddate < "2013-02" and disinternalmsft16431 % 5 = 0 group
by disinternalmsft16431
> Expected result:
> 0       3160232
> 5       33039254
> Actual result:
> 0       8697033
> 6       2706407 
> 5       94709959
> There should be no result row for 6 because 6 % 5 != 0.

--
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