[IMPALA-6565] Stress test with KRPC enabled shows inconsistent results for some queries

• Type: Sub-task
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 3.0, Impala 2.12.0
• Fix Version/s: Impala 3.0, Impala 2.12.0
• Component/s: Distributed Exec
• Labels: correctness
• Epic Color: ghx-label-1
• Assignee: Michael Ho
• Reporter: Michael Ho
• Created: 22/Feb/18 19:24
• Updated: 02/Mar/18 07:50
• Resolved: 02/Mar/18 07:50

Description

Stress test in an 8 node cluster running at commit 881e00a8bff0469ab7860bcd0d4d4794fb04a4b8 shows some queries producing wrong results.

 Result hash mismatch; expected 3440873535184108466, got 3440873535184106162
01:26:30                                  Query ID: c747bc20685116e8:fbac7a7100000000
01:26:30                                  Query: select
01:26:30   p_brand,
01:26:30   p_type,
01:26:30   p_size,
01:26:30   count(distinct ps_suppkey) as supplier_cnt
01:26:30 from
01:26:30   partsupp,
01:26:30   part
01:26:30 where
01:26:30   p_partkey = ps_partkey
01:26:30   and p_brand <> 'Brand#45'
01:26:30   and p_type not like 'MEDIUM POLISHED%'
01:26:30   and p_size in (49, 14, 23, 45, 19, 3, 36, 9)
01:26:30   and ps_suppkey not in (
01:26:30     select
01:26:30       s_suppkey
01:26:30     from
01:26:30       supplier
01:26:30     where
01:26:30       s_comment like '%Customer%Complaints%'
01:26:30   )
01:26:30 group by
01:26:30   p_brand,
01:26:30   p_type,
01:26:30   p_size
01:26:30 order by
01:26:30   supplier_cnt desc,
01:26:30   p_brand,
01:26:30   p_type,
01:26:30   p_size