alamb commented on PR #18183:
URL: https://github.com/apache/datafusion/pull/18183#issuecomment-3466608608
🤖: Benchmark completed
<details><summary>Details</summary>
<p>
```
group
improve-performance-for-literal-mapping main
-----
--------------------------------------- ----
case_when 8192x100: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN
c1 < n * 1000 THEN n ELSE n + 1 END 1.08 2.9±0.07ms
? ?/sec 1.00 2.7±0.02ms ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.00 55.7±0.19µs
? ?/sec 1.00 55.7±0.11µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.00 382.4±9.21µs
? ?/sec 1.00 383.2±6.68µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.04µs
? ?/sec 1.00 6.8±0.02µs ? ?/sec
case_when 8192x100: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 1.01 1695.1±23.68ms
? ?/sec 1.00 1673.9±11.70ms ? ?/sec
case_when 8192x100: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 1.00 67.4±0.27µs
? ?/sec 25077.50 1690.0±11.51ms ? ?/sec
case_when 8192x100: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.06 410.6±9.11µs
? ?/sec 1.00 386.7±11.10µs ? ?/sec
case_when 8192x100: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 1.00 61.9±0.18µs
? ?/sec 44.01 2.7±0.02ms ? ?/sec
case_when 8192x3: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END 1.00 205.5±2.52µs
? ?/sec 1.00 205.6±2.94µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.00 54.9±0.22µs
? ?/sec 1.00 55.1±0.14µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.02 23.2±0.31µs
? ?/sec 1.00 22.9±0.36µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.03 6.9±0.01µs
? ?/sec 1.00 6.7±0.02µs ? ?/sec
case_when 8192x3: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 1.01 69.1±0.23ms
? ?/sec 1.00 68.4±0.21ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n ELSE
n + 1 END 1.00 68.3±0.41µs
? ?/sec 1068.18 73.0±0.28ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.00 29.7±0.35µs
? ?/sec 1.00 29.7±0.40µs ? ?/sec
case_when 8192x3: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 1.00 61.8±0.23µs
? ?/sec 3.04 187.9±2.18µs ? ?/sec
case_when 8192x50: CASE WHEN c1 < 0 THEN 0 WHEN c1 < 1000 THEN 1 ... WHEN c1
< n * 1000 THEN n ELSE n + 1 END 1.00 1392.4±27.94µs
? ?/sec 1.00 1385.8±15.45µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.01 55.7±0.45µs
? ?/sec 1.00 55.1±0.11µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.00 170.6±1.57µs
? ?/sec 1.07 182.9±5.60µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.02µs
? ?/sec 1.00 6.8±0.02µs ? ?/sec
case_when 8192x50: CASE WHEN c1 == 0 THEN 0 WHEN c1 == 1 THEN 1 ... WHEN c1
== n THEN n ELSE n + 1 END 1.01 761.9±5.11ms
? ?/sec 1.00 756.0±4.59ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 1.00 67.8±0.71µs
? ?/sec 11290.07 765.1±4.59ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.06 190.2±7.19µs
? ?/sec 1.00 179.2±2.04µs ? ?/sec
case_when 8192x50: CASE c2 WHEN 0 THEN 0 WHEN 1000 THEN 1 ... WHEN n * 1000
THEN n ELSE n + 1 END 1.00 61.4±1.20µs
? ?/sec 22.45 1377.4±8.81µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
142.6±0.40µs ? ?/sec 3.33 474.3±1.60µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
156.4±2.07µs ? ?/sec 3.40 531.9±1.68µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
153.8±0.73µs ? ?/sec 2.64 406.5±2.18µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
142.6±0.30µs ? ?/sec 3.30 471.2±1.63µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
155.7±0.71µs ? ?/sec 3.41 530.8±1.88µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
153.6±0.53µs ? ?/sec 2.66 409.3±1.71µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
142.6±0.39µs ? ?/sec 3.34 475.6±1.65µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
155.3±0.44µs ? ?/sec 3.42 531.2±2.27µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
143.2±0.62µs ? ?/sec 3.31 474.2±2.41µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 136.5±2.10µs
? ?/sec 1.44 196.5±2.19µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 142.7±1.72µs
? ?/sec 1.94 276.2±0.84µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 139.3±0.80µs
? ?/sec 1.88 262.3±0.84µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 140.0±1.25µs
? ?/sec 1.40 196.0±0.55µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 143.2±1.84µs
? ?/sec 1.93 276.3±1.35µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 139.4±0.71µs
? ?/sec 1.88 261.7±0.77µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 134.7±2.18µs
? ?/sec 1.46 196.2±0.40µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 143.4±2.32µs
? ?/sec 1.93 276.5±1.34µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 135.4±2.24µs
? ?/sec 1.45 196.1±0.38µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
142.9±0.75µs ? ?/sec 4.51 644.4±1.64µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
154.8±0.49µs ? ?/sec 4.45 688.3±2.36µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
164.1±0.68µs ? ?/sec 3.12 512.8±2.35µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
142.6±0.44µs ? ?/sec 4.50 641.3±2.94µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
155.0±1.03µs ? ?/sec 4.44 688.5±2.00µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
164.5±0.71µs ? ?/sec 3.12 513.3±5.82µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
142.6±0.78µs ? ?/sec 4.52 644.8±1.51µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
154.6±0.36µs ? ?/sec 4.45 687.3±2.24µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
143.2±0.63µs ? ?/sec 4.51 645.3±2.08µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 134.4±1.06µs
? ?/sec 1.46 196.3±0.86µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 143.1±0.99µs
? ?/sec 1.93 276.8±1.01µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 139.1±0.29µs
? ?/sec 1.89 262.3±0.66µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 134.6±1.03µs
? ?/sec 1.46 196.3±0.66µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 142.9±1.10µs
? ?/sec 1.93 276.5±3.12µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 139.2±0.32µs
? ?/sec 1.89 263.6±3.05µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 134.3±0.90µs
? ?/sec 1.46 196.2±0.30µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 142.5±0.99µs
? ?/sec 1.93 275.1±0.71µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 135.2±2.11µs
? ?/sec 1.45 196.1±0.42µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
143.0±0.41µs ? ?/sec 2.37 339.3±1.06µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
153.2±1.37µs ? ?/sec 2.62 401.4±2.00µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
147.5±0.84µs ? ?/sec 2.21 325.8±1.05µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
143.1±0.81µs ? ?/sec 2.37 338.7±1.53µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
152.8±0.61µs ? ?/sec 2.62 400.4±1.36µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
147.2±1.05µs ? ?/sec 2.22 327.4±1.68µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
143.0±0.86µs ? ?/sec 2.37 338.3±2.06µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
152.7±0.76µs ? ?/sec 2.63 402.0±2.26µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
143.8±2.66µs ? ?/sec 2.36 339.4±1.22µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 135.2±1.50µs
? ?/sec 1.45 196.5±0.66µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 144.4±2.58µs
? ?/sec 1.91 276.2±0.95µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 139.3±0.49µs
? ?/sec 1.89 262.6±1.84µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 134.9±1.47µs
? ?/sec 1.45 196.0±0.92µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 142.6±1.09µs
? ?/sec 1.94 276.2±1.19µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 139.4±0.31µs
? ?/sec 1.88 262.6±0.94µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 137.1±4.92µs
? ?/sec 1.43 195.9±0.44µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 142.8±0.98µs
? ?/sec 1.94 276.6±6.21µs ? ?/sec
lookup_table_case_when/case when i32 -> utf8, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 135.6±2.08µs
? ?/sec 1.45 195.9±0.52µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
123.1±0.82µs ? ?/sec 6.91 850.8±1.44µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
129.3±1.50µs ? ?/sec 6.99 903.1±1.82µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
104.7±0.68µs ? ?/sec 6.09 637.7±2.43µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
124.0±1.38µs ? ?/sec 6.85 849.8±1.84µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
129.1±1.07µs ? ?/sec 6.98 901.1±1.64µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
104.8±0.42µs ? ?/sec 6.09 637.9±1.91µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
123.4±0.66µs ? ?/sec 6.91 852.4±3.73µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
129.2±0.64µs ? ?/sec 6.99 902.2±2.40µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
124.0±1.05µs ? ?/sec 6.84 848.6±2.58µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 117.8±0.97µs
? ?/sec 1.96 230.3±0.50µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 122.4±1.09µs
? ?/sec 2.75 336.0±1.34µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 103.3±1.18µs
? ?/sec 3.08 317.9±0.86µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 117.5±0.85µs
? ?/sec 1.96 230.3±0.40µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 122.4±1.32µs
? ?/sec 2.75 336.0±0.87µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 103.2±0.41µs
? ?/sec 3.08 318.3±0.84µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 118.2±1.88µs
? ?/sec 1.95 230.5±0.55µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 122.4±1.28µs
? ?/sec 2.75 336.3±2.75µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 10 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 118.0±1.05µs
? ?/sec 1.96 230.9±0.89µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
122.7±0.49µs ? ?/sec 9.90 1214.6±4.31µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
127.4±1.42µs ? ?/sec 9.46 1204.7±4.18µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
103.6±0.81µs ? ?/sec 8.06 834.9±1.91µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
122.3±0.72µs ? ?/sec 9.89 1209.1±2.30µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
127.3±1.92µs ? ?/sec 9.45 1203.4±3.38µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
103.5±0.95µs ? ?/sec 8.11 839.4±4.94µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
122.3±0.45µs ? ?/sec 9.89 1209.8±2.80µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
127.1±0.57µs ? ?/sec 9.47 1202.9±3.75µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
122.4±0.49µs ? ?/sec 9.90 1211.1±14.78µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 117.4±0.85µs
? ?/sec 1.96 230.3±0.53µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 121.9±0.83µs
? ?/sec 2.76 336.5±2.09µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 102.7±0.46µs
? ?/sec 3.10 318.3±0.76µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 117.7±1.12µs
? ?/sec 1.96 230.4±0.34µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 122.4±1.23µs
? ?/sec 2.75 336.3±1.21µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 102.8±0.49µs
? ?/sec 3.10 318.5±0.84µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 117.8±1.09µs
? ?/sec 1.96 230.8±0.83µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 122.7±1.29µs
? ?/sec 2.74 336.2±0.95µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 20 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 118.2±0.99µs
? ?/sec 1.95 230.8±0.63µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00
123.2±0.34µs ? ?/sec 4.47 550.2±1.65µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00
129.1±0.83µs ? ?/sec 4.88 629.7±1.84µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00
105.7±1.59µs ? ?/sec 4.61 486.9±1.16µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00
123.8±0.73µs ? ?/sec 4.45 550.6±7.24µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00
129.4±0.73µs ? ?/sec 4.86 628.7±1.65µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00
105.5±0.58µs ? ?/sec 4.61 486.7±1.72µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00
124.2±0.76µs ? ?/sec 4.43 550.9±2.04µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00
129.7±0.71µs ? ?/sec 4.86 629.6±3.62µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, all equally
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00
124.1±0.81µs ? ?/sec 4.42 549.1±3.11µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0 1.00 117.6±0.76µs
? ?/sec 1.96 230.7±1.21µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.1 1.00 124.3±2.64µs
? ?/sec 2.71 336.6±2.83µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.1, nulls: 0.5 1.00 102.7±0.44µs
? ?/sec 3.09 317.8±0.72µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0 1.00 117.5±0.94µs
? ?/sec 1.96 230.6±1.16µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.1 1.00 122.3±1.19µs
? ?/sec 2.75 336.6±1.35µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.5, nulls: 0.5 1.00 102.7±0.38µs
? ?/sec 3.10 318.4±1.13µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0 1.00 117.9±1.05µs
? ?/sec 1.96 230.6±0.32µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 0.9, nulls: 0.1 1.00 122.7±1.30µs
? ?/sec 2.74 336.1±1.06µs ? ?/sec
lookup_table_case_when/case when utf8 -> i32, 5 entries, only first 2 are
true/case_when 8192 rows: in_range: 1, nulls: 0 1.00 118.2±1.15µs
? ?/sec 1.95 230.6±0.49µs ? ?/sec
```
</p>
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
