Test configuration for estimating the file system API request costs (Alluxio/S3) per individual queries in the TPC-DS suite.
The following table contains the complete test results for each query from the TPC-DS suite excluding query q72:
| Query name | No. of executions | File Infos Got - avg. value per query | GetFileInfo Operations - avg. value per query | GetFileInfo Operations - S3 cost per query ($) | File Infos Got - S3 cost per query ($) |
|---|---|---|---|---|---|
| q01 | 10 | 10811.80 | 8646.30 | 0.0043 | 0.0035 |
| q02 | 10 | 36636.00 | 29306.00 | 0.0147 | 0.0117 |
| q03 | 10 | 9147.00 | 7319.00 | 0.0037 | 0.0029 |
| q04 | 10 | 46704.70 | 37359.20 | 0.0187 | 0.0149 |
| q05 | 10 | 49908.20 | 39921.50 | 0.0200 | 0.0160 |
| q06 | 10 | 9174.00 | 7338.00 | 0.0037 | 0.0029 |
| q07 | 10 | 7515.40 | 6011.50 | 0.0030 | 0.0024 |
| q08 | 10 | 3520.30 | 2815.20 | 0.0014 | 0.0011 |
| q09 | 10 | 137031.00 | 109669.00 | 0.0548 | 0.0439 |
| q10 | 10 | 18128.70 | 14499.60 | 0.0073 | 0.0058 |
| q11 | 10 | 27245.60 | 21794.60 | 0.0109 | 0.0087 |
| q12 | 10 | 6703.70 | 5361.00 | 0.0027 | 0.0021 |
| q13 | 10 | 6741.20 | 5391.60 | 0.0027 | 0.0022 |
| q14_1 | 10 | 159200.10 | 127576.90 | 0.0637 | 0.0510 |
| q14_2 | 10 | 110933.80 | 88732.60 | 0.0444 | 0.0355 |
| q15 | 10 | 7147.80 | 5716.20 | 0.0029 | 0.0023 |
| q16 | 10 | 28895.00 | 23114.00 | 0.0116 | 0.0092 |
| q17 | 10 | 24934.10 | 19944.20 | 0.0100 | 0.0080 |
| q18 | 10 | 8604.90 | 6879.70 | 0.0034 | 0.0028 |
| q19 | 10 | 9168.00 | 7334.00 | 0.0037 | 0.0029 |
| q20 | 10 | 5931.80 | 4743.60 | 0.0024 | 0.0019 |
| q21 | 10 | 1323.00 | 1056.00 | 0.0005 | 0.0004 |
| q22 | 10 | 1159.50 | 926.00 | 0.0005 | 0.0004 |
| q23_1 | 10 | 61313.60 | 49054.30 | 0.0245 | 0.0196 |
| q23_2 | 10 | 60566.20 | 48457.60 | 0.0242 | 0.0194 |
| q24_1 | 10 | 38352.00 | 30680.00 | 0.0153 | 0.0123 |
| q24_2 | 10 | 38352.00 | 30680.00 | 0.0153 | 0.0123 |
| q25 | 10 | 26370.50 | 21093.80 | 0.0105 | 0.0084 |
| q26 | 10 | 7723.30 | 6175.10 | 0.0031 | 0.0025 |
| q27 | 10 | 6752.80 | 5401.60 | 0.0027 | 0.0022 |
| q28 | 10 | 54810.00 | 43866.00 | 0.0219 | 0.0175 |
| q29 | 10 | 26773.60 | 21416.20 | 0.0107 | 0.0086 |
| q30 | 10 | 8622.70 | 6893.40 | 0.0034 | 0.0028 |
| q31 | 10 | 27378.70 | 21895.90 | 0.0110 | 0.0088 |
| q32 | 10 | 9943.80 | 7952.00 | 0.0040 | 0.0032 |
| q33 | 10 | 23423.50 | 18730.40 | 0.0094 | 0.0075 |
| q34 | 10 | 7497.10 | 5998.00 | 0.0030 | 0.0024 |
| q35 | 10 | 17169.70 | 13732.40 | 0.0069 | 0.0055 |
| q36 | 10 | 5464.60 | 4372.00 | 0.0022 | 0.0017 |
| q37 | 10 | 10503.00 | 8401.00 | 0.0042 | 0.0034 |
| q38 | 10 | 22560.50 | 18046.40 | 0.0090 | 0.0072 |
| q39_1 | 10 | 2646.00 | 2112.00 | 0.0011 | 0.0008 |
| q39_2 | 10 | 2646.00 | 2112.00 | 0.0011 | 0.0008 |
| q40 | 10 | 19601.50 | 15679.00 | 0.0078 | 0.0063 |
| q41 | 10 | 12.00 | 8.00 | 0.0000 | 0.0000 |
| q42 | 10 | 9147.00 | 7319.00 | 0.0037 | 0.0029 |
| q43 | 10 | 9147.00 | 7319.00 | 0.0037 | 0.0029 |
| q44 | 10 | 36552.00 | 29252.00 | 0.0146 | 0.0117 |
| q45 | 10 | 6663.10 | 5326.70 | 0.0027 | 0.0021 |
| q46 | 10 | 7135.20 | 5706.80 | 0.0029 | 0.0023 |
| q47 | 10 | 21993.30 | 17595.90 | 0.0088 | 0.0070 |
| q48 | 10 | 7535.80 | 6028.10 | 0.0030 | 0.0024 |
| q49 | 10 | 49176.70 | 39339.70 | 0.0197 | 0.0157 |
| q50 | 10 | 18371.90 | 14696.80 | 0.0073 | 0.0059 |
| q51 | 10 | 14757.20 | 11806.80 | 0.0059 | 0.0047 |
| q52 | 10 | 9147.00 | 7319.00 | 0.0037 | 0.0029 |
| q53 | 10 | 6767.80 | 5414.50 | 0.0027 | 0.0022 |
| q54 | 10 | 25395.80 | 20313.10 | 0.0102 | 0.0081 |
| q55 | 10 | 9147.00 | 7319.00 | 0.0037 | 0.0029 |
| q56 | 10 | 21282.50 | 17017.20 | 0.0085 | 0.0068 |
| q57 | 10 | 20939.90 | 16744.40 | 0.0084 | 0.0067 |
| q58 | 10 | 27506.00 | 21997.00 | 0.0110 | 0.0088 |
| q59 | 10 | 18306.00 | 14646.00 | 0.0073 | 0.0059 |
| q60 | 10 | 22441.60 | 17944.30 | 0.0090 | 0.0072 |
| q61 | 10 | 12674.50 | 10137.60 | 0.0051 | 0.0041 |
| q62 | 10 | 9144.00 | 7312.00 | 0.0037 | 0.0029 |
| q63 | 10 | 6436.80 | 5149.60 | 0.0026 | 0.0021 |
| q64 | 10 | 75148.30 | 60099.40 | 0.0301 | 0.0240 |
| q65 | 10 | 9965.70 | 7974.50 | 0.0040 | 0.0032 |
| q66 | 10 | 16754.20 | 13397.10 | 0.0067 | 0.0054 |
| q67 | 10 | 4377.90 | 3502.50 | 0.0018 | 0.0014 |
| q68 | 10 | 3553.50 | 2841.10 | 0.0014 | 0.0011 |
| q69 | 10 | 17434.20 | 13943.70 | 0.0070 | 0.0056 |
| q70 | 10 | 12543.60 | 10037.30 | 0.0050 | 0.0040 |
| q71 | 10 | 21584.20 | 17265.20 | 0.0086 | 0.0069 |
| q73 | 10 | 3593.30 | 2874.60 | 0.0014 | 0.0011 |
| q74 | 10 | 22112.40 | 17687.70 | 0.0088 | 0.0071 |
| q75 | 10 | 101468.40 | 81166.30 | 0.0406 | 0.0325 |
| q76 | 10 | 27470.00 | 21973.00 | 0.0110 | 0.0088 |
| q77 | 10 | 38484.20 | 30779.00 | 0.0154 | 0.0123 |
| q78 | 10 | 50105.10 | 40082.70 | 0.0200 | 0.0160 |
| q79 | 10 | 6651.00 | 5321.10 | 0.0027 | 0.0021 |
| q80 | 10 | 52805.90 | 42236.00 | 0.0211 | 0.0169 |
| q81 | 10 | 10426.20 | 8335.30 | 0.0042 | 0.0033 |
| q82 | 10 | 10452.00 | 8363.00 | 0.0042 | 0.0033 |
| q83 | 10 | 31498.00 | 25189.00 | 0.0126 | 0.0101 |
| q84 | 10 | 10054.00 | 8040.00 | 0.0040 | 0.0032 |
| q85 | 10 | 19737.60 | 15785.20 | 0.0079 | 0.0063 |
| q86 | 10 | 5576.80 | 4459.50 | 0.0022 | 0.0018 |
| q87 | 10 | 22752.60 | 18200.10 | 0.0091 | 0.0073 |
| q88 | 10 | 73224.00 | 58584.00 | 0.0293 | 0.0234 |
| q89 | 10 | 7280.00 | 5824.30 | 0.0029 | 0.0023 |
| q90 | 10 | 18276.00 | 14616.00 | 0.0073 | 0.0058 |
| q91 | 10 | 7011.80 | 5604.70 | 0.0028 | 0.0022 |
| q92 | 10 | 10479.70 | 8380.40 | 0.0042 | 0.0034 |
| q93 | 10 | 19155.00 | 15325.00 | 0.0077 | 0.0061 |
| q94 | 10 | 29158.00 | 23324.00 | 0.0117 | 0.0093 |
| q95 | 10 | 56518.00 | 45212.00 | 0.0226 | 0.0181 |
| q96 | 10 | 9153.00 | 7323.00 | 0.0037 | 0.0029 |
| q97 | 10 | 13378.40 | 10704.00 | 0.0054 | 0.0043 |
| q98 | 10 | 6864.20 | 5492.20 | 0.0027 | 0.0022 |
| q99 | 10 | 9210.00 | 7365.00 | 0.0037 | 0.0029 |