[CALCITE-6093] Unstable unit test in Druid tests

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.37.0
• Component/s: druid-adapter
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jiajun Xie
• Created: 04/Nov/23 06:24
• Updated: 22/Apr/24 14:29
• Resolved: 06/Dec/23 12:59

Description

FAILURE 38.6sec, 235 completed, 1 failed, 6 skipped, org.apache.calcite.test.DruidAdapterIT

FAILURE   0.2sec, org.apache.calcite.test.DruidAdapter2IT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics()
285    java.lang.AssertionError: 
286    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"
287         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" 

FAILURE 39.6sec, 453 completed, 2 failed, 12 skipped, Gradle Test Run :druid:test

FAILURE 28.7sec, 210 completed, 1 failed, 6 skipped, org.apache.calcite.test.DruidAdapter2IT 308org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() failure marker 331FAILURE 0.3sec, org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() 332 java.lang.AssertionError: 333 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" 334 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"

Error stack in https://github.com/apache/calcite/actions/runs/6753112859/job/18359231130?pr=3501

Issue Links

• is caused by: CALCITE-5433 Druid tests hang/fail intermittently in CI
• is duplicated by: CALCITE-6123 DruidAdapterIT#testInterleaveBetweenAggregateAndGroupOrderByOnMetrics fails
• links to: GitHub Pull Request #3559
• links to: GitHub Pull Request #3560
• links to: GitHub Pull Request #3561