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

Vihang Karajgaonkar reassigned HIVE-21396:
------------------------------------------

    Assignee: Vihang Karajgaonkar

> 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
>            Reporter: Laszlo Bodor
>            Assignee: Vihang Karajgaonkar
>            Priority: Major
>         Attachments: 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)

Reply via email to