Skip to content

[GLUTEN-1632][CH]Daily Update Clickhouse Version (20250215)#8735

Merged
baibaichen merged 3 commits intoapache:mainfrom
Kyligence:rebase_ch/20250215
Feb 15, 2025
Merged

[GLUTEN-1632][CH]Daily Update Clickhouse Version (20250215)#8735
baibaichen merged 3 commits intoapache:mainfrom
Kyligence:rebase_ch/20250215

Conversation

@kyligence-git
Copy link
Copy Markdown
Contributor

@kyligence-git kyligence-git commented Feb 14, 2025

Auto commit by gluten daily build, please check the build status and merge it if it's green.

@github-actions
Copy link
Copy Markdown

github-actions bot commented Feb 14, 2025

#1632

@github-actions
Copy link
Copy Markdown

github-actions bot commented Feb 14, 2025

Run Gluten Clickhouse CI on x86

@github-actions
Copy link
Copy Markdown

github-actions bot commented Feb 15, 2025

Run Gluten Clickhouse CI on x86

@github-actions
Copy link
Copy Markdown

github-actions bot commented Feb 15, 2025

Run Gluten Clickhouse CI on x86

@baibaichen baibaichen merged commit 89699ef into apache:main Feb 15, 2025
7 checks passed
@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Feb 15, 2025

===== Performance report for TPCDS SF2000 with Velox backend, for reference only ====

