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

Alexander Pivovarov commented on HIVE-10168:
--------------------------------------------

I compare two decimal numbers from failed test and find first decimal position 
where digits not matching
then I subtract 2 (for reliability) and this is the number of decimal places to 
round
For example:
{code}
142.92680950752379
142.9268095075238
    12345678901234
                ^ no match at position 13
              ^  no match - 2 is position 11 - this is I use for round
{code}

> make groupby3_map.q more stable
> -------------------------------
>
>                 Key: HIVE-10168
>                 URL: https://issues.apache.org/jira/browse/HIVE-10168
>             Project: Hive
>          Issue Type: Improvement
>          Components: Tests
>            Reporter: Alexander Pivovarov
>            Assignee: Alexander Pivovarov
>         Attachments: HIVE-10168.1.patch, HIVE-10168.2.patch
>
>
> The test run aggregation query which produces several DOUBLE numbers.
> Assertion framework compares output containing DOUBLE numbers without any 
> delta.
> As a result test is not stable
> e.g. build 3219 failed with the following test result
> {code}
> groupby3_map.q.out
> 139c139
> < 130091.0    260.182 256.10355987055016      98.0    0.0     
> 142.92680950752379      143.06995106518903      20428.07287599999       
> 20469.010897795582
> ---
> > 130091.0    260.182 256.10355987055016      98.0    0.0     
> > 142.9268095075238       143.06995106518906      20428.072876    
> > 20469.01089779559
> {code}
> http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3219/testReport/junit/org.apache.hadoop.hive.cli/TestCliDriver/testCliDriver_groupby3_map/



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to