[IMPALA-7852] test_hash_join_timer flakiness on s3 testing build

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.2.0
• Fix Version/s: Impala 3.2.0
• Labels: broken-build flaky-test
• Epic Color: ghx-label-6
• Assignee: Michael Ho
• Reporter: Bikramjeet Vig
• Created: 14/Nov/18 21:49
• Updated: 26/Nov/18 18:34
• Resolved: 26/Nov/18 18:34

Description

test_hash_join_timer failed whereas it passed a previous s3 build on the same githash,i.e., no new commits added between them

Test cases failing with

query_test/test_hash_join_timer.py:143: in test_hash_join_timer
    strip1 = re.split("non-child: ", line)[1]
E   IndexError: list index out of range

Failing Queries:

select /*+straight_join*/ count(*) from (select distinct * from functional.alltypes where int_col >= sleep(5)) a join /* +SHUFFLE */ functional.alltypes b on (a.id=b.id);

select /*+straight_join*/ count(*) from functional.alltypes a join /* +SHUFFLE */  (select distinct * from functional.alltypes where int_col >= sleep(5)) b on (a.id=b.id);

select /*+straight_join*/ count(*) from functional.alltypes a CROSS join  (select distinct * from functional.alltypes where int_col >= sleep(5)) b where a.id>b.id and a.id=99;