[
https://issues.apache.org/jira/browse/CALCITE-6123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis resolved CALCITE-6123.
------------------------------------------
Fix Version/s: 1.37.0
Resolution: Fixed
Fixed in
https://github.com/zabetak/calcite-druid-dataset/commit/f763c73901085885b93c00c39ecba37b3e3bb31a.
Thanks everyone who helped troubleshoot this issue.
Hopefully, disabling the Druid query cache should be enough to stabilize the
Druid tests. If the test fails again in the CI then we can reopen the ticket.
> DruidAdapterIT#testInterleaveBetweenAggregateAndGroupOrderByOnMetrics fails
> ---------------------------------------------------------------------------
>
> Key: CALCITE-6123
> URL: https://issues.apache.org/jira/browse/CALCITE-6123
> Project: Calcite
> Issue Type: Bug
> Components: tests
> Affects Versions: 1.36.0
> Reporter: Benchao Li
> Assignee: Stamatis Zampetakis
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.37.0
>
> Attachments: image-2023-11-19-15-17-53-699.png
>
>
> The test that is failing is
> testInterleaveBetweenAggregateAndGroupOrderByOnMetrics and the error is shown
> below:
> {noformat}
> FAILURE 0.6sec, 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:2336)
> 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
> {noformat}
>
> The test is all failing after
> [https://github.com/apache/calcite/commit/55034513b463c938035e5d2436949bbf734b84b6],
> I'm not sure whether it's related.
> See following jobs:
> * [https://github.com/apache/calcite/actions/runs/6886169664/job/18731435605]
> * [https://github.com/apache/calcite/actions/runs/6885301555/job/18729238762]
> * [https://github.com/apache/calcite/actions/runs/6871630651/job/18688793776]
> * [https://github.com/apache/calcite/actions/runs/6860287671/job/18653876601]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
