tpch sparky Tests for a future article. AMD Ryzen 9 7950X 16-Core testing with a ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) and NVIDIA NV174 8GB on Ubuntu 23.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2312041-PTS-TPCHSPAR10&rdt&grt .
tpch sparky Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution a b AMD Ryzen 9 7950X 16-Core @ 5.88GHz (16 Cores / 32 Threads) ASUS ROG STRIX X670E-E GAMING WIFI (1416 BIOS) AMD Device 14d8 32GB 2000GB Samsung SSD 980 PRO 2TB + 4001GB Western Digital WD_BLACK SN850X 4000GB NVIDIA NV174 8GB NVIDIA GA104 HD Audio DELL U2723QE Intel I225-V + Intel Wi-Fi 6 AX210/AX211/AX411 Ubuntu 23.10 6.7.0-060700rc2daily20231127-generic (x86_64) GNOME Shell 45.1 X Server 1.21.1.7 + Wayland nouveau 4.3 Mesa 24.0~git2311260600.945288~oibaf~m (git-945288f 2023-11-26 mantic-oibaf-ppa) GCC 13.2.0 + LLVM 16.0.6 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: amd-pstate-epp powersave (EPP: balance_performance) - CPU Microcode: 0xa601203 Java Details - OpenJDK Runtime Environment (build 11.0.21+9-post-Ubuntu-0ubuntu123.10) Python Details - Python 3.11.6 Security Details - gather_data_sampling: Not affected + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_rstack_overflow: Vulnerable: Safe RET no microcode + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced / Automatic IBRS IBPB: conditional STIBP: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
tpch sparky spark-tpch: 1 - Geometric Mean Of All Queries spark-tpch: 1 - Q01 spark-tpch: 1 - Q02 spark-tpch: 1 - Q03 spark-tpch: 1 - Q04 spark-tpch: 1 - Q05 spark-tpch: 1 - Q06 spark-tpch: 1 - Q07 spark-tpch: 1 - Q08 spark-tpch: 1 - Q09 spark-tpch: 1 - Q10 spark-tpch: 1 - Q11 spark-tpch: 1 - Q12 spark-tpch: 1 - Q13 spark-tpch: 1 - Q14 spark-tpch: 1 - Q15 spark-tpch: 1 - Q16 spark-tpch: 1 - Q17 spark-tpch: 1 - Q18 spark-tpch: 1 - Q19 spark-tpch: 1 - Q20 spark-tpch: 1 - Q21 spark-tpch: 1 - Q22 spark-tpch: 10 - Geometric Mean Of All Queries spark-tpch: 10 - Q01 spark-tpch: 10 - Q02 spark-tpch: 10 - Q03 spark-tpch: 10 - Q04 spark-tpch: 10 - Q05 spark-tpch: 10 - Q06 spark-tpch: 10 - Q07 spark-tpch: 10 - Q08 spark-tpch: 10 - Q09 spark-tpch: 10 - Q10 spark-tpch: 10 - Q11 spark-tpch: 10 - Q12 spark-tpch: 10 - Q13 spark-tpch: 10 - Q14 spark-tpch: 10 - Q15 spark-tpch: 10 - Q16 spark-tpch: 10 - Q17 spark-tpch: 10 - Q18 spark-tpch: 10 - Q19 spark-tpch: 10 - Q20 spark-tpch: 10 - Q21 spark-tpch: 10 - Q22 spark-tpch: 50 - Geometric Mean Of All Queries spark-tpch: 50 - Q01 spark-tpch: 50 - Q02 spark-tpch: 50 - Q03 spark-tpch: 50 - Q04 spark-tpch: 50 - Q05 spark-tpch: 50 - Q06 spark-tpch: 50 - Q07 spark-tpch: 50 - Q08 spark-tpch: 50 - Q09 spark-tpch: 50 - Q10 spark-tpch: 50 - Q11 spark-tpch: 50 - Q12 spark-tpch: 50 - Q13 spark-tpch: 50 - Q14 spark-tpch: 50 - Q15 spark-tpch: 50 - Q16 spark-tpch: 50 - Q17 spark-tpch: 50 - Q18 spark-tpch: 50 - Q19 spark-tpch: 50 - Q20 spark-tpch: 50 - Q21 spark-tpch: 50 - Q22 spark-tpch: 100 - Geometric Mean Of All Queries spark-tpch: 100 - Q01 spark-tpch: 100 - Q02 spark-tpch: 100 - Q03 spark-tpch: 100 - Q04 spark-tpch: 100 - Q05 spark-tpch: 100 - Q06 spark-tpch: 100 - Q07 spark-tpch: 100 - Q08 spark-tpch: 100 - Q09 spark-tpch: 100 - Q10 spark-tpch: 100 - Q11 spark-tpch: 100 - Q12 spark-tpch: 100 - Q13 spark-tpch: 100 - Q14 spark-tpch: 100 - Q15 spark-tpch: 100 - Q16 spark-tpch: 100 - Q17 spark-tpch: 100 - Q18 spark-tpch: 100 - Q19 spark-tpch: 100 - Q20 spark-tpch: 100 - Q21 spark-tpch: 100 - Q22 a b 1.07551776 2.15049744 1.17284179 1.38435690 1.23955063 1.43073702 0.53335468 1.41287736 1.17277988 1.99082625 1.26676043 0.62522713 1.05782934 0.79169283 0.73867546 0.77650092 0.77560131 1.46219754 1.78931276 0.69395985 1.07470175 3.59445604 0.62112687 5.75490740 6.31123320 2.25004848 7.48101139 6.57711776 7.90605259 4.43370914 6.74756765 7.33203538 9.19322745 7.10535590 1.79728555 6.23972781 3.02257347 5.44949262 4.97813797 2.27786120 11.82977899 12.66393947 5.20179097 6.33807818 23.40988223 2.17159438 25.67956047 25.41260084 6.85708189 36.09375890 31.13532194 36.86378097 22.11989021 33.64093908 36.28119914 45.66526032 33.06687800 6.12172890 32.37508329 11.80730565 25.64216487 23.34649658 6.54233440 58.29380417 63.01756032 25.30857913 28.74859746 128.89452616 8.09008837 52.10228998 49.17952347 11.49857966 68.93591054 63.45726903 75.23068237 44.72012329 67.8046875 72.40360769 104.64765930 66.99342346 12.33996900 66.35007477 22.81828880 51.28989792 46.88688024 13.42031988 123.03999074 128.13427480 50.71526591 57.65707398 257.50322469 15.61734390 1.06830837 2.13585591 1.18847537 1.36037207 1.28710282 1.48697722 0.53715831 1.3959434 1.12742186 2.03148746 1.28957009 0.6105814 1.06473088 0.76867819 0.76540375 0.77098012 0.71527606 1.44221175 1.77616072 0.66654742 1.15345001 3.61977267 0.60666102 5.7573568 6.14967728 2.1100986 7.33041668 6.30942202 7.57603073 4.36986017 6.81029701 7.11410093 9.60581684 7.15195179 1.9416523 6.35672379 2.90124249 5.33258104 5.01319218 2.33905911 11.80338097 12.62981319 5.2261281 6.10991335 23.30423164 2.08513021 25.9047539 25.54037476 6.84252167 35.11714935 31.28269577 37.95347977 22.31266403 33.19272614 34.89360428 44.23796463 33.62889481 5.90383053 32.2621994 12.00696564 26.25609779 23.47036362 7.12703753 59.47691345 62.96906662 25.79829979 29.01455307 129.67033386 8.37519741 51.03976536 49.30712128 11.56032753 69.42839813 62.6139183 74.52184296 44.59963989 68.33406067 72.32094574 102.81005096 65.45317078 12.13181114 63.16571045 22.05514908 50.8004837 46.54631805 13.19703007 119.16635132 124.86743164 50.32149124 56.27810669 251.0748291 15.30221462 OpenBenchmarking.org
Apache Spark TPC-H Scale Factor: 1 - Geometric Mean Of All Queries OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Geometric Mean Of All Queries a b 0.242 0.484 0.726 0.968 1.21 SE +/- 0.01125755, N = 3 1.07551776 1.06830837 MIN: 0.55 / MAX: 3.68 MIN: 0.61 / MAX: 3.62
Apache Spark TPC-H Scale Factor: 1 - Q01 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q01 a b 0.4839 0.9678 1.4517 1.9356 2.4195 SE +/- 0.02370651, N = 3 2.15049744 2.13585591
Apache Spark TPC-H Scale Factor: 1 - Q02 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q02 a b 0.2674 0.5348 0.8022 1.0696 1.337 SE +/- 0.02240378, N = 3 1.17284179 1.18847537
Apache Spark TPC-H Scale Factor: 1 - Q03 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q03 a b 0.3115 0.623 0.9345 1.246 1.5575 SE +/- 0.05306582, N = 3 1.38435690 1.36037207
Apache Spark TPC-H Scale Factor: 1 - Q04 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q04 a b 0.2896 0.5792 0.8688 1.1584 1.448 SE +/- 0.03111532, N = 3 1.23955063 1.28710282
Apache Spark TPC-H Scale Factor: 1 - Q05 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q05 a b 0.3346 0.6692 1.0038 1.3384 1.673 SE +/- 0.01308397, N = 3 1.43073702 1.48697722
Apache Spark TPC-H Scale Factor: 1 - Q06 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q06 a b 0.1209 0.2418 0.3627 0.4836 0.6045 SE +/- 0.00241116, N = 3 0.53335468 0.53715831
Apache Spark TPC-H Scale Factor: 1 - Q07 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q07 a b 0.3179 0.6358 0.9537 1.2716 1.5895 SE +/- 0.03064907, N = 3 1.41287736 1.39594340
Apache Spark TPC-H Scale Factor: 1 - Q08 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q08 a b 0.2639 0.5278 0.7917 1.0556 1.3195 SE +/- 0.00999755, N = 3 1.17277988 1.12742186
Apache Spark TPC-H Scale Factor: 1 - Q09 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q09 a b 0.4571 0.9142 1.3713 1.8284 2.2855 SE +/- 0.01974284, N = 3 1.99082625 2.03148746
Apache Spark TPC-H Scale Factor: 1 - Q10 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q10 a b 0.2902 0.5804 0.8706 1.1608 1.451 SE +/- 0.00838453, N = 3 1.26676043 1.28957009
Apache Spark TPC-H Scale Factor: 1 - Q11 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q11 a b 0.1407 0.2814 0.4221 0.5628 0.7035 SE +/- 0.00652178, N = 3 0.62522713 0.61058140
Apache Spark TPC-H Scale Factor: 1 - Q12 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q12 a b 0.2396 0.4792 0.7188 0.9584 1.198 SE +/- 0.02665135, N = 3 1.05782934 1.06473088
Apache Spark TPC-H Scale Factor: 1 - Q13 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q13 a b 0.1781 0.3562 0.5343 0.7124 0.8905 SE +/- 0.01146951, N = 3 0.79169283 0.76867819
Apache Spark TPC-H Scale Factor: 1 - Q14 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q14 a b 0.1722 0.3444 0.5166 0.6888 0.861 SE +/- 0.00590603, N = 3 0.73867546 0.76540375
Apache Spark TPC-H Scale Factor: 1 - Q15 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q15 a b 0.1747 0.3494 0.5241 0.6988 0.8735 SE +/- 0.01635970, N = 3 0.77650092 0.77098012
Apache Spark TPC-H Scale Factor: 1 - Q16 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q16 a b 0.1745 0.349 0.5235 0.698 0.8725 SE +/- 0.01281809, N = 3 0.77560131 0.71527606
Apache Spark TPC-H Scale Factor: 1 - Q17 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q17 a b 0.329 0.658 0.987 1.316 1.645 SE +/- 0.02547655, N = 3 1.46219754 1.44221175
Apache Spark TPC-H Scale Factor: 1 - Q18 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q18 a b 0.4026 0.8052 1.2078 1.6104 2.013 SE +/- 0.05290042, N = 3 1.78931276 1.77616072
Apache Spark TPC-H Scale Factor: 1 - Q19 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q19 a b 0.1561 0.3122 0.4683 0.6244 0.7805 SE +/- 0.03020707, N = 3 0.69395985 0.66654742
Apache Spark TPC-H Scale Factor: 1 - Q20 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q20 a b 0.2595 0.519 0.7785 1.038 1.2975 SE +/- 0.02430008, N = 3 1.07470175 1.15345001
Apache Spark TPC-H Scale Factor: 1 - Q21 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q21 a b 0.8144 1.6288 2.4432 3.2576 4.072 SE +/- 0.04461235, N = 3 3.59445604 3.61977267
Apache Spark TPC-H Scale Factor: 1 - Q22 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 1 - Q22 a b 0.1398 0.2796 0.4194 0.5592 0.699 SE +/- 0.03385261, N = 3 0.62112687 0.60666102
Apache Spark TPC-H Scale Factor: 10 - Geometric Mean Of All Queries OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Geometric Mean Of All Queries a b 1.2954 2.5908 3.8862 5.1816 6.477 SE +/- 0.01148675, N = 3 5.75490740 5.75735680 MIN: 1.77 / MAX: 23.49 MIN: 1.94 / MAX: 23.3
Apache Spark TPC-H Scale Factor: 10 - Q01 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q01 a b 2 4 6 8 10 SE +/- 0.10785121, N = 3 6.31123320 6.14967728
Apache Spark TPC-H Scale Factor: 10 - Q02 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q02 a b 0.5063 1.0126 1.5189 2.0252 2.5315 SE +/- 0.04460037, N = 3 2.25004848 2.11009860
Apache Spark TPC-H Scale Factor: 10 - Q03 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q03 a b 2 4 6 8 10 SE +/- 0.05235045, N = 3 7.48101139 7.33041668
Apache Spark TPC-H Scale Factor: 10 - Q04 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q04 a b 2 4 6 8 10 SE +/- 0.07691562, N = 3 6.57711776 6.30942202
Apache Spark TPC-H Scale Factor: 10 - Q05 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q05 a b 2 4 6 8 10 SE +/- 0.08963252, N = 3 7.90605259 7.57603073
Apache Spark TPC-H Scale Factor: 10 - Q06 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q06 a b 0.9976 1.9952 2.9928 3.9904 4.988 SE +/- 0.05008379, N = 3 4.43370914 4.36986017
Apache Spark TPC-H Scale Factor: 10 - Q07 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q07 a b 2 4 6 8 10 SE +/- 0.15015487, N = 3 6.74756765 6.81029701
Apache Spark TPC-H Scale Factor: 10 - Q08 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q08 a b 2 4 6 8 10 SE +/- 0.08511200, N = 3 7.33203538 7.11410093
Apache Spark TPC-H Scale Factor: 10 - Q09 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q09 a b 3 6 9 12 15 SE +/- 0.14272942, N = 3 9.19322745 9.60581684
Apache Spark TPC-H Scale Factor: 10 - Q10 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q10 a b 2 4 6 8 10 SE +/- 0.04310040, N = 3 7.10535590 7.15195179
Apache Spark TPC-H Scale Factor: 10 - Q11 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q11 a b 0.4369 0.8738 1.3107 1.7476 2.1845 SE +/- 0.02123125, N = 3 1.79728555 1.94165230
Apache Spark TPC-H Scale Factor: 10 - Q12 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q12 a b 2 4 6 8 10 SE +/- 0.06795618, N = 3 6.23972781 6.35672379
Apache Spark TPC-H Scale Factor: 10 - Q13 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q13 a b 0.6801 1.3602 2.0403 2.7204 3.4005 SE +/- 0.04012746, N = 3 3.02257347 2.90124249
Apache Spark TPC-H Scale Factor: 10 - Q14 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q14 a b 1.2261 2.4522 3.6783 4.9044 6.1305 SE +/- 0.03750473, N = 3 5.44949262 5.33258104
Apache Spark TPC-H Scale Factor: 10 - Q15 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q15 a b 1.128 2.256 3.384 4.512 5.64 SE +/- 0.05671005, N = 3 4.97813797 5.01319218
Apache Spark TPC-H Scale Factor: 10 - Q16 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q16 a b 0.5263 1.0526 1.5789 2.1052 2.6315 SE +/- 0.03214906, N = 3 2.27786120 2.33905911
Apache Spark TPC-H Scale Factor: 10 - Q17 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q17 a b 3 6 9 12 15 SE +/- 0.07, N = 3 11.83 11.80
Apache Spark TPC-H Scale Factor: 10 - Q18 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q18 a b 3 6 9 12 15 SE +/- 0.02, N = 3 12.66 12.63
Apache Spark TPC-H Scale Factor: 10 - Q19 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q19 a b 1.1759 2.3518 3.5277 4.7036 5.8795 SE +/- 0.04884219, N = 3 5.20179097 5.22612810
Apache Spark TPC-H Scale Factor: 10 - Q20 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q20 a b 2 4 6 8 10 SE +/- 0.05893057, N = 3 6.33807818 6.10991335
Apache Spark TPC-H Scale Factor: 10 - Q21 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q21 a b 6 12 18 24 30 SE +/- 0.05, N = 3 23.41 23.30
Apache Spark TPC-H Scale Factor: 10 - Q22 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 10 - Q22 a b 0.4886 0.9772 1.4658 1.9544 2.443 SE +/- 0.02290474, N = 3 2.17159438 2.08513021
Apache Spark TPC-H Scale Factor: 50 - Geometric Mean Of All Queries OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Geometric Mean Of All Queries a b 6 12 18 24 30 SE +/- 0.30, N = 3 25.68 25.90 MIN: 6.05 / MAX: 130.94 MIN: 5.9 / MAX: 129.67
Apache Spark TPC-H Scale Factor: 50 - Q01 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q01 a b 6 12 18 24 30 SE +/- 0.18, N = 3 25.41 25.54
Apache Spark TPC-H Scale Factor: 50 - Q02 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q02 a b 2 4 6 8 10 SE +/- 0.10852285, N = 3 6.85708189 6.84252167
Apache Spark TPC-H Scale Factor: 50 - Q03 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q03 a b 8 16 24 32 40 SE +/- 0.48, N = 3 36.09 35.12
Apache Spark TPC-H Scale Factor: 50 - Q04 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q04 a b 7 14 21 28 35 SE +/- 0.51, N = 3 31.14 31.28
Apache Spark TPC-H Scale Factor: 50 - Q05 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q05 a b 9 18 27 36 45 SE +/- 0.30, N = 3 36.86 37.95
Apache Spark TPC-H Scale Factor: 50 - Q06 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q06 a b 5 10 15 20 25 SE +/- 0.04, N = 3 22.12 22.31
Apache Spark TPC-H Scale Factor: 50 - Q07 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q07 a b 8 16 24 32 40 SE +/- 0.34, N = 3 33.64 33.19
Apache Spark TPC-H Scale Factor: 50 - Q08 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q08 a b 8 16 24 32 40 SE +/- 0.70, N = 3 36.28 34.89
Apache Spark TPC-H Scale Factor: 50 - Q09 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q09 a b 10 20 30 40 50 SE +/- 1.28, N = 3 45.67 44.24
Apache Spark TPC-H Scale Factor: 50 - Q10 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q10 a b 8 16 24 32 40 SE +/- 0.08, N = 3 33.07 33.63
Apache Spark TPC-H Scale Factor: 50 - Q11 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q11 a b 2 4 6 8 10 SE +/- 0.05184602, N = 3 6.12172890 5.90383053
Apache Spark TPC-H Scale Factor: 50 - Q12 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q12 a b 8 16 24 32 40 SE +/- 0.50, N = 3 32.38 32.26
Apache Spark TPC-H Scale Factor: 50 - Q13 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q13 a b 3 6 9 12 15 SE +/- 0.16, N = 3 11.81 12.01
Apache Spark TPC-H Scale Factor: 50 - Q14 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q14 a b 6 12 18 24 30 SE +/- 0.18, N = 3 25.64 26.26
Apache Spark TPC-H Scale Factor: 50 - Q15 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q15 a b 6 12 18 24 30 SE +/- 0.07, N = 3 23.35 23.47
Apache Spark TPC-H Scale Factor: 50 - Q16 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q16 a b 2 4 6 8 10 SE +/- 0.45590060, N = 3 6.54233440 7.12703753
Apache Spark TPC-H Scale Factor: 50 - Q17 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q17 a b 13 26 39 52 65 SE +/- 0.33, N = 3 58.29 59.48
Apache Spark TPC-H Scale Factor: 50 - Q18 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q18 a b 14 28 42 56 70 SE +/- 0.79, N = 3 63.02 62.97
Apache Spark TPC-H Scale Factor: 50 - Q19 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q19 a b 6 12 18 24 30 SE +/- 0.05, N = 3 25.31 25.80
Apache Spark TPC-H Scale Factor: 50 - Q20 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q20 a b 7 14 21 28 35 SE +/- 0.15, N = 3 28.75 29.01
Apache Spark TPC-H Scale Factor: 50 - Q21 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q21 a b 30 60 90 120 150 SE +/- 1.18, N = 3 128.89 129.67
Apache Spark TPC-H Scale Factor: 50 - Q22 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 50 - Q22 a b 2 4 6 8 10 SE +/- 0.12625543, N = 3 8.09008837 8.37519741
Apache Spark TPC-H Scale Factor: 100 - Geometric Mean Of All Queries OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Geometric Mean Of All Queries a b 12 24 36 48 60 SE +/- 0.11, N = 3 52.10 51.04 MIN: 12.07 / MAX: 259.51 MIN: 12.13 / MAX: 251.07
Apache Spark TPC-H Scale Factor: 100 - Q01 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q01 a b 11 22 33 44 55 SE +/- 0.19, N = 3 49.18 49.31
Apache Spark TPC-H Scale Factor: 100 - Q02 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q02 a b 3 6 9 12 15 SE +/- 0.22, N = 3 11.50 11.56
Apache Spark TPC-H Scale Factor: 100 - Q03 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q03 a b 15 30 45 60 75 SE +/- 0.74, N = 3 68.94 69.43
Apache Spark TPC-H Scale Factor: 100 - Q04 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q04 a b 14 28 42 56 70 SE +/- 0.57, N = 3 63.46 62.61
Apache Spark TPC-H Scale Factor: 100 - Q05 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q05 a b 20 40 60 80 100 SE +/- 1.50, N = 3 75.23 74.52
Apache Spark TPC-H Scale Factor: 100 - Q06 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q06 a b 10 20 30 40 50 SE +/- 0.08, N = 3 44.72 44.60
Apache Spark TPC-H Scale Factor: 100 - Q07 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q07 a b 15 30 45 60 75 SE +/- 0.86, N = 3 67.80 68.33
Apache Spark TPC-H Scale Factor: 100 - Q08 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q08 a b 16 32 48 64 80 SE +/- 1.59, N = 3 72.40 72.32
Apache Spark TPC-H Scale Factor: 100 - Q09 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q09 a b 20 40 60 80 100 SE +/- 2.94, N = 3 104.65 102.81
Apache Spark TPC-H Scale Factor: 100 - Q10 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q10 a b 15 30 45 60 75 SE +/- 0.38, N = 3 66.99 65.45
Apache Spark TPC-H Scale Factor: 100 - Q11 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q11 a b 3 6 9 12 15 SE +/- 0.16, N = 3 12.34 12.13
Apache Spark TPC-H Scale Factor: 100 - Q12 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q12 a b 15 30 45 60 75 SE +/- 0.05, N = 3 66.35 63.17
Apache Spark TPC-H Scale Factor: 100 - Q13 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q13 a b 5 10 15 20 25 SE +/- 0.67, N = 3 22.82 22.06
Apache Spark TPC-H Scale Factor: 100 - Q14 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q14 a b 12 24 36 48 60 SE +/- 0.30, N = 3 51.29 50.80
Apache Spark TPC-H Scale Factor: 100 - Q15 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q15 a b 11 22 33 44 55 SE +/- 0.10, N = 3 46.89 46.55
Apache Spark TPC-H Scale Factor: 100 - Q16 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q16 a b 3 6 9 12 15 SE +/- 0.11, N = 3 13.42 13.20
Apache Spark TPC-H Scale Factor: 100 - Q17 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q17 a b 30 60 90 120 150 SE +/- 0.27, N = 3 123.04 119.17
Apache Spark TPC-H Scale Factor: 100 - Q18 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q18 a b 30 60 90 120 150 SE +/- 0.40, N = 3 128.13 124.87
Apache Spark TPC-H Scale Factor: 100 - Q19 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q19 a b 11 22 33 44 55 SE +/- 0.10, N = 3 50.72 50.32
Apache Spark TPC-H Scale Factor: 100 - Q20 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q20 a b 13 26 39 52 65 SE +/- 0.14, N = 3 57.66 56.28
Apache Spark TPC-H Scale Factor: 100 - Q21 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q21 a b 60 120 180 240 300 SE +/- 1.17, N = 3 257.50 251.07
Apache Spark TPC-H Scale Factor: 100 - Q22 OpenBenchmarking.org Seconds, Fewer Is Better Apache Spark TPC-H 3.5 Scale Factor: 100 - Q22 a b 4 8 12 16 20 SE +/- 0.05, N = 3 15.62 15.30
Phoronix Test Suite v10.8.5