Skip to content

[GLUTEN-1632][CH]Daily Update Clickhouse Version (20241016)#7558

Merged
baibaichen merged 5 commits intoapache:mainfrom
Kyligence:rebase_ch/20241016
Oct 16, 2024
Merged

[GLUTEN-1632][CH]Daily Update Clickhouse Version (20241016)#7558
baibaichen merged 5 commits intoapache:mainfrom
Kyligence:rebase_ch/20241016

Conversation

@kyligence-git
Copy link
Contributor

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

@github-actions
Copy link

#1632

@github-actions
Copy link

Run Gluten Clickhouse CI

1 similar comment
@github-actions
Copy link

Run Gluten Clickhouse CI

kyligence-git and others added 5 commits October 16, 2024 16:43
@baibaichen
Copy link
Contributor

baibaichen commented Oct 16, 2024

@taiyang-li

After ClickHouse/ClickHouse#69481, there are 3 ut failed with input_format_orc_dictionary_as_low_cardinality = true, see below:
d40215654e1e69791a719e487c6f85d

As a workaround set it to false

@github-actions
Copy link

Run Gluten Clickhouse CI

1 similar comment
@github-actions
Copy link

Run Gluten Clickhouse CI

@baibaichen baibaichen merged commit 29375d1 into apache:main Oct 16, 2024
@GlutenPerfBot
Copy link
Contributor

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

query log/native_master_10_16_2024_time.csv log/native_master_10_15_2024_0bc6613bc1_time.csv difference percentage
q1 13.36 14.47 1.116 108.35%
q2 16.32 15.07 -1.250 92.34%
q3 4.57 5.11 0.540 111.83%
q4 70.52 72.46 1.939 102.75%
q5 9.79 9.89 0.103 101.05%
q6 3.62 4.06 0.435 112.01%
q7 8.48 8.11 -0.369 95.65%
q8 3.42 5.61 2.183 163.81%
q9 25.90 26.40 0.494 101.91%
q10 8.97 7.37 -1.597 82.19%
q11 37.30 37.46 0.162 100.43%
q12 1.34 1.38 0.040 102.98%
q13 6.38 6.43 0.049 100.77%
q14a 48.57 47.39 -1.181 97.57%
q14b 44.66 41.97 -2.693 93.97%
q15 2.47 2.21 -0.260 89.45%
q16 49.48 48.52 -0.956 98.07%
q17 4.73 4.81 0.078 101.65%
q18 6.85 6.56 -0.292 95.74%
q19 2.24 3.40 1.165 152.02%
q20 1.58 1.54 -0.038 97.58%
q21 1.17 3.11 1.946 266.81%
q22 7.76 7.99 0.223 102.87%
q23a 107.32 103.88 -3.443 96.79%
q23b 127.38 126.49 -0.891 99.30%
q24a 115.02 104.94 -10.076 91.24%
q24b 113.47 111.12 -2.354 97.93%
q25 5.71 4.22 -1.491 73.90%
q26 4.35 4.36 0.014 100.32%
q27 4.98 5.55 0.569 111.42%
q28 34.01 31.95 -2.052 93.97%
q29 9.08 12.08 2.998 133.01%
q30 4.76 5.27 0.511 110.74%
q31 6.55 6.84 0.297 104.53%
q32 1.23 1.22 -0.015 98.76%
q33 4.08 4.82 0.740 118.14%
q34 4.01 3.79 -0.224 94.42%
q35 7.89 7.75 -0.144 98.17%
q36 6.16 5.47 -0.695 88.72%
q37 5.07 4.90 -0.171 96.63%
q38 14.19 13.64 -0.547 96.14%
q39a 3.14 3.65 0.515 116.41%
q39b 2.97 3.37 0.396 113.32%
q40 3.87 3.85 -0.014 99.63%
q41 0.58 0.65 0.073 112.55%
q42 0.88 0.91 0.030 103.41%
q43 4.54 4.59 0.050 101.11%
q44 8.62 9.92 1.297 115.05%
q45 3.27 3.29 0.014 100.43%
q46 3.85 3.96 0.109 102.83%
q47 18.27 17.83 -0.443 97.58%
q48 5.17 5.16 -0.002 99.96%
q49 6.81 7.05 0.232 103.40%
q50 21.07 21.86 0.781 103.71%
q51 9.33 9.29 -0.046 99.50%
q52 1.04 1.06 0.020 101.92%
q53 2.27 2.44 0.173 107.62%
q54 3.68 3.76 0.079 102.14%
q55 1.01 1.05 0.041 104.10%
q56 4.05 4.03 -0.019 99.53%
q57 10.92 10.35 -0.567 94.81%
q58 2.50 2.55 0.049 101.97%
q59 10.58 10.94 0.359 103.40%
q60 4.13 4.01 -0.126 96.95%
q61 4.06 4.71 0.650 115.98%
q62 5.17 5.24 0.070 101.36%
q63 2.38 2.41 0.033 101.39%
q64 63.21 59.72 -3.492 94.48%
q65 17.45 16.64 -0.809 95.37%
q66 4.68 4.45 -0.238 94.92%
q67 423.89 439.01 15.123 103.57%
q68 3.85 3.86 0.006 100.17%
q69 5.51 7.49 1.984 136.01%
q70 12.44 11.78 -0.661 94.68%
q71 2.42 2.54 0.120 104.94%
q72 215.07 214.35 -0.722 99.66%
q73 2.45 2.27 -0.180 92.66%
q74 23.16 22.72 -0.434 98.13%
q75 27.61 27.86 0.256 100.93%
q76 13.50 14.24 0.741 105.48%
q77 2.04 2.09 0.051 102.51%
q78 49.30 49.36 0.064 100.13%
q79 3.88 3.82 -0.053 98.64%
q80 11.38 11.52 0.143 101.26%
q81 4.61 4.59 -0.020 99.57%
q82 6.86 6.92 0.058 100.84%
q83 1.55 1.61 0.058 103.73%
q84 2.83 3.52 0.688 124.32%
q85 7.08 7.82 0.741 110.46%
q86 4.35 4.26 -0.090 97.94%
q87 14.81 16.65 1.839 112.42%
q88 18.82 18.07 -0.747 96.03%
q89 3.60 3.63 0.036 101.00%
q90 2.97 2.88 -0.090 96.99%
q91 2.48 2.46 -0.028 98.88%
q92 1.34 1.42 0.078 105.80%
q93 42.21 41.62 -0.584 98.62%
q94 26.70 27.17 0.474 101.78%
q9 90.51 90.20 -0.304 99.66%
q5 2.78 2.54 -0.238 91.44%
q96 17.97 18.36 0.390 102.17%
q97 1.93 2.02 0.090 104.65%
q98 10.85 11.55 0.698 106.44%
q99 10.85 11.55 0.698 106.44%
total 2244.99 2248.56 3.564 100.16%

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants