[HIVE-21396] TestCliDriver#vector_groupby_reduce is flaky - rounding error

• Type: Test
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Vihang Karajgaonkar
• Reporter: László Bodor
• Created: 06/Mar/19 10:22
• Updated: 17/Nov/22 08:50
• Resolved: 01/Apr/19 18:04

Description

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:

1 85411 816 58.285714285714285 -5080.169999999999 -362.86928571428564 621.350000000000000000 44.382142857142857143

expected:

1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 621.350000000000000000 44.382142857142857143

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)

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

Issue Links

• relates to: HIVE-21535 Re-enable TestCliDriver#vector_groupby_reduce