[IMPALA-6535] test_profile_fragment_instances failure: incomplete query profile

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 3.0
• Labels: broken-build
• Epic Color: ghx-label-7
• Assignee: Thomas Tauber-Marshall
• Reporter: Bikramjeet Vig
• Created: 17/Feb/18 01:45
• Updated: 20/Feb/18 21:27
• Resolved: 20/Feb/18 21:27

Description

test_profile_fragment_instances fails due to an incomplete query profile on one of the isilon builds

query_test/test_observability.py:129: in test_profile_fragment_instances
    assert results.runtime_profile.count("HDFS_SCAN_NODE") == 12
E   assert 11 == 12
E    +  where 11 = <built-in method count of str object at 0x62dd8a0>('HDFS_SCAN_NODE')
E    +    where <built-in method count of str object at 0x62dd8a0> = 'Query (id=df40a93c53cd3ffb:fe3c401a00000000):\n  DEBUG MODE WARNING: Query profile created while running a DEBUG buil... - OptimizationTime: 146.996ms\n           - PeakMemoryUsage: 279.50 KB (286208)\n           - PrepareTime: 26.999ms\n'.count
E    +      where 'Query (id=df40a93c53cd3ffb:fe3c401a00000000):\n  DEBUG MODE WARNING: Query profile created while running a DEBUG buil... - OptimizationTime: 146.996ms\n           - PeakMemoryUsage: 279.50 KB (286208)\n           - PrepareTime: 26.999ms\n' = <tests.beeswax.impala_beeswax.ImpalaBeeswaxResult object at 0x6211350>.runtime_profile

Query:

with l as (select * from tpch.lineitem UNION ALL select * from tpch.lineitem)
        select STRAIGHT_JOIN count(*) from (select * from tpch.lineitem a LIMIT 1) a
        join (select * from l LIMIT 2000000) b on a.l_orderkey = -b.l_orderkey;

Issue Links

• duplicates: IMPALA-6338 Tests fail due to runtime profile for query with limit missing pieces