Skip to content

[GLUTEN-1632][CH]Daily Update Clickhouse Version (20240928)#7379

Merged
baibaichen merged 3 commits intoapache:mainfrom
Kyligence:rebase_ch/20240928
Sep 28, 2024
Merged

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

Conversation

@kyligence-git
Copy link
Copy Markdown
Contributor

@kyligence-git kyligence-git commented Sep 28, 2024

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 Sep 28, 2024

#1632

@github-actions
Copy link
Copy Markdown

github-actions bot commented Sep 28, 2024

Run Gluten Clickhouse CI

@github-actions
Copy link
Copy Markdown

github-actions bot commented Sep 28, 2024

Run Gluten Clickhouse CI

@baibaichen
Copy link
Copy Markdown
Contributor

baibaichen commented Sep 28, 2024 •
edited
Loading

  1. Rebase failed with Allow empty needle in function replace ClickHouse/ClickHouse#69918 and hence remove Fix replace pattern data is null Kyligence/ClickHouse#493, [GLUTEN-5959] Fix function replace report an error with null value #5960 is OK

@baibaichen baibaichen merged commit e29946d into apache:main Sep 28, 2024
@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Sep 28, 2024

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

query log/native_master_09_28_2024_time.csv log/native_master_09_27_2024_b9fbb4702b_time.csv difference percentage
q1 13.86 14.11 0.248 101.79%
q2 14.65 15.15 0.499 103.40%
q3 5.25 5.51 0.264 105.03%
q4 72.27 71.71 -0.551 99.24%
q5 10.50 10.05 -0.457 95.65%
q6 2.34 2.34 -0.006 99.75%
q7 8.16 7.73 -0.435 94.67%
q8 3.41 5.79 2.382 169.91%
q9 24.33 25.07 0.746 103.07%
q10 8.51 9.09 0.590 106.93%
q11 36.24 36.66 0.422 101.16%
q12 1.39 1.45 0.061 104.37%
q13 6.29 6.28 -0.005 99.91%
q14a 47.23 48.85 1.620 103.43%
q14b 42.33 40.87 -1.461 96.55%
q15 2.50 2.39 -0.110 95.58%
q16 47.41 47.42 0.008 100.02%
q17 4.81 4.59 -0.212 95.58%
q18 6.74 6.95 0.203 103.01%
q19 2.05 2.19 0.136 106.60%
q20 1.43 1.49 0.060 104.18%
q21 1.10 1.12 0.017 101.53%
q22 7.88 8.11 0.230 102.92%
q23a 103.35 104.64 1.295 101.25%
q23b 124.87 128.70 3.825 103.06%
q24a 111.35 105.10 -6.258 94.38%
q24b 117.79 115.64 -2.148 98.18%
q25 4.08 4.35 0.273 106.69%
q26 3.84 4.09 0.242 106.30%
q27 4.64 4.76 0.123 102.66%
q28 31.68 32.61 0.937 102.96%
q29 10.91 12.36 1.446 113.25%
q30 4.85 5.05 0.203 104.19%
q31 7.00 7.19 0.195 102.78%
q32 1.38 1.19 -0.188 86.34%
q33 4.85 4.11 -0.747 84.62%
q34 4.00 3.79 -0.217 94.58%
q35 8.44 7.97 -0.471 94.42%
q36 5.63 5.52 -0.103 98.16%
q37 5.06 4.80 -0.259 94.88%
q38 13.51 14.61 1.103 108.17%
q39a 3.04 3.52 0.486 115.99%
q39b 2.92 3.13 0.208 107.12%
q40 4.26 4.04 -0.220 94.83%
q41 0.75 0.65 -0.100 86.58%
q42 0.99 0.98 -0.009 99.13%
q43 5.09 4.55 -0.543 89.34%
q44 11.22 9.33 -1.899 83.08%
q45 3.45 3.28 -0.170 95.07%
q46 3.87 3.70 -0.173 95.54%
q47 18.37 17.61 -0.753 95.90%
q48 5.04 4.85 -0.193 96.18%
q49 7.97 7.10 -0.870 89.09%
q50 25.07 21.55 -3.520 85.96%
q51 10.84 9.90 -0.938 91.35%
q52 1.03 0.95 -0.079 92.29%
q53 2.11 2.08 -0.030 98.59%
q54 3.69 3.57 -0.114 96.90%
q55 1.00 0.93 -0.069 93.12%
q56 4.06 4.06 0.002 100.04%
q57 10.76 10.38 -0.380 96.47%
q58 2.50 2.51 0.011 100.44%
q59 11.48 11.66 0.175 101.52%
q60 4.21 4.00 -0.212 94.96%
q61 4.14 4.03 -0.108 97.40%
q62 4.24 4.49 0.243 105.73%
q63 2.20 2.20 0.007 100.33%
q64 61.11 64.14 3.028 104.96%
q65 16.88 17.48 0.600 103.55%
q66 4.71 4.11 -0.601 87.25%
q67 419.95 430.85 10.909 102.60%
q68 3.78 3.66 -0.126 96.67%
q69 5.62 7.82 2.206 139.28%
q70 11.49 11.25 -0.242 97.90%
q71 2.42 2.59 0.171 107.05%
q72 218.61 214.67 -3.941 98.20%
q73 2.43 2.33 -0.094 96.11%
q74 24.30 22.38 -1.919 92.10%
q75 26.42 26.37 -0.052 99.80%
q76 13.51 13.45 -0.065 99.52%
q77 2.17 2.22 0.058 102.66%
q78 49.08 49.90 0.815 101.66%
q79 3.99 3.85 -0.147 96.32%
q80 11.42 11.25 -0.165 98.55%
q81 4.59 4.40 -0.191 95.84%
q82 6.69 7.01 0.324 104.84%
q83 1.55 1.53 -0.024 98.47%
q84 2.62 2.66 0.042 101.59%
q85 8.20 7.52 -0.687 91.62%
q86 4.25 4.14 -0.105 97.54%
q87 15.47 15.59 0.112 100.72%
q88 17.31 17.27 -0.032 99.81%
q89 3.41 3.84 0.436 112.78%
q90 2.80 2.79 -0.017 99.39%
q91 2.44 2.41 -0.033 98.67%
q92 1.31 1.34 0.025 101.94%
q93 39.77 41.01 1.249 103.14%
q94 25.45 27.12 1.671 106.57%
q9 88.63 88.65 0.017 100.02%
q5 2.81 2.80 -0.012 99.56%
q96 17.70 17.91 0.202 101.14%
q97 2.00 2.06 0.063 103.15%
q98 11.52 10.25 -1.267 89.01%
q99 11.52 10.25 -1.267 89.01%
total 2228.58 2235.03 6.456 100.29%

