Impala Public Jenkins has submitted this change and it was merged. ( http://gerrit.cloudera.org:8080/18261 )
Change subject: IMPALA-11135: Deflake LEFT ANTI JOIN test case in test_spilling.py ...................................................................... IMPALA-11135: Deflake LEFT ANTI JOIN test case in test_spilling.py TestSpillingDebugActionDimensions.test_spilling has been flaky because a test case from IMPALA-9725 sometimes does not spill its hash join partition. This patch lowers the buffer_pool_limit of this test from 110MB to 105MB, just slightly above its Max Per-Host Resource Reservation (104.61MB), to ensure consistent spilling behavior. Testing: After lowering the buffer pool limit, I loop the test 1000 times, and all spill consistently in fragment "HASH_JOIN_NODE (id=14)". To be specific, these are the num of SpilledPartitions of the first instance (ending with "000d") of "Hash Join Builder (join_node_id=14)" fragment across 1000 query runs: +--------------------+----------+ | #SpilledPartitions | #Queries | +--------------------+----------+ | 2 | 30 | | 3 | 96 | | 4 | 674 | | 5 | 52 | | 6 | 146 | | 7 | 2 | +--------------------+----------+ Change-Id: Idad9fc6ec6a0ba7fc70e0701e567da7165e40e83 Reviewed-on: http://gerrit.cloudera.org:8080/18261 Reviewed-by: Impala Public Jenkins <[email protected]> Tested-by: Impala Public Jenkins <[email protected]> --- M testdata/workloads/functional-query/queries/QueryTest/spilling.test 1 file changed, 3 insertions(+), 1 deletion(-) Approvals: Impala Public Jenkins: Looks good to me, approved; Verified -- To view, visit http://gerrit.cloudera.org:8080/18261 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: merged Gerrit-Change-Id: Idad9fc6ec6a0ba7fc70e0701e567da7165e40e83 Gerrit-Change-Number: 18261 Gerrit-PatchSet: 3 Gerrit-Owner: Riza Suminto <[email protected]> Gerrit-Reviewer: Fang-Yu Rao <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Quanlong Huang <[email protected]> Gerrit-Reviewer: Riza Suminto <[email protected]>
