Michael Ho created IMPALA-6565:
----------------------------------
Summary: Stress test with KRPC enabled shows inconsistent results
for some queries
Key: IMPALA-6565
URL: https://issues.apache.org/jira/browse/IMPALA-6565
Project: IMPALA
Issue Type: Bug
Components: Distributed Exec
Affects Versions: Impala 3.0, Impala 2.12.0
Reporter: Michael Ho
Assignee: Michael Ho
Stress test in an 8 node cluster running at commit
881e00a8bff0469ab7860bcd0d4d4794fb04a4b8 shows some queries producing wrong
results.
{noformat}
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
{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
