Flaky Test: TestHiveHistoryBasedStatsTracking.testHistoryBasedStatsCalculatorMultipleStrategies

[imjalpreet]

Multiple occurrences of flakiness for TestHiveHistoryBasedStatsTracking.testHistoryBasedStatsCalculatorMultipleStrategies

Error:  Failures: 
Error:    TestHiveHistoryBasedStatsTracking.testHistoryBasedStatsCalculatorMultipleStrategies:207->AbstractTestQueryFramework.assertPlan:499->AbstractTestQueryFramework.assertPlan:507->AbstractTestQueryFramework.lambda$assertPlan$7:509 Plan does not match, expected [

- anyTree
    - node(ProjectNode)
        expectedOutputRowCount(48.0)
        - node

] but found [

- Output[PlanNodeId 6][orderkey, orderpriority, comment, custkey, ds, ts, _col6] => [orderkey:bigint, orderpriority:varchar(15), comment:varchar(79), custkey:bigint, ds:varchar(10), ts:varchar(5), expr_5:integer]
        Estimates: {source: HistoryBasedSourceInfo, rows: 48 (5.32kB), cpu: ?, memory: ?, network: ?}
        _col6 := expr_5 (1:11)
    - RemoteStreamingExchange[PlanNodeId 247][GATHER] => [orderkey:bigint, orderpriority:varchar(15), comment:varchar(79), custkey:bigint, ds:varchar(10), ts:varchar(5), expr_5:integer]
            Estimates: {source: CostBasedSourceInfo, rows: 50 (9.44kB), cpu: ?, memory: ?, network: ?}
        - ScanProject[PlanNodeId 0,168][table = TableHandle {connectorId='hive', connectorHandle='HiveTableHandle{schemaName=tpch, tableName=test_orders, analyzePartitionValues=Optional.empty}', layout='Optional[tpch.test_orders{domains={orderpriority=[ [["1-URGENT"]] ]}}]'}, projectLocality = LOCAL] => [orderkey:bigint, orderpriority:varchar(15), comment:varchar(79), custkey:bigint, ds:varchar(10), ts:varchar(5), expr_5:integer]
                Estimates: {source: CostBasedSourceInfo, rows: 50 (9.44kB), cpu: ?, memory: ?, network: ?}/{source: CostBasedSourceInfo, rows: 50 (9.44kB), cpu: ?, memory: ?, network: ?}
                orderpriority := VARCHAR'1-URGENT'
                ds := VARCHAR'2020-09-02'
                expr_5 := INTEGER'2'
                LAYOUT: tpch.test_orders{domains={orderpriority=[ [["1-URGENT"]] ]}}
                orderkey := orderkey:bigint:0:REGULAR (1:18)
                ts := ts:varchar(5):-14:PARTITION_KEY (1:18)
                    :: [["00:02"]]
                comment := comment:varchar(79):2:REGULAR (1:18)
                custkey := custkey:bigint:3:REGULAR (1:18)
                orderpriority:varchar(15):1:REGULAR
                    :: [["1-URGENT"]]
                ds:varchar(10):-13:PARTITION_KEY
                    :: [["2020-09-02"]]

]

https://github.com/prestodb/presto/actions/runs/10841018995/job/30084375559?pr=23643#step:7:12392 https://github.com/prestodb/presto/actions/runs/10839638100/job/30080421012#step:7:12426

[hantangwangd]

+1

See: https://github.com/prestodb/presto/actions/runs/11350506950/job/31569387143?pr=23837