Apache Spark TPC-H This is a benchmark of Apache Spark using TPC-H data-set. Apache Spark is an open-source unified analytics engine for large-scale data processing and dealing with big data. This test profile benchmarks the Apache Spark in a single-system configuration using spark-submit. The test makes use of https://github.com/ssavvides/tpch-spark/ for facilitating the TPC-H benchmark.
To run this test with the Phoronix Test Suite , the basic command is: phoronix-test-suite benchmark spark-tpch .
Test Created 4 December 2023
Test Type System
Average Install Time 1 Minute, 30 Seconds
Average Run Time 28 Minutes, 54 Seconds
Test Dependencies Java + Python
Accolades 5k+ Downloads Public Result Uploads * Reported Installs ** Reported Test Completions ** Test Profile Page Views OpenBenchmarking.org Events Apache Spark TPC-H Popularity Statistics pts/spark-tpch 2023.12 2024.01 2024.02 2024.03 2024.04 2024.05 2024.06 400 800 1200 1600 2000
* Uploading of benchmark result data to OpenBenchmarking.org is always optional (opt-in) via the Phoronix Test Suite for users wishing to share their results publicly. ** Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform. Data updated weekly as of 24 June 2024.
10 36.9% 50 20.2% 100 11.2% 1 31.7% Scale Factor Option Popularity OpenBenchmarking.org
Revision Historypts/spark-tpch-1.0.0 [View Source ] Mon, 04 Dec 2023 15:28:17 GMT Add Apache Spark TPC-H benchmark.
Performance MetricsAnalyze Test Configuration: pts/spark-tpch-1.0.x - Scale Factor: 10 - Q07 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q19 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q09 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q06 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q04 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q12 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q22 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q13 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q10 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q08 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q21 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q11 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q16 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q20 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q17 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q18 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q05 pts/spark-tpch-1.0.x - Scale Factor: 10 - Geometric Mean Of All Queries pts/spark-tpch-1.0.x - Scale Factor: 10 - Q01 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q14 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q02 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q15 pts/spark-tpch-1.0.x - Scale Factor: 10 - Q03 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q02 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q13 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q14 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q15 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q19 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q09 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q16 pts/spark-tpch-1.0.x - Scale Factor: 1 - Geometric Mean Of All Queries pts/spark-tpch-1.0.x - Scale Factor: 1 - Q12 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q22 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q21 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q08 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q03 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q01 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q18 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q04 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q17 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q05 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q11 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q10 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q06 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q07 pts/spark-tpch-1.0.x - Scale Factor: 1 - Q20 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q01 pts/spark-tpch-1.0.x - Scale Factor: 50 - Geometric Mean Of All Queries pts/spark-tpch-1.0.x - Scale Factor: 50 - Q22 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q02 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q13 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q12 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q06 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q08 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q04 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q18 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q07 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q11 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q19 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q20 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q21 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q14 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q10 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q15 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q03 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q16 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q05 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q17 pts/spark-tpch-1.0.x - Scale Factor: 50 - Q09 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q14 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q15 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q01 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q17 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q22 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q03 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q12 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q18 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q16 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q13 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q07 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q08 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q05 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q10 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q11 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q20 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q09 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q04 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q06 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q19 pts/spark-tpch-1.0.x - Scale Factor: 100 - Geometric Mean Of All Queries pts/spark-tpch-1.0.x - Scale Factor: 100 - Q02 pts/spark-tpch-1.0.x - Scale Factor: 100 - Q21 Apache Spark TPC-H 3.5 Scale Factor: 10 - Q07 OpenBenchmarking.org metrics for this test profile configuration based on 79 public results since 4 December 2023 with the latest data as of 18 February 2024 .
Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.
Component
Percentile Rank
# Compatible Public Results
Seconds (Average)
OpenBenchmarking.org Distribution Of Public Results - Scale Factor: 10 - Q07 79 Results Range From 5 To 56 Seconds 5 10 15 20 25 30 35 40 45 50 55 60 65 10 20 30 40 50
Based on OpenBenchmarking.org data, the selected test / test configuration (Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q07 ) has an average run-time of 11 minutes . By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.
OpenBenchmarking.org Minutes Time Required To Complete Benchmark Scale Factor: 10 - Q07 Run-Time 7 14 21 28 35 Min: 5 / Avg: 10.37 / Max: 31
Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.7% .
OpenBenchmarking.org Percent, Fewer Is Better Average Deviation Between Runs Scale Factor: 10 - Q07 Deviation 2 4 6 8 10 Min: 0 / Avg: 0.67 / Max: 3
Tested CPU Architectures This benchmark has been successfully tested on the below mentioned architectures. The CPU architectures listed is where successful OpenBenchmarking.org result uploads occurred, namely for helping to determine if a given test is compatible with various alternative CPU architectures.
CPU Architecture
Kernel Identifier
Verified On
Intel / AMD x86 64-bit
x86_64
(Many Processors)
Recent Test Results
Featured Processor Comparison
1 System - 205 Benchmark Results
rk1-mainline-emmc - Turing Machines RK1 - 32GB
Ubuntu 22.04 - 6.7.0 - 1.3.255
1 System - 192 Benchmark Results
AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4
Ubuntu 23.10 - 6.8.1-060801-generic - GNOME Shell 45.2
Featured Processor Comparison
1 System - 205 Benchmark Results
rk1-mainline-emmc - Turing Machines RK1 - 32GB
Ubuntu 22.04 - 6.7.0 - 1.3.255
1 System - 201 Benchmark Results
rk1-rok-emmc - Turing Machines RK1 - 32GB
Ubuntu 22.04 - 5.10.160-rockchip - GCC 11.4.0
Featured Processor Comparison
3 Systems - 205 Benchmark Results
ARMv8 Cortex-A76 - Turing Machines RK1 - 32GB
Ubuntu 22.04 - 6.7.0 - 1.3.255
5 Systems - 587 Benchmark Results
Intel Core i3-14100 - ASUS PRIME Z790-P WIFI - Intel Device 7a27
Ubuntu 23.10 - 6.7.3-060703-generic - GNOME Shell 45.2
2 Systems - 497 Benchmark Results
AMD Ryzen Threadripper 7980X 64-Cores - ASUS Pro WS TRX50-SAGE WIFI - AMD Device 14a4
Ubuntu 23.10 - 6.7.0-060700rc2daily20231126-generic - GNOME Shell 45.0
3 Systems - 134 Benchmark Results
Intel Core i9-10980XE - ASRock X299 Steel Legend - Intel Sky Lake-E DMI3 Registers
Ubuntu 22.04 - 6.2.0-36-generic - GNOME Shell 42.2
2 Systems - 164 Benchmark Results
2 x AMD EPYC 9684X 96-Core - AMD Titanite_4G - AMD Device 14a4
Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0