framework/resources/Advanced/runtimefilter/tpch_sf100/parquet/nested_broadcast.sql.fail

-- Enable when DRILL-6792 is fixed
set `exec.hashjoin.enable.runtime_filter` = true;
set `exec.hashjoin.runtime_filter.max.waiting.time` = 10000;
set `planner.enable_broadcast_join` = true;
set `planner.broadcast_threshold` = 2147483647;

select
  p.p_mfgr,
  p.p_type,
  count(*) as num_parts
from
  supplier s,
  part p,
  partsupp ps,
  nation n
where
  n.n_nationkey = 15
  and n.n_nationkey = s.s_nationkey
  and s.s_suppkey = ps.ps_suppkey
  and ps.ps_partkey = p.p_partkey
  and p.p_type like '%STEEL%'
group by
  p.p_mfgr,
  p.p_type
order by
  p.p_mfgr,
  p.p_type;

reset `exec.hashjoin.enable.runtime_filter`;
reset `exec.hashjoin.runtime_filter.max.waiting.time`;
reset `planner.enable_broadcast_join`;
reset `planner.broadcast_threshold`;