You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "hello-stephen (via GitHub)" <gi...@apache.org> on 2024/01/24 02:45:36 UTC
[PR] [fix](ci) add single quote to the value of the session variables when… [doris]
hello-stephen opened a new pull request, #30295:
URL: https://github.com/apache/doris/pull/30295
… setting it
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907562333
run pipelinex_p0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907299826
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 8abd5faf03f45b16a09242fa6313ae68bd050225 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 14.7 seconds inserted 10000000 Rows, about 680K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907565733
run p1
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907286807
<details>
<summary>TPC-H: <b>Total hot run time: 39178 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 8abd5faf03f45b16a09242fa6313ae68bd050225, data reload: false
------ Round 1 ----------------------------------
q1 18963 5371 5405 5371
q2 2602 151 139 139
q3 11116 1204 1138 1138
q4 10552 767 757 757
q5 7790 3229 3225 3225
q6 209 122 117 117
q7 876 519 483 483
q8 9272 1921 1944 1921
q9 7311 6398 6361 6361
q10 8207 3101 3086 3086
q11 409 212 215 212
q12 350 194 186 186
q13 17987 3374 3314 3314
q14 250 219 216 216
q15 548 507 503 503
q16 430 376 358 358
q17 943 552 473 473
q18 7520 7159 6897 6897
q19 1550 1378 1430 1378
q20 604 314 313 313
q21 2771 2454 2422 2422
q22 346 319 308 308
Total cold run time: 110606 ms
Total hot run time: 39178 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5554 5264 5145 5145
q2 332 217 213 213
q3 3364 3287 3242 3242
q4 2087 2047 2091 2047
q5 5937 5896 5771 5771
q6 198 116 117 116
q7 2237 1922 1879 1879
q8 3213 3399 3388 3388
q9 8955 8778 8797 8778
q10 3980 3874 3875 3874
q11 570 454 460 454
q12 811 625 631 625
q13 16938 3157 3116 3116
q14 286 245 286 245
q15 555 503 514 503
q16 525 464 484 464
q17 1885 1816 1865 1816
q18 9594 16550 9574 9574
q19 21021 1525 1522 1522
q20 4613 1961 1939 1939
q21 14605 5358 5328 5328
q22 1020 556 547 547
Total cold run time: 108280 ms
Total hot run time: 60586 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907779634
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907768557
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907260640
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.
zhangstar333 merged PR #30295:
URL: https://github.com/apache/doris/pull/30295
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907294834
<details>
<summary>TPC-DS: <b>Total hot run time: 187842 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 8abd5faf03f45b16a09242fa6313ae68bd050225, data reload: false
query1 925 339 329 329
query2 6566 2019 1895 1895
query3 6701 206 205 205
query4 29614 22099 22299 22099
query5 4459 377 371 371
query6 265 153 150 150
query7 4607 267 273 267
query8 220 172 190 172
query9 8321 2558 2512 2512
query10 412 219 219 219
query11 16605 15598 15655 15598
query12 121 70 65 65
query13 1669 380 370 370
query14 10592 6992 6969 6969
query15 227 185 184 184
query16 5788 259 253 253
query17 949 488 476 476
query18 1794 266 248 248
query19 182 134 129 129
query20 74 69 70 69
query21 185 140 133 133
query22 5067 5024 5065 5024
query23 31682 30929 30857 30857
query24 12433 2802 2766 2766
query25 581 319 324 319
query26 1778 141 143 141
query27 3228 285 288 285
query28 7059 1835 1817 1817
query29 1900 630 623 623
query30 283 136 136 136
query31 940 737 744 737
query32 90 54 51 51
query33 710 215 212 212
query34 1127 467 477 467
query35 863 774 765 765
query36 1347 1291 1185 1185
query37 89 56 62 56
query38 3389 3278 3280 3278
query39 1313 1279 1285 1279
query40 346 87 83 83
query41 37 35 34 34
query42 86 80 83 80
query43 542 506 465 465
query44 1057 689 693 689
query45 189 178 175 175
query46 1084 656 670 656
query47 1598 1552 1568 1552
query48 390 320 317 317
query49 1187 292 288 288
query50 679 313 315 313
query51 5342 5257 5242 5242
query52 87 76 78 76
query53 318 272 250 250
query54 241 187 179 179
query55 86 77 78 77
query56 175 170 164 164
query57 1026 941 930 930
query58 183 153 157 153
query59 2996 2845 2671 2671
query60 208 191 182 182
query61 81 89 85 85
query62 622 362 367 362
query63 283 269 269 269
query64 6117 1785 1743 1743
query65 3355 3261 3246 3246
query66 1320 318 313 313
query67 15910 15346 15680 15346
query68 10450 537 516 516
query69 596 314 312 312
query70 1744 1552 1480 1480
query71 10462 10196 10196 10196
query72 4366 2894 2862 2862
query73 1906 318 313 313
query74 6952 6399 6396 6396
query75 4590 2353 2276 2276
query76 6525 1074 1072 1072
query77 633 234 232 232
query78 9071 8910 8893 8893
query79 995 493 505 493
query80 534 320 315 315
query81 439 209 200 200
query82 173 83 79 79
query83 142 119 115 115
query84 274 69 70 69
query85 1131 330 347 330
query86 395 424 391 391
query87 3516 3360 3381 3360
query88 2726 2212 2198 2198
query89 444 361 374 361
query90 1993 189 185 185
query91 158 137 125 125
query92 54 45 44 44
query93 956 460 449 449
query94 1131 162 161 161
query95 500 460 450 450
query96 606 318 316 316
query97 4284 4103 4153 4103
query98 207 194 181 181
query99 1069 718 718 718
Total cold run time: 298722 ms
Total hot run time: 187842 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](ci) add single quote to the value of the session variables when… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30295:
URL: https://github.com/apache/doris/pull/30295#issuecomment-1907298068
<details>
<summary>ClickBench: <b>Total hot run time: 31.01 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 8abd5faf03f45b16a09242fa6313ae68bd050225, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.03 0.02
query3 0.22 0.05 0.05
query4 1.70 0.08 0.07
query5 0.53 0.52 0.52
query6 1.31 0.63 0.64
query7 0.02 0.01 0.01
query8 0.04 0.02 0.03
query9 0.55 0.51 0.49
query10 0.54 0.54 0.55
query11 0.12 0.09 0.09
query12 0.11 0.10 0.09
query13 0.61 0.62 0.62
query14 0.79 0.79 0.79
query15 0.80 0.77 0.78
query16 0.36 0.38 0.40
query17 0.98 1.04 1.02
query18 0.22 0.26 0.25
query19 1.79 1.79 1.72
query20 0.01 0.00 0.01
query21 15.40 0.57 0.60
query22 2.68 2.79 2.21
query23 17.19 0.87 0.66
query24 3.10 1.39 0.82
query25 0.40 0.24 0.24
query26 0.51 0.15 0.14
query27 0.05 0.05 0.05
query28 10.82 0.77 0.75
query29 12.49 3.10 3.18
query30 0.55 0.51 0.50
query31 2.78 0.35 0.37
query32 3.40 0.47 0.48
query33 3.21 3.23 3.26
query34 15.72 4.26 4.25
query35 4.32 4.24 4.27
query36 1.14 1.07 1.07
query37 0.06 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.02 0.01
query40 0.16 0.13 0.14
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.94 s
Total hot run time: 31.01 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org