query log/native_master_02_15_2025_time.csv log/native_master_02_14_2025_eac27853d5_time.csv difference percentage
q1 11.96 13.04 1.072 108.96%
q2 11.70 10.71 -0.989 91.55%
q3 3.00 3.26 0.257 108.57%
q4 52.10 51.69 -0.407 99.22%
q5 9.60 7.83 -1.764 81.62%
q6 4.90 3.84 -1.063 78.32%
q7 4.77 4.72 -0.050 98.95%
q8 3.83 5.61 1.776 146.35%
q9 16.13 13.02 -3.114 80.70%
q10 13.78 12.01 -1.777 87.11%
q11 26.76 28.82 2.058 107.69%
q12 3.01 3.24 0.232 107.70%
q13 5.59 5.38 -0.208 96.27%
q14a 44.35 45.06 0.708 101.60%
q14b 39.20 40.76 1.557 103.97%
q15 3.62 2.43 -1.196 67.00%
q16 5.30 4.46 -0.841 84.14%
q17 5.75 6.22 0.470 108.17%
q18 8.48 9.10 0.616 107.27%
q19 3.78 4.04 0.260 106.87%
q20 2.01 1.50 -0.513 74.51%
q21 1.05 2.38 1.328 226.54%
q22 3.63 4.90 1.279 135.27%
q23a 61.99 61.82 -0.170 99.73%
q23b 73.32 72.56 -0.761 98.96%
q24a 73.44 69.03 -4.413 93.99%
q24b 68.88 68.49 -0.386 99.44%
q25 5.61 5.64 0.036 100.65%
q26 2.47 3.66 1.194 148.41%
q27 2.31 2.68 0.368 115.96%
q28 17.72 17.33 -0.392 97.79%
q29 7.55 7.49 -0.053 99.30%
q30 5.93 6.00 0.069 101.16%
q31 8.38 8.53 0.150 101.80%
q32 1.60 1.98 0.389 124.36%
q33 3.43 3.68 0.251 107.32%
q34 4.90 3.05 -1.855 62.16%
q35 6.73 6.95 0.220 103.27%
q36 3.15 2.67 -0.484 84.67%
q37 3.21 3.07 -0.139 95.67%
q38 11.53 11.89 0.363 103.15%
q39a 3.81 5.10 1.289 133.82%
q39b 3.37 4.14 0.773 122.94%
q40 3.65 3.68 0.028 100.75%
q41 1.40 0.62 -0.776 44.46%
q42 1.31 0.53 -0.783 40.41%
q43 1.95 2.16 0.211 110.81%
q44 5.67 6.12 0.445 107.85%
q45 2.96 3.92 0.955 132.22%
q46 4.27 3.92 -0.350 91.80%
q47 9.86 9.59 -0.275 97.21%
q48 4.04 3.36 -0.685 83.07%
q49 7.08 5.44 -1.637 76.87%
q50 17.27 16.90 -0.371 97.85%
q51 7.56 7.70 0.135 101.78%
q52 1.37 1.63 0.266 119.50%
q53 2.65 1.93 -0.716 72.97%
q54 5.68 5.60 -0.085 98.50%
q55 0.62 0.99 0.370 159.95%
q56 3.91 4.40 0.487 112.45%
q57 7.56 7.03 -0.525 93.05%
q58 2.65 2.33 -0.327 87.66%
q59 4.84 4.57 -0.275 94.31%
q60 4.45 4.77 0.324 107.28%
q61 5.03 4.99 -0.035 99.31%
q62 2.81 2.89 0.085 103.02%
q63 2.31 1.42 -0.892 61.43%
q64 37.27 37.21 -0.059 99.84%
q65 11.54 11.46 -0.074 99.36%
q66 3.47 3.28 -0.196 94.35%
q67 57.40 58.77 1.363 102.37%
q68 3.36 3.45 0.085 102.53%
q69 4.88 4.98 0.100 102.05%
q70 5.78 5.96 0.184 103.19%
q71 5.21 4.28 -0.925 82.23%
q72 20.79 20.25 -0.540 97.40%
q73 3.04 2.47 -0.569 81.31%
q74 17.12 17.59 0.468 102.73%
q75 23.50 24.70 1.196 105.09%
q76 6.60 7.07 0.462 106.99%
q77 2.80 2.77 -0.034 98.79%
q78 33.35 33.27 -0.086 99.74%
q79 4.03 3.63 -0.401 90.07%
q80 10.72 11.12 0.403 103.76%
q81 7.42 6.73 -0.687 90.73%
q82 5.39 6.06 0.669 112.41%
q83 1.31 1.95 0.636 148.55%
q84 4.02 2.49 -1.534 61.87%
q85 6.04 5.94 -0.104 98.29%
q86 2.06 2.27 0.214 110.43%
q87 12.08 12.07 -0.005 99.96%
q88 15.30 15.65 0.346 102.26%
q89 1.96 2.38 0.422 121.54%
q90 2.32 2.44 0.121 105.20%
q91 3.83 3.88 0.052 101.35%
q92 1.83 2.04 0.216 111.84%
q93 24.53 24.14 -0.386 98.43%
q94 8.64 8.78 0.135 101.56%
q9 57.31 60.13 2.824 104.93%
q5 2.26 2.09 -0.167 92.58%
q96 10.53 10.80 0.268 102.54%
q97 3.08 2.25 -0.829 73.11%
q98 5.55 5.40 -0.150 97.30%
q99 0.38 0.46 0.084 122.05%
total 1191.24 1186.45 -4.784 99.60%

@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Feb 15, 2025

===== Performance report for TPCH SF2000 with Velox backend, for reference only ====

query log/native_master_02_15_2025_time.csv log/native_master_02_14_2025_eac27853d5_time.csv difference percentage
q1 25.26 24.83 -0.431 98.29%
q2 26.41 26.59 0.184 100.70%
q3 33.24 32.89 -0.345 98.96%
q4 27.49 28.02 0.520 101.89%
q5 59.98 61.97 1.986 103.31%
q6 9.51 10.13 0.622 106.54%
q7 39.02 38.82 -0.198 99.49%
q8 60.21 63.12 2.914 104.84%
q9 103.07 105.30 2.229 102.16%
q10 45.07 45.25 0.180 100.40%
q11 17.03 19.59 2.565 115.06%
q12 17.26 16.96 -0.297 98.28%
q13 26.62 25.71 -0.904 96.60%
q14 11.78 13.00 1.226 110.41%
q15 28.30 27.83 -0.479 98.31%
q16 13.08 13.54 0.459 103.51%
q17 76.80 79.25 2.448 103.19%
q18 120.84 122.77 1.935 101.60%
q19 17.44 18.37 0.933 105.35%
q20 26.24 25.95 -0.281 98.93%
q21 187.84 191.82 3.980 102.12%
q22 10.87 10.40 -0.471 95.67%
total 983.36 1002.13 18.776 101.91%

