Skip to content

Apache DataFusion SQL Query Engine

2.3 KB
Raw Blame
-- `ints.sql` widened to 64 integer columns, each uniform on [0,100), so `cN < k`
-- again has selectivity ~k%. c0..c15 reuse the same multipliers, so a predicate
-- over them has exactly the same selectivities as on `ints` and only the width of
-- the batches flowing through the filter changes. PRED_ROWS sizes the table.
CREATE TABLE t AS
SELECT
  (value * 1)   % 100 AS c0,
  (value * 3)   % 100 AS c1,
  (value * 7)   % 100 AS c2,
  (value * 9)   % 100 AS c3,
  (value * 11)  % 100 AS c4,
  (value * 13)  % 100 AS c5,
  (value * 17)  % 100 AS c6,
  (value * 19)  % 100 AS c7,
  (value * 21)  % 100 AS c8,
  (value * 23)  % 100 AS c9,
  (value * 27)  % 100 AS c10,
  (value * 29)  % 100 AS c11,
  (value * 31)  % 100 AS c12,
  (value * 33)  % 100 AS c13,
  (value * 37)  % 100 AS c14,
  (value * 39)  % 100 AS c15,
  (value * 41)  % 100 AS c16,
  (value * 43)  % 100 AS c17,
  (value * 47)  % 100 AS c18,
  (value * 49)  % 100 AS c19,
  (value * 51)  % 100 AS c20,
  (value * 53)  % 100 AS c21,
  (value * 57)  % 100 AS c22,
  (value * 59)  % 100 AS c23,
  (value * 61)  % 100 AS c24,
  (value * 63)  % 100 AS c25,
  (value * 67)  % 100 AS c26,
  (value * 69)  % 100 AS c27,
  (value * 71)  % 100 AS c28,
  (value * 73)  % 100 AS c29,
  (value * 77)  % 100 AS c30,
  (value * 79)  % 100 AS c31,
  (value * 81)  % 100 AS c32,
  (value * 83)  % 100 AS c33,
  (value * 87)  % 100 AS c34,
  (value * 89)  % 100 AS c35,
  (value * 91)  % 100 AS c36,
  (value * 93)  % 100 AS c37,
  (value * 97)  % 100 AS c38,
  (value * 99)  % 100 AS c39,
  (value * 101) % 100 AS c40,
  (value * 103) % 100 AS c41,
  (value * 107) % 100 AS c42,
  (value * 109) % 100 AS c43,
  (value * 111) % 100 AS c44,
  (value * 113) % 100 AS c45,
  (value * 117) % 100 AS c46,
  (value * 119) % 100 AS c47,
  (value * 121) % 100 AS c48,
  (value * 123) % 100 AS c49,
  (value * 127) % 100 AS c50,
  (value * 129) % 100 AS c51,
  (value * 131) % 100 AS c52,
  (value * 133) % 100 AS c53,
  (value * 137) % 100 AS c54,
  (value * 139) % 100 AS c55,
  (value * 141) % 100 AS c56,
  (value * 143) % 100 AS c57,
  (value * 147) % 100 AS c58,
  (value * 149) % 100 AS c59,
  (value * 151) % 100 AS c60,
  (value * 153) % 100 AS c61,
  (value * 157) % 100 AS c62,
  (value * 159) % 100 AS c63
FROM generate_series(1, ${PRED_ROWS:-1000000});