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

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

select
  count(*)
from
  lineitem l1
where
  l1.l_discount IN (
    select
      distinct(cast(l2.l_discount as double))
    from
      lineitem l2);

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