JiajunBernoulli commented on PR #3518: URL: https://github.com/apache/calcite/pull/3518#issuecomment-1807511375
Oops! Druid Tests Failed again. 1. https://github.com/apache/calcite/actions/runs/6840930774/job/18600708940 2. https://github.com/apache/calcite/actions/runs/6845913981/job/18611830618?pr=3518 ``` org.apache.calcite.test.DruidAdapter2IT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() failure marker FAILURE 0.2sec, org.apache.calcite.test.DruidAdapter2IT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:453) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:582) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1495) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1434) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1493) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1483) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1509) at org.apache.calcite.test.DruidAdapter2IT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapter2IT.java:2025) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:389) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more FAILURE 28.0sec, 210 completed, 1 failed, 6 skipped, org.apache.calcite.test.DruidAdapter2IT org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() failure marker FAILURE 0.2sec, org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:453) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:582) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1495) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1434) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1493) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1483) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1509) at org.apache.calcite.test.DruidAdapterIT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapterIT.java:2[336](https://github.com/apache/calcite/actions/runs/6845913981/job/18611830618?pr=3518#step:8:343)) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:389) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more 3.4sec, org.apache.calcite.test.DruidAdapterIT > testFilterClauseWithNoConjunction() 2.6sec, org.apache.calcite.test.DruidAdapterIT > testSelectTimestampColumnNoTables4() FAILURE 37.3sec, 235 completed, 1 failed, 6 skipped, org.apache.calcite.test.DruidAdapterIT FAILURE 38.2sec, 453 completed, 2 failed, 12 skipped, Gradle Test Run :druid:test ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
