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