[
https://issues.apache.org/jira/browse/IMPALA-9019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16954274#comment-16954274
]
Tim Armstrong commented on IMPALA-9019:
---------------------------------------
{noformat}
use tpch30_parquet; set mt_dop=4; set runtime_filter_wait_time_ms=10000; select
*
from (
select
ps_partkey,
sum(ps_supplycost * ps_availqty) as value
from
partsupp,
supplier,
nation
where
ps_suppkey = s_suppkey
and s_nationkey = n_nationkey
and n_name = 'GERMANY'
group by
ps_partkey
) as inner_query
where
value > (
select
sum(ps_supplycost * ps_availqty) * 0.0001
from
partsupp,
supplier,
nation
where
ps_suppkey = s_suppkey
and s_nationkey = n_nationkey
and n_name = 'GERMANY'
)
order by
value desc; summary;
{noformat}
> Fix runtime filter bugs with mt_dop
> -----------------------------------
>
> Key: IMPALA-9019
> URL: https://issues.apache.org/jira/browse/IMPALA-9019
> Project: IMPALA
> Issue Type: Sub-task
> Components: Distributed Exec
> Reporter: Tim Armstrong
> Assignee: Tim Armstrong
> Priority: Major
>
> It looks like runtime filters do not get delivered properly. E.g. if I run
> TPC-H Q 9 with mt_dop=4 and runtime_filter_wait_time_ms=999999, the query
> appears to get stuck.
> This causes TPC-H performance to be significantly worse for some queries.
> Strangely, I can only reproduce this on TPC-H scale factor 3, not the smaller
> scale factor.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