@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Feb 16, 2025

===== Performance report for TPCDS SF2000 with Velox backend, for reference only ====

query log/native_master_02_16_2025_time.csv log/native_master_02_15_2025_89699ef56f_time.csv difference percentage
q1 10.67 11.96 1.292 112.10%
q2 11.79 11.70 -0.088 99.25%
q3 4.67 3.00 -1.667 64.30%
q4 52.56 52.10 -0.468 99.11%
q5 8.50 9.60 1.098 112.92%
q6 5.12 4.90 -0.214 95.81%
q7 4.91 4.77 -0.148 96.98%
q8 4.49 3.83 -0.661 85.29%
q9 14.03 16.13 2.099 114.96%
q10 12.27 13.78 1.513 112.33%
q11 28.13 26.76 -1.369 95.13%
q12 2.13 3.01 0.883 141.51%
q13 5.88 5.59 -0.298 94.93%
q14a 45.12 44.35 -0.776 98.28%
q14b 40.88 39.20 -1.683 95.88%
q15 2.53 3.62 1.088 142.93%
q16 4.65 5.30 0.650 113.96%
q17 6.48 5.75 -0.726 88.80%
q18 8.14 8.48 0.340 104.18%
q19 3.96 3.78 -0.183 95.39%
q20 1.54 2.01 0.473 130.78%
q21 1.94 1.05 -0.896 53.95%
q22 2.89 3.63 0.739 125.61%
q23a 61.35 61.99 0.645 101.05%
q23b 72.52 73.32 0.799 101.10%
q24a 70.82 73.44 2.618 103.70%
q24b 64.87 68.88 4.003 106.17%
q25 5.01 5.61 0.597 111.91%
q26 2.66 2.47 -0.197 92.61%
q27 2.53 2.31 -0.219 91.32%
q28 16.97 17.72 0.754 104.44%
q29 7.51 7.55 0.033 100.44%
q30 5.31 5.93 0.619 111.66%
q31 8.76 8.38 -0.381 95.65%
q32 1.71 1.60 -0.118 93.12%
q33 3.19 3.43 0.237 107.40%
q34 4.36 4.90 0.540 112.39%
q35 6.52 6.73 0.213 103.27%
q36 2.78 3.15 0.369 113.27%
q37 3.12 3.21 0.099 103.17%
q38 12.02 11.53 -0.494 95.89%
q39a 4.60 3.81 -0.787 82.88%
q39b 3.55 3.37 -0.183 94.84%
q40 3.55 3.65 0.103 102.90%
q41 0.62 1.40 0.780 226.24%
q42 0.53 1.31 0.781 246.82%
q43 2.57 1.95 -0.616 76.01%
q44 6.30 5.67 -0.626 90.06%
q45 4.46 2.96 -1.492 66.52%
q46 4.22 4.27 0.053 101.26%
q47 9.21 9.86 0.652 107.07%
q48 3.15 4.04 0.893 128.32%
q49 5.74 7.08 1.334 123.23%
q50 17.05 17.27 0.222 101.30%
q51 7.25 7.56 0.309 104.27%
q52 0.82 1.37 0.547 166.89%
q53 2.24 2.65 0.409 118.25%
q54 5.78 5.68 -0.098 98.31%
q55 0.84 0.62 -0.217 73.97%
q56 3.90 3.91 0.015 100.37%
q57 6.22 7.56 1.338 121.52%
q58 2.59 2.65 0.067 102.58%
q59 4.78 4.84 0.060 101.26%
q60 4.97 4.45 -0.524 89.47%
q61 4.48 5.03 0.547 112.21%
q62 3.05 2.81 -0.242 92.06%
q63 1.52 2.31 0.798 152.67%
q64 36.90 37.27 0.370 101.00%
q65 10.97 11.54 0.566 105.16%
q66 4.47 3.47 -0.994 77.74%
q67 58.59 57.40 -1.185 97.98%
q68 3.04 3.36 0.325 110.71%
q69 5.79 4.88 -0.917 84.17%
q70 5.75 5.78 0.028 100.49%
q71 5.02 5.21 0.183 103.63%
q72 22.31 20.79 -1.524 93.17%
q73 2.47 3.04 0.573 123.21%
q74 18.01 17.12 -0.888 95.07%
q75 22.69 23.50 0.813 103.58%
q76 6.68 6.60 -0.076 98.86%
q77 2.71 2.80 0.088 103.24%
q78 33.21 33.35 0.140 100.42%
q79 3.58 4.03 0.456 112.75%
q80 10.91 10.72 -0.197 98.20%
q81 7.28 7.42 0.137 101.89%
q82 5.43 5.39 -0.038 99.30%
q83 1.53 1.31 -0.219 85.66%
q84 2.64 4.02 1.382 152.31%
q85 6.21 6.04 -0.163 97.37%
q86 2.12 2.06 -0.066 96.91%
q87 11.52 12.08 0.557 104.84%
q88 15.47 15.30 -0.167 98.92%
q89 2.48 1.96 -0.523 78.93%
q90 2.55 2.32 -0.229 91.03%
q91 4.26 3.83 -0.427 89.97%
q92 1.65 1.83 0.178 110.76%
q93 25.61 24.53 -1.083 95.77%
q94 8.94 8.64 -0.300 96.65%
q9 60.87 57.31 -3.558 94.16%
q5 2.16 2.26 0.094 104.32%
q96 11.09 10.53 -0.556 94.98%
q97 2.10 3.08 0.987 147.08%
q98 5.51 5.55 0.037 100.67%
q99 1.08 0.38 -0.699 35.18%
total 1182.89 1191.24 8.346 100.71%

