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.

Project Site

spark.apache.org

Source Repository

github.com

Test Created

4 December 2023

Test Maintainer

Michael Larabel 

Test Type

System

Average Install Time

41 Seconds

Average Run Time

23 Minutes, 32 Seconds

Test Dependencies

Java + Python

Supported Platforms


Public Result Uploads *Reported Installs **Reported Test Completions **Test Profile Page ViewsOpenBenchmarking.orgEventsApache Spark TPC-H Popularity Statisticspts/spark-tpch2023.122024.012024.025001000150020002500
* 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 15 February 2024.
1034.0%5021.5%10012.1%132.4%Scale Factor Option PopularityOpenBenchmarking.org

Revision History

pts/spark-tpch-1.0.0   [View Source]   Mon, 04 Dec 2023 15:28:17 GMT
Add Apache Spark TPC-H benchmark.

Suites Using This Test

Server


Performance Metrics

Analyze Test Configuration:

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)
95th
5
5.5 +/- 0.1
87th
6
5.8 +/- 0.1
Mid-Tier
75th
> 6.5
Median
50th
8.2
42nd
3
10.1 +/- 0.3
37th
4
10.5 +/- 0.3
Low-Tier
25th
> 11.8
25th
4
11.9 +/- 0.2
7th
3
16.9 +/- 0.1
3rd
4
55.2 +/- 0.5
OpenBenchmarking.orgDistribution Of Public Results - Scale Factor: 10 - Q0767 Results Range From 5 To 56 Seconds5101520253035404550556065816243240

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.orgMinutesTime Required To Complete BenchmarkScale Factor: 10 - Q07Run-Time714212835Min: 5 / Avg: 10.52 / Max: 31

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

OpenBenchmarking.orgPercent, Fewer Is BetterAverage Deviation Between RunsScale Factor: 10 - Q07Deviation246810Min: 0 / Avg: 0.52 / 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

OpenBenchmarking.org Results Compare

5 Systems - 587 Benchmark Results

Intel Core i5-14600K - ASUS PRIME Z790-P WIFI - Intel Raptor Lake-S PCH

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

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

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

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

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

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

3 Systems - 72 Benchmark Results

AMD Ryzen 7 PRO 5850U - LENOVO 20XF004WUS - AMD Renoir

Fedora Linux 39 - 6.5.8-300.fc39.x86_64 - GNOME Shell 45.0

2 Systems - 44 Benchmark Results

AMD Ryzen 9 5900HX - ASUS G513QY v1.0 - AMD Renoir

Ubuntu 22.10 - 5.19.0-46-generic - GNOME Shell 43.0

2 Systems - 44 Benchmark Results

AMD Ryzen 9 5900HX - ASUS G513QY v1.0 - AMD Renoir

Ubuntu 22.10 - 5.19.0-46-generic - GNOME Shell 43.0

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

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

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

Most Popular Test Results

OpenBenchmarking.org Results Compare

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

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

4 Systems - 115 Benchmark Results

2 x Intel Xeon Platinum 8380 - Intel M50CYP2SB2U - Intel Ice Lake IEH

Ubuntu 23.10 - 6.6.0-rc5-phx-patched - GNOME Shell 45.0

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

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

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

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

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

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

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

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

2 Systems - 81 Benchmark Results

AMD EPYC 7F32 8-Core - ASRockRack EPYCD8 - AMD Starship

Debian 12 - 6.1.0-11-amd64 - X Server

3 Systems - 72 Benchmark Results

AMD Ryzen 7 PRO 5850U - LENOVO 20XF004WUS - AMD Renoir

Fedora Linux 39 - 6.5.8-300.fc39.x86_64 - GNOME Shell 45.0

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

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

Find More Test Results