Runtime Filtering

Runtime filtering improves query performance by dynamically applying dimension table filters to joined fact tables. Runtime filtering is disabled by default. To enable runtime filtering, a Dremio administrator must enable the planner.filter.runtime_filter support key.

Example
The following query joins multiple partitioned and non-partitioned columns:

  • Partitioned columns: ptcol1, ptcol2
  • Non-partitioned columns: regcol1, regcol2
select 
   t1.ptcol1, t1.ptcol2, 
   t1.regcol1, t1.regcol2, 
   t1.regcol3, 
   t1.othcol, t2.t2col 
from table1 t1 inner join table2 t2 on 
    (t1.ptcol1 = t2.ptcol1 and t1.ptcol2 = t2.ptcol2 and 
     t1.regcol1 = t2.regcol1 and t1.regcol2 = t2.regcol2)
where t1.regcol3 = "highly_selective_val";

results matching ""

    No results matching ""