hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vihang Karajgaonkar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
Date Mon, 01 Apr 2019 18:05:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vihang Karajgaonkar updated HIVE-21396:
---------------------------------------
       Resolution: Fixed
    Fix Version/s: 4.0.0
           Status: Resolved  (was: Patch Available)

> TestCliDriver#vector_groupby_reduce is flaky - rounding error
> -------------------------------------------------------------
>
>                 Key: HIVE-21396
>                 URL: https://issues.apache.org/jira/browse/HIVE-21396
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 4.0.0
>            Reporter: Laszlo Bodor
>            Assignee: Vihang Karajgaonkar
>            Priority: Major
>             Fix For: 4.0.0
>
>         Attachments: HIVE-21396.01.patch, HIVE-21396.01.patch, HIVE-21396.01.patch
>
>
> http://104.198.109.242/logs/PreCommit-HIVE-Build-16349/failed/61-TestCliDriver-multi_insert_partitioned.q-parquet_types.q-udf_to_unix_timestamp.q-and-27-more/TEST-61-TestCliDriver-multi_insert_partitioned.q-parquet_types.q-udf_to_unix_timestamp.q-and-27-more-TEST-org.apache.hadoop.hive.cli.TestCliDriver.xml
> http://104.198.109.242/logs/PreCommit-HIVE-Build-16351/failed/61-TestCliDriver-multi_insert_partitioned.q-parquet_types.q-udf_to_unix_timestamp.q-and-27-more/TEST-61-TestCliDriver-multi_insert_partitioned.q-parquet_types.q-udf_to_unix_timestamp.q-and-27-more-TEST-org.apache.hadoop.hive.cli.TestCliDriver.xml
> -5080.17 --> -5080.169999999999
> actual:
> {code:java}
> 1 85411 816 58.285714285714285 -5080.169999999999 -362.86928571428564 621.350000000000000000
44.382142857142857143
> {code}
> expected:
> {code:java}
> 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 621.350000000000000000 44.382142857142857143
> {code}
> https://github.com/apache/hive/blob/268a6e5af11e0fdc3887d570c1680035fd9426c3/ql/src/test/results/clientpositive/vector_groupby_reduce.q.out
> it's a result of sum (max(ss_net_profit) np)
> {code}
> select
>     ss_ticket_number, sum(ss_item_sk), sum(q), avg(q), sum(np), avg(np), sum(decwc),
avg(decwc)
> from
>     (select
>         ss_ticket_number, ss_item_sk, min(ss_quantity) q, max(ss_net_profit) np, max(ss_wholesale_cost_decimal)
decwc
>     from
>         store_sales_n3
>     where ss_ticket_number = 1
>     group by ss_ticket_number, ss_item_sk) a
> group by ss_ticket_number
> order by ss_ticket_number
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message