[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807958#comment-16807958 ] Vihang Karajgaonkar commented on HIVE-21396: Thats right. I had linked it in this JIRA but failed to mention it in the comment. Thanks [~kgyrtkirk] for clarifying. > TestCliDriver#vector_groupby_reduce is flaky - rounding error > - > > Key: HIVE-21396 > URL: https://issues.apache.org/jira/browse/HIVE-21396 > Project: Hive > Issue Type: Test >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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807534#comment-16807534 ] Zoltan Haindrich commented on HIVE-21396: - I think it's HIVE-21535 > TestCliDriver#vector_groupby_reduce is flaky - rounding error > - > > Key: HIVE-21396 > URL: https://issues.apache.org/jira/browse/HIVE-21396 > Project: Hive > Issue Type: Test >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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807436#comment-16807436 ] Laszlo Bodor commented on HIVE-21396: - thanks [~vihangk1]! you wrote: "Created a separate JIRA to track re-enabling the test" which Jira is for enabling this test? > TestCliDriver#vector_groupby_reduce is flaky - rounding error > - > > Key: HIVE-21396 > URL: https://issues.apache.org/jira/browse/HIVE-21396 > Project: Hive > Issue Type: Test >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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807041#comment-16807041 ] Vihang Karajgaonkar commented on HIVE-21396: Thanks [~abstractdog] for rettaching the patch and seeing it through our precommit Gods :) I don't see this test being run here https://builds.apache.org/job/PreCommit-HIVE-Build/16775/testReport/org.apache.hadoop.hive.cli/TestCliDriver/ so looks like the test was successfully skipped. Patch merged into master > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805817#comment-16805817 ] Laszlo Bodor commented on HIVE-21396: - green run (previous TestObjectStore failures are tracked at HIVE-21553) > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805805#comment-16805805 ] Hive QA commented on HIVE-21396: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12964312/HIVE-21396.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15882 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16775/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16775/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16775/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12964312 - PreCommit-HIVE-Build > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805783#comment-16805783 ] Hive QA commented on HIVE-21396: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 50s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 32s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 49s{color} | {color:blue} itests/util in master has 46 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 21s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 59s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 20s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 14m 6s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-16775/dev-support/hive-personality.sh | | git revision | master / 2ce775b | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: itests/util U: itests/util | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-16775/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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 >
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805775#comment-16805775 ] Hive QA commented on HIVE-21396: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12964297/HIVE-21396.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 16 failed/errored test(s), 15852 tests executed *Failed tests:* {noformat} TestMiniLlapLocalCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=163) [bucket3.q,colstats_date_min_max.q,materialized_view_create_rewrite_4.q,schema_evol_text_nonvec_table.q,subquery_multi.q,external_jdbc_auth.q,check_constraint.q,cbo_simple_select.q,cbo_rp_udf_udaf_stats_opt.q,vector_parquet_nested_two_level_complex.q,multi_column_in.q,vector_interval_1.q,groupby1.q,partition_shared_scan.q,vector_map_order.q,cbo_rp_udf_udaf.q,vector_decimal_aggregate.q,vector_groupby_grouping_sets3.q,leftsemijoin_mr.q,results_cache_transactional.q,constant_prop_when.q,update_all_types.q,materialized_view_rewrite_part_1.q,vector_llap_text_1.q,ptf.q,update_where_non_partitioned.q,vectorized_nested_mapjoin.q,schema_evol_text_nonvec_part.q,enforce_constraint_notnull.q,vector_windowing_range_multiorder.q] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_2] (batchId=86) org.apache.hadoop.hive.metastore.TestObjectStore.catalogs (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDatabaseOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDeprecatedConfigIsOverwritten (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSQLDropParitionsCleanup (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSQLDropPartitionsCacheCrossSession (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSqlErrorMetrics (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testEmptyTrustStoreProps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testMasterKeyOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testMaxEventResponse (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testPartitionOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testQueryCloseOnError (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testRoleOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testTableOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testUseSSLProperty (batchId=230) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16774/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16774/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16774/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 16 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12964297 - PreCommit-HIVE-Build > 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 > Attachments: 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805752#comment-16805752 ] Hive QA commented on HIVE-21396: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 54s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 33s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 13s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 52s{color} | {color:blue} itests/util in master has 46 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 20s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 31s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 31s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 20s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 14m 15s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-16774/dev-support/hive-personality.sh | | git revision | master / 2ce775b | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: itests/util U: itests/util | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-16774/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 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 > Attachments: 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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),
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805722#comment-16805722 ] Laszlo Bodor commented on HIVE-21396: - preCommit queue is empty, uploaded the patch again... > 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 > Attachments: 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805267#comment-16805267 ] Vihang Karajgaonkar commented on HIVE-21396: don't think my patch has anything do with the test failures since it doesn't even involve any code changes. > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804614#comment-16804614 ] Hive QA commented on HIVE-21396: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12964065/HIVE-21396.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 22 failed/errored test(s), 15874 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[acid_no_buckets] (batchId=178) org.apache.hadoop.hive.metastore.TestObjectStore.catalogs (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDatabaseOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDeprecatedConfigIsOverwritten (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSQLDropParitionsCleanup (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSQLDropPartitionsCacheCrossSession (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testDirectSqlErrorMetrics (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testEmptyTrustStoreProps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testMasterKeyOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testMaxEventResponse (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testPartitionOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testQueryCloseOnError (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testRoleOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testTableOps (batchId=230) org.apache.hadoop.hive.metastore.TestObjectStore.testUseSSLProperty (batchId=230) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitions (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitionsUnionAll (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomNonExistent (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighBytesRead (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighShuffleBytes (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryElapsedTime (batchId=263) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryExecutionTime (batchId=263) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16744/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16744/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16744/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 22 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12964065 - PreCommit-HIVE-Build > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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), >
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804595#comment-16804595 ] Hive QA commented on HIVE-21396: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 56s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 32s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 49s{color} | {color:blue} itests/util in master has 48 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 23s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 0m 59s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 23s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 14s{color} | {color:red} The patch generated 7 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 14m 13s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-16744/dev-support/hive-personality.sh | | git revision | master / 559efea | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-16744/yetus/patch-asflicense-problems.txt | | modules | C: itests/util U: itests/util | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-16744/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804160#comment-16804160 ] Vihang Karajgaonkar commented on HIVE-21396: Created a separate JIRA to track re-enabling the test. > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804159#comment-16804159 ] Vihang Karajgaonkar commented on HIVE-21396: patch disables the test for TestCliDriver. [~jcamachorodriguez] Can you please review? > 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 > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)
[jira] [Commented] (HIVE-21396) TestCliDriver#vector_groupby_reduce is flaky - rounding error
[ https://issues.apache.org/jira/browse/HIVE-21396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804152#comment-16804152 ] Vihang Karajgaonkar commented on HIVE-21396: Hit this failure in HIVE-21484. I think we should disable this test until it is fixed. > 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 >Priority: Major > > 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.1699 > actual: > {code:java} > 1 85411 816 58.285714285714285 -5080.1699 -362.86928571428564 > 621.35 44.382142857142857143 > {code} > expected: > {code:java} > 1 85411 816 58.285714285714285 -5080.17 -362.8692857142857 > 621.35 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)