Apache Spark TPC-H Benchmark - OpenBenchmarking.org

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.

* 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 22 April 2024.

Performance Metrics

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)

Intel Core i9-14900K

95th

5.5 ^{+/- 0.1}

Intel Xeon Platinum 8380

87th

5.8 ^{+/- 0.1}

AMD EPYC 8534P 64-Core

79th

6.3

Mid-Tier

75th

> 6.5

AMD Ryzen Threadripper PRO 7995WX 96-Cores

75th

6.7 ^{+/- 0.2}

AMD Ryzen 9 7950X 16-Core

73rd

6.8

2 x Intel Xeon Platinum 8380

63rd

7.2 ^{+/- 0.2}

2 x Intel Xeon Platinum 8490H

57th

8.1 ^{+/- 0.1}

AMD Ryzen 5 8600G

52nd

8.1

Median

50th

8.2

Intel Core i5-14500

50th

8.4

Intel Core i9-10980XE

42nd

10.1 ^{+/- 0.3}

Intel Xeon Silver 4216

37th

10.5 ^{+/- 0.3}

AMD Ryzen Threadripper 3990X 64-Core

33rd

10.6 ^{+/- 0.1}

Low-Tier

25th

> 11.8

AMD EPYC 7F32 8-Core

25th

11.9 ^{+/- 0.2}

2 x INTEL XEON PLATINUM 8592

21st

13.0 ^{+/- 1.1}

Intel Core i3-14100

14th

14.2

2 x AMD EPYC 9684X 96-Core

12th

14.8 ^{+/- 0.1}

AMD Ryzen 7 PRO 5850U

7th

16.9 ^{+/- 0.1}

Intel Core i7-1065G7

3rd

55.2 ^{+/- 0.5}

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.

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.7%.

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.

SSD Storage 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
rok1 Featured Processor Comparison	rk1-rok-emmc - Rockchip ARMv8 Cortex-A76
rk1-emmc-compile 1 System - 205 Benchmark Results	rk1-mainline-emmc - Turing Machines RK1 - 32GB Ubuntu 22.04 - 6.7.0 - 1.3.255
rok1 1 System - 201 Benchmark Results	rk1-rok-emmc - Turing Machines RK1 - 32GB Ubuntu 22.04 - 5.10.160-rockchip - GCC 11.4.0
rok1 Featured Processor Comparison	rk1-rok-emmc - Rockchip ARMv8 Cortex-A76
rk1-emmc-compile 3 Systems - 205 Benchmark Results	ARMv8 Cortex-A76 - Turing Machines RK1 - 32GB Ubuntu 22.04 - 6.7.0 - 1.3.255
New CPU Benchmarks 5 Systems - 587 Benchmark Results	Intel Core i5-14500 - ASUS PRIME Z790-P WIFI - Intel Raptor Lake-S PCH Ubuntu 23.10 - 6.7.3-060703-generic - GNOME Shell 45.2
apache spark tpc benchmark 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
xmas 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
eps 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
Ubuntu x86-64-v3 1 System - 209 Benchmark Results	2 x INTEL XEON PLATINUM 8592+ - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.04 - 6.2.0-20-generic - GCC 12.2.0
fhe 3 Systems - 334 Benchmark Results	AMD Ryzen 5 5500U - NB01 NL5xNU - AMD Renoir Tuxedo 22.04 - 6.0.0-1010-oem - KDE Plasma 5.26.5
dfgg 2 Systems - 130 Benchmark Results	Intel Core i7-1065G7 - Dell 06CDVY - Intel Ice Lake-LP DRAM Ubuntu 23.04 - 6.2.0-36-generic - GNOME Shell 44.3
spark tpch benchmark xeon 3 Systems - 92 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0
sdfa 4 Systems - 118 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 23.10 - 6.5.0-13-generic - GNOME Shell 45.0

Intel Optimized Power Mode Xeon Platinum Benchmarks 2 Systems - 520 Benchmark Results	2 x INTEL XEON PLATINUM 8592+ - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0
New CPU Benchmarks 5 Systems - 587 Benchmark Results	Intel Core i5-14500 - ASUS PRIME Z790-P WIFI - Intel Raptor Lake-S PCH Ubuntu 23.10 - 6.7.3-060703-generic - GNOME Shell 45.2
tpch sparky 2 Systems - 92 Benchmark Results	AMD Ryzen 9 7950X 16-Core - ASUS ROG STRIX X670E-E GAMING WIFI - AMD Device 14d8 Ubuntu 23.10 - 6.7.0-060700rc2daily20231127-generic - GNOME Shell 45.1
xmrig ycruncher xeon 4 Systems - 115 Benchmark Results	Intel Xeon Platinum 8380 - Intel M50CYP2SB2U - Intel Ice Lake IEH Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0
tpch raptor lake refresh 3 Systems - 69 Benchmark Results	Intel Core i9-14900K - ASUS PRIME Z790-P WIFI - Intel Device 7a27 Ubuntu 23.10 - 6.5.0-10-generic - GNOME Shell 45.0
xmas 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
spark tpch benchmark xeon 3 Systems - 92 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0
dfgg 2 Systems - 130 Benchmark Results	Intel Core i7-1065G7 - Dell 06CDVY - Intel Ice Lake-LP DRAM Ubuntu 23.04 - 6.2.0-36-generic - GNOME Shell 44.3
spark tpch benchmark xeon 2 Systems - 92 Benchmark Results	2 x Intel Xeon Platinum 8490H - Quanta Cloud S6Q-MB-MPS - Intel Device 1bce Ubuntu 23.10 - 6.5.0-13-generic - GCC 13.2.0
dec 2 Systems - 81 Benchmark Results	AMD EPYC 7F32 8-Core - ASRockRack EPYCD8 - AMD Starship Debian 12 - 6.1.0-11-amd64 - X Server
xm spark 3 Systems - 98 Benchmark Results	AMD Ryzen Threadripper PRO 7995WX 96-Cores - HP 8B24 - AMD Device 14a4 Ubuntu 23.10 - 6.5.0-13-generic - GNOME Shell 45.0
dec 2 Systems - 75 Benchmark Results	Intel Xeon Silver 4216 - TYAN S7100AG2NR - Intel Sky Lake-E DMI3 Registers Debian 12 - 6.1.0-11-amd64 - X Server
new 2 Systems - 78 Benchmark Results	AMD EPYC 8534P 64-Core - AMD Cinnabar - AMD Device 14a4 Ubuntu 23.10 - 6.6.0-rc5-phx-patched - X Server 1.21.1.7
sdfa 4 Systems - 118 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 23.10 - 6.5.0-13-generic - GNOME Shell 45.0
apache spark tpc benchmark 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

Apache Spark TPC-H

Project Site

Source Repository

Test Created

Test Maintainer

Test Type

Average Install Time

Average Run Time

Test Dependencies

Supported Platforms

Revision History

Suites Using This Test

Performance Metrics

Apache Spark TPC-H 3.5

Scale Factor: 10 - Q07

Tested CPU Architectures

Recent Test Results

Most Popular Test Results