@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Feb 16, 2025

===== Performance report for TPCH SF2000 with Velox backend, for reference only ====

query log/native_master_02_16_2025_time.csv log/native_master_02_15_2025_89699ef56f_time.csv difference percentage
q1 25.58 25.26 -0.323 98.74%
q2 26.70 26.41 -0.291 98.91%
q3 33.05 33.24 0.189 100.57%
q4 27.54 27.49 -0.049 99.82%
q5 60.73 59.98 -0.745 98.77%
q6 10.45 9.51 -0.934 91.06%
q7 39.82 39.02 -0.802 97.99%
q8 62.05 60.21 -1.842 97.03%
q9 105.61 103.07 -2.538 97.60%
q10 46.07 45.07 -0.996 97.84%
q11 17.86 17.03 -0.836 95.32%
q12 17.47 17.26 -0.210 98.80%
q13 27.65 26.62 -1.029 96.28%
q14 13.47 11.78 -1.691 87.45%
q15 27.83 28.30 0.473 101.70%
q16 13.51 13.08 -0.438 96.76%
q17 81.59 76.80 -4.785 94.13%
q18 122.72 120.84 -1.882 98.47%
q19 16.91 17.44 0.525 103.10%
q20 25.75 26.24 0.487 101.89%
q21 191.12 187.84 -3.276 98.29%
q22 11.10 10.87 -0.222 98.00%
total 1004.58 983.36 -21.216 97.89%

kevinw66 pushed a commit to kevinw66/incubator-gluten that referenced this pull request Mar 3, 2025
@kyligence-git @baibaichen @kevinw66
[GLUTEN-1632][CH]Daily Update Clickhouse Version (20250215) (apache#8735
07f8b14 
)

* [GLUTEN-1632][CH]Daily Update Clickhouse Version (20250215)

* Fix build due to ClickHouse/ClickHouse#75938

* Fix Ut due to ClickHouse/ClickHouse#74827

---------

Co-authored-by: kyligence-git <[email protected]>
Co-authored-by: Chang Chen <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@baibaichen baibaichen baibaichen approved these changes

Assignees

No one assigned

Labels

CLICKHOUSE

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

3 participants

@kyligence-git @GlutenPerfBot @baibaichen