@GlutenPerfBot
Copy link
Copy Markdown
Contributor

GlutenPerfBot commented Sep 28, 2024

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

query log/native_master_09_28_2024_time.csv log/native_master_09_27_2024_b9fbb4702b_time.csv difference percentage
q1 53.41 53.31 -0.093 99.83%
q2 30.46 29.85 -0.607 98.01%
q3 54.44 51.56 -2.876 94.72%
q4 43.42 42.53 -0.892 97.95%
q5 103.95 106.60 2.649 102.55%
q6 11.57 13.00 1.435 112.40%
q7 113.35 112.36 -0.994 99.12%
q8 115.21 115.77 0.565 100.49%
q9 169.29 170.99 1.703 101.01%
q10 67.11 65.47 -1.640 97.56%
q11 27.00 26.83 -0.175 99.35%
q12 30.64 29.57 -1.078 96.48%
q13 52.47 52.16 -0.302 99.42%
q14 25.32 20.55 -4.771 81.16%
q15 50.73 51.58 0.846 101.67%
q16 18.88 16.52 -2.352 87.54%
q17 124.19 123.31 -0.877 99.29%
q18 200.10 199.84 -0.258 99.87%
q19 30.94 27.00 -3.938 87.27%
q20 42.94 40.61 -2.325 94.59%
q21 334.52 336.11 1.591 100.48%
q22 15.91 15.77 -0.142 99.11%
total 1715.83 1701.30 -14.531 99.15%

sharkdtu pushed a commit to sharkdtu/gluten that referenced this pull request Nov 11, 2024
@kyligence-git @baibaichen
[GLUTEN-1632][CH]Daily Update Clickhouse Version (20240928) (apache#7379
35a5186 
)

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

* Fix build due to ClickHouse/ClickHouse#65625

* Fix build due to ClickHouse/ClickHouse#68410

---------

Co-authored-by: kyligence-git <gluten@kyligence.io>
Co-authored-by: Chang Chen <baibaichen@gmail.com>
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 @baibaichen @GlutenPerfBot