Fang-Yu Rao has uploaded a new patch set (#2). ( 
http://gerrit.cloudera.org:8080/17103 )

Change subject: [Do not merge] This patch reproduces the issue in IMPALA-9767
......................................................................

[Do not merge] This patch reproduces the issue in IMPALA-9767

Thanks to Joe's and Riza's analysis, I am able to reproduce the issue
reported in IMPALA-9767.

To reproduce the issue, it suffices to execute the following steps.
1. ${IMPALA_HOME}/buildall.sh -notests -ninja -asan
2. ${IMPALA_HOME}/bin/start-impala-cluster.py 
--impalad_args="--debug_actions=PUBLISH_FILTER_DELAY:SLEEP@1000"
3. ${IMPALA_HOME}/bin/impala-shell.sh -d tpcds_parquet -f ~/tpcds-q1.sql -Q 
RUNTIME_FILTER_WAIT_TIME_MS=30000 -Q RUNTIME_FILTER_MAX_SIZE=32MB -Q 
RUNTIME_FILTER_MIN_SIZE=32MB

The TPC-DS Q1 (in the file tpcds-q1.sql above) is provided in the
following for easy reference.

with customer_total_return as
(select sr_customer_sk as ctr_customer_sk,
        sr_store_sk as ctr_store_sk,
        sum(SR_RETURN_AMT) as ctr_total_return
 from store_returns,
       date_dim
 where sr_returned_date_sk = d_date_sk
       and d_year = 2000
 group by sr_customer_sk,
          sr_store_sk)
select c_customer_id
from customer_total_return ctr1,
     store,
     customer
where ctr1.ctr_total_return >
      (select avg(ctr_total_return)*1.2
       from customer_total_return ctr2
       where ctr1.ctr_store_sk = ctr2.ctr_store_sk)
      and s_store_sk = ctr1.ctr_store_sk
      and s_state = 'TN'
      and ctr1.ctr_customer_sk = c_customer_sk
order by c_customer_id
limit 100;

Change-Id: I1753503a7e604a2e5752825650baa4f69cc8975b
---
M be/src/runtime/coordinator.cc
1 file changed, 23 insertions(+), 8 deletions(-)


  git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/03/17103/2
--
To view, visit http://gerrit.cloudera.org:8080/17103
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: newpatchset
Gerrit-Change-Id: I1753503a7e604a2e5752825650baa4f69cc8975b
Gerrit-Change-Number: 17103
Gerrit-PatchSet: 2
Gerrit-Owner: Fang-Yu Rao <[email protected]>
Gerrit-Reviewer: Impala Public Jenkins <[email protected]>

Reply via email to