TPC-DS测试结果
本测试主要包括使用存算一体和存算分离两种部署架构下，TPC-DS 1T规模数据集的开箱查询性能，共99个查询。存算一体查询总耗时为622.21s，存算分离查询总耗时为645.42s。详细结果见下表。
| TPC-DS查询 | 8.3.0 | 9.1.0.210 | |
|---|---|---|---|
| - | 存算一体（s） | 存算一体（s） | 存算分离（s） |
| Q1 | 2.03 | 0.513 | 0.546 |
| Q2 | 9.14 | 4.036 | 4.286 |
| Q3 | 1.52 | 1.228 | 1.426 |
| Q4 | 200.44 | 125.877 | 122.118 |
| Q5 | 3.11 | 1.403 | 1.509 |
| Q6 | 0.39 | 0.399 | 0.366 |
| Q7 | 1.85 | 1.665 | 2.227 |
| Q8 | 0.72 | 0.481 | 0.483 |
| Q9 | 11.14 | 13.604 | 12.354 |
| Q10 | 1.08 | 0.711 | 0.876 |
| Q11 | 92.20 | 62.143 | 63.736 |
| Q12 | 0.20 | 0.131 | 0.132 |
| Q13 | 2.50 | 3.502 | 3.853 |
| Q14 | 74.98 | 17.622 | 18.407 |
| Q15 | 2.11 | 0.412 | 0.434 |
| Q16 | 6.51 | 3.148 | 3.256 |
| Q17 | 2.93 | 1.168 | 2.618 |
| Q18 | 2.16 | 1.191 | 1.443 |
| Q19 | 0.70 | 0.665 | 0.771 |
| Q20 | 0.18 | 0.108 | 0.086 |
| Q21 | 0.18 | 0.084 | 0.084 |
| Q22 | 5.84 | 1.089 | 1.286 |
| Q23 | 144.71 | 85.005 | 90.962 |
| Q24 | 8.55 | 9.033 | 9.438 |
| Q25 | 3.10 | 1.262 | 2.580 |
| Q26 | 0.63 | 0.449 | 0.516 |
| Q27 | 2.03 | 1.739 | 2.219 |
| Q28 | 13.32 | 6.293 | 6.623 |
| Q29 | 2.50 | 2.049 | 2.364 |
| Q30 | 0.73 | 0.404 | 0.402 |
| Q31 | 3.73 | 3.045 | 2.902 |
| Q32 | 0.18 | 0.089 | 0.096 |
| Q33 | 1.28 | 0.821 | 0.815 |
| Q34 | 2.13 | 2.653 | 3.011 |
| Q35 | 3.00 | 2.132 | 1.743 |
| Q36 | 6.21 | 1.766 | 1.971 |
| Q37 | 0.34 | 0.231 | 0.268 |
| Q38 | 52.24 | 10.150 | 11.110 |
| Q39 | 5.57 | 5.057 | 5.475 |
| Q40 | 0.66 | 0.128 | 0.126 |
| Q41 | 0.04 | 0.036 | 0.033 |
| Q42 | 0.70 | 0.389 | 0.436 |
| Q43 | 1.99 | 1.256 | 1.410 |
| Q44 | 3.25 | 2.218 | 2.381 |
| Q45 | 0.82 | 0.399 | 0.404 |
| Q46 | 4.63 | 3.569 | 4.154 |
| Q47 | 6.91 | 4.542 | 5.156 |
| Q48 | 2.37 | 3.129 | 3.508 |
| Q49 | 3.01 | 2.291 | 2.478 |
| Q50 | 5.82 | 3.694 | 4.204 |
| Q51 | 10.67 | 4.368 | 4.630 |
| Q52 | 0.70 | 0.384 | 0.457 |
| Q53 | 0.88 | 0.715 | 0.794 |
| Q54 | 3.96 | 0.609 | 4.123 |
| Q55 | 0.66 | 0.402 | 0.421 |
| Q56 | 0.84 | 0.751 | 0.707 |
| Q57 | 3.12 | 1.643 | 1.826 |
| Q58 | 0.76 | 0.548 | 0.449 |
| Q59 | 17.30 | 8.824 | 9.302 |
| Q60 | 1.75 | 0.920 | 0.988 |
| Q61 | 1.10 | 0.980 | 1.013 |
| Q62 | 1.29 | 0.813 | 0.779 |
| Q63 | 0.86 | 0.697 | 0.799 |
| Q64 | 14.20 | 6.504 | 7.643 |
| Q65 | 6.92 | 3.988 | 3.630 |
| Q66 | 1.50 | 1.018 | 1.077 |
| Q67 | 153.90 | 54.645 | 56.221 |
| Q68 | 3.65 | 2.764 | 3.395 |
| Q69 | 0.93 | 0.720 | 0.689 |
| Q70 | 23.13 | 3.016 | 3.255 |
| Q71 | 2.33 | 2.211 | 2.196 |
| Q72 | 3.69 | 2.270 | 2.521 |
| Q73 | 1.40 | 1.743 | 2.068 |
| Q74 | 37.27 | 34.956 | 29.475 |
| Q75 | 11.85 | 5.517 | 5.769 |
| Q76 | 3.37 | 2.364 | 2.730 |
| Q77 | 1.30 | 1.112 | 1.141 |
| Q78 | 152.21 | 12.058 | 14.874 |
| Q79 | 4.49 | 3.766 | 4.449 |
| Q80 | 3.56 | 1.696 | 1.770 |
| Q81 | 0.64 | 0.390 | 0.409 |
| Q82 | 0.75 | 0.655 | 0.735 |
| Q83 | 0.15 | 0.085 | 0.216 |
| Q84 | 0.24 | 0.221 | 0.234 |
| Q85 | 2.78 | 1.151 | 1.512 |
| Q86 | 2.59 | 0.345 | 0.364 |
| Q87 | 78.17 | 10.557 | 11.300 |
| Q88 | 6.90 | 9.081 | 9.688 |
| Q89 | 2.61 | 0.918 | 1.058 |
| Q90 | 0.64 | 0.569 | 0.787 |
| Q91 | 0.15 | 0.135 | 0.114 |
| Q92 | 0.20 | 0.118 | 0.127 |
| Q93 | 7.53 | 3.977 | 4.413 |
| Q94 | 3.49 | 1.746 | 2.109 |
| Q95 | 29.57 | 27.629 | 25.971 |
| Q96 | 1.49 | 1.844 | 2.062 |
| Q97 | 8.49 | 3.341 | 3.674 |
| Q98 | 1.09 | 0.938 | 0.865 |
| Q99 | 2.37 | 1.503 | 1.516 |
| SUM | 1321.757 | 645.424 | 622.214 |
