alamb commented on PR #18152:
URL: https://github.com/apache/datafusion/pull/18152#issuecomment-3442467836
🤖: Benchmark completed
<details><summary>Details</summary>
<p>
```
group
case_reduce_filtering 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.00 2.7±0.03ms ? ?/sec
1.32 3.5±0.02ms ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.01 55.8±0.19µs ? ?/sec
1.00 55.3±0.22µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.01 366.4±5.45µs ? ?/sec
1.00 362.0±7.05µs ? ?/sec
case_when 8192x100: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.01µs ? ?/sec
1.00 6.8±0.07µ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.00 1696.0±14.34ms ? ?/sec
1.65 2.8±0.02s ? ?/sec
case_when 8192x100: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 1.00 1710.7±10.78ms ? ?/sec
1.64 2.8±0.02s ? ?/sec
case_when 8192x100: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.04 376.9±9.98µs ? ?/sec
1.00 362.2±7.86µ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 2.7±0.02ms ? ?/sec
1.30 3.5±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 209.1±2.57µs ? ?/sec
2.00 418.2±3.56µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.01 55.4±0.63µs ? ?/sec
1.00 54.9±0.13µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.00 23.2±0.38µs ? ?/sec
1.01 23.4±0.61µs ? ?/sec
case_when 8192x3: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.8±0.01µs ? ?/sec
1.02 6.9±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.00 69.0±0.18ms ? ?/sec
3.77 260.0±0.97ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n ELSE
n + 1 END 1.00 78.1±0.28ms ? ?/sec
3.04 237.2±0.49ms ? ?/sec
case_when 8192x3: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.04 33.0±0.69µs ? ?/sec
1.00 31.9±0.43µ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 196.3±2.25µs ? ?/sec
1.96 385.1±17.57µ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 1416.5±26.02µs ? ?/sec
1.34 1891.9±16.22µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN 1 ELSE 0 END
1.00 55.3±0.17µs ? ?/sec
1.00 55.2±0.25µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 ELSE c3 END
1.03 174.1±2.98µs ? ?/sec
1.00 168.9±4.30µs ? ?/sec
case_when 8192x50: CASE WHEN c1 <= 500 THEN c2 [ELSE NULL] END
1.00 6.5±0.01µs ? ?/sec
1.05 6.9±0.04µ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.00 764.1±4.19ms ? ?/sec
1.92 1469.4±9.71ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 0 THEN 0 WHEN 1 THEN 1 ... WHEN n THEN n
ELSE n + 1 END 1.00 795.3±5.54ms ? ?/sec
1.81 1440.7±9.30ms ? ?/sec
case_when 8192x50: CASE c1 WHEN 1 THEN c2 WHEN 2 THEN c3 END
1.00 181.5±2.42µs ? ?/sec
1.01 183.7±5.02µ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 1413.2±23.88µs ? ?/sec
1.32 1863.5±17.14µ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]
