spark tpch benchmark xeon

Tests for a future article. 2 x Intel Xeon Platinum 8490H testing with a Quanta Cloud S6Q-MB-MPS (3A10.uh BIOS) and ASPEED on Ubuntu 23.10 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2312059-NE-SPARKTPCH04
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
a
December 05 2023
  1 Day, 21 Hours, 36 Minutes
b
December 05 2023
  9 Hours, 11 Minutes
Invert Hiding All Results Option
  1 Day, 3 Hours, 23 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


spark tpch benchmark xeon, "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q22", Lower Results Are Better "a",13.92392159,14.64499664,13.21434879,13.9769516,14.22108841 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q21", Lower Results Are Better "a",147.6179657,139.71617126,142.82341003,150.70585632,142.09078979 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q20", Lower Results Are Better "a",25.40223885,25.74715042,24.56718063,26.26449203,24.85404205 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q19", Lower Results Are Better "a",20.72411156,21.22079849,20.39047813,20.69800377,20.73789406 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q18", Lower Results Are Better "a",58.54166412,59.08574677,55.67012787,59.7677269,55.91884995 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q17", Lower Results Are Better "a",50.07253265,49.59315872,50.56216049,50.24664307,48.22275925 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q16", Lower Results Are Better "a",15.56150627,17.16921806,17.55287743,15.76253605,15.90133286 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q15", Lower Results Are Better "a",17.32284546,16.80223083,16.81908607,17.07954597,16.62261581 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q14", Lower Results Are Better "a",20.48683357,20.77309608,19.23319435,19.99011803,20.18691826 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q13", Lower Results Are Better "a",14.69589424,14.30229473,13.96956253,14.92853069 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q12", Lower Results Are Better "a",29.68865585,31.60085678,31.46944809,27.88243294,33.22661972 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q11", Lower Results Are Better "a",9.45446205,9.61013699,9.2054348,10.16670418,9.13354874 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q10", Lower Results Are Better "a",33.31071472,32.5235672,32.36826324,32.1348877,31.55046272 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q09", Lower Results Are Better "a",59.7766037,59.4486351,52.30549622 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q08", Lower Results Are Better "a",35.39128113,34.77238846,35.92019272,35.60940552,34.02582169 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q07", Lower Results Are Better "a",31.75208092,31.22381592,31.52883911,31.14113808,31.59838867 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q06", Lower Results Are Better "a",12.43187904,11.63638306,12.14139462,11.83180809,11.9302578 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q05", Lower Results Are Better "a",38.78851318,37.32844162,36.96825409,37.56470108,37.28707123 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q04", Lower Results Are Better "a",29.62841415,29.39676476,29.41743279,34.51027298,30.82745171 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q03", Lower Results Are Better "a",49.20933151,44.97353363,57.87836075,53.78534317,53.99140167 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q02", Lower Results Are Better "a",13.01601028,12.12271404,12.96030903,13.02159882,12.19419956 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Q01", Lower Results Are Better "a",20.68475723,20.70744705,20.82613182,19.63739395,20.43914795 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 100 - Geometric Mean Of All Queries", Lower Results Are Better "a",27.99795159,28.22001576,26.50761634,27.84388887,27.67068459 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q22", Lower Results Are Better "a",7.42293596,7.94340754,7.11010599 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q21", Lower Results Are Better "a",68.4249115,76.42950439,76.19059753 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q20", Lower Results Are Better "a",15.73502159,15.84697819,15.58725452 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q19", Lower Results Are Better "a",11.78983974,11.08821297,11.13500118 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q18", Lower Results Are Better "a",30.62631607,30.59217453,31.75140381 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q17", Lower Results Are Better "a",24.8764782,25.46813583,25.39998436 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q16", Lower Results Are Better "a",9.99705315,9.5707655,9.70438862 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q15", Lower Results Are Better "a",9.72338581,9.33837605,9.34325218 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q14", Lower Results Are Better "a",11.45623302,11.9992094,11.39611149 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q13", Lower Results Are Better "a",11.09546852,10.4507494,9.83920193 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q12", Lower Results Are Better "a",15.23459148,15.25761604,17.86521721 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q11", Lower Results Are Better "a",7.44399214,6.98121977,7.04443502 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q10", Lower Results Are Better "a",20.97345543,20.87364578,18.96818733 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q09", Lower Results Are Better "a",29.61672211,30.06814766,27.18510246 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q08", Lower Results Are Better "a",21.78796005,21.885355,21.53447342 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q07", Lower Results Are Better "a",20.56182289,21.33809662,21.00464821 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q06", Lower Results Are Better "a",7.20582628,7.43887758,6.48548174 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q05", Lower Results Are Better "a",24.37643814,31.26420212,25.76124191 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q04", Lower Results Are Better "a",19.31408119,15.78526497,17.18326569 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q03", Lower Results Are Better "a",29.79068375,20.95693016,32.93644714 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q02", Lower Results Are Better "a",10.75407124,9.97619534,11.11455536 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Q01", Lower Results Are Better "a",14.54803562,13.02210522,14.13937759 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 50 - Geometric Mean Of All Queries", Lower Results Are Better "a",16.17828228,16.17950407,15.92786153 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q22", Lower Results Are Better "a",4.24868059,4.03195143,3.57201695 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q21", Lower Results Are Better "a",20.63793755,19.36013794,19.6401844 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q20", Lower Results Are Better "a",6.77835512,6.90731382,6.70221901 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q19", Lower Results Are Better "a",3.84333968,5.89132404,3.7454915 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q18", Lower Results Are Better "a",10.48575115,10.35022354,10.74996948 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q17", Lower Results Are Better "a",8.52778149,8.44237041,8.98422813 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q16", Lower Results Are Better "a",4.17215872,4.68745422,4.22962189 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q15", Lower Results Are Better "a",3.83566236,3.95637727,3.66251969 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q14", Lower Results Are Better "a",4.05545139,4.28779411,4.07662821 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q13", Lower Results Are Better "a",5.50658655,4.62696743,4.52809286 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q12", Lower Results Are Better "a",6.88698721,5.71890163,6.20484734 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q11", Lower Results Are Better "a",4.65450191,4.98971272,4.89871168 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q10", Lower Results Are Better "a",8.77736759,9.31253529,8.80583477 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q09", Lower Results Are Better "a",12.82316208,13.41424274,13.58252144 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q08", Lower Results Are Better "a",8.83748722,8.32398796,8.43732834 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q07", Lower Results Are Better "a",8.25449562,8.06815243,8.19440079 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q06", Lower Results Are Better "a",1.65304577,2.51159501,2.45224142 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q05", Lower Results Are Better "a",10.29045296,10.85140133,10.31676579 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q04", Lower Results Are Better "a",6.94999456,6.36531305,7.7293601 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q03", Lower Results Are Better "a",8.21310329,8.31948376,9.19011307 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q02", Lower Results Are Better "a",4.54319811,5.02316427,4.72614145 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Q01", Lower Results Are Better "a",7.37802935,7.43223572,6.72797775 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 10 - Geometric Mean Of All Queries", Lower Results Are Better "a",6.67513689,6.7935783,6.48011561 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q22", Lower Results Are Better "a",0.90098566,1.03283763,1.00878322,0.90776587,1.00848114,0.91940492 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q21", Lower Results Are Better "a",7.15140295,7.45782518,7.37656307,7.20197296,7.35680819,7.6153059 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q20", Lower Results Are Better "a",2.37190032,2.03916526,2.20780277,2.10491371,2.60167909,2.00754309 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q19", Lower Results Are Better "a",0.82711375,0.96325999,0.93480682,0.88845253,1.01231587,1.02737653 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q18", Lower Results Are Better "a",3.05215383,3.43146229,3.36444473,3.30732632,3.18399167,3.12093067 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q17", Lower Results Are Better "a",2.11112571,2.36561203,2.30498791,2.29929328,2.50300622,2.20241046 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q16", Lower Results Are Better "a",1.19948614,1.26106071,1.16318297,1.24044931,1.08366203,1.31532586 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q15", Lower Results Are Better "a",1.74984896,1.66674352,2.18301034,1.78512454,1.69802284,1.68789935 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q14", Lower Results Are Better "a",1.82855356,2.16268158,1.44978023,1.81827819,1.71306598,1.3494693 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q13", Lower Results Are Better "a",1.16925001,1.21427774,1.26612866,1.35704279,1.1148181,1.2484014 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q12", Lower Results Are Better "a",1.60222638,2.25150871,2.11576271,1.81431365,1.68877602,1.99335527 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q11", Lower Results Are Better "a",0.90466183,0.95381457,0.9250744,0.9500224,1.13109851,1.07828903 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q10", Lower Results Are Better "a",2.53231621,2.64852428,2.58643341,2.94010639,2.94952321,2.69008684 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q09", Lower Results Are Better "a",4.09847212,4.27973461,3.34193659,4.00275946,3.88282776,4.1376462 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q08", Lower Results Are Better "a",1.98978031,1.93762255,1.84017146,1.67866325,1.86297131,2.04345274 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q07", Lower Results Are Better "a",3.36653924,2.87767124,2.73917079,2.89288068,2.96502423,2.98120952 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q06", Lower Results Are Better "a",0.73762864,0.88381326,0.74688083,0.46709207,0.97345889,0.79918653 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q05", Lower Results Are Better "a",3.7447679,2.95247889,3.3989799,2.75745535,3.47166705,3.88453555 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q04", Lower Results Are Better "a",2.6099081,2.43401575,2.52433777,2.52182627,2.69088459,2.86207056 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q03", Lower Results Are Better "a",2.58431697,2.99829125,3.19992304,3.12149191,2.78169179,2.79133892 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q02", Lower Results Are Better "a",1.93446028,1.88948679,1.94868982,1.66458666,1.9401257,1.7556777 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Q01", Lower Results Are Better "a",5.57932472,4.42649174,5.04254341,4.36397886,5.00745726,5.1380167 "b", "Apache Spark TPC-H 3.5 - Scale Factor: 1 - Geometric Mean Of All Queries", Lower Results Are Better "a",1.85896191,1.99673483,1.91649088,1.91660788,1.94935227,1.92275888 "b",