You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zclllyybb (via GitHub)" <gi...@apache.org> on 2024/02/27 17:16:31 UTC
[PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]
zclllyybb opened a new pull request, #31498:
URL: https://github.com/apache/doris/pull/31498
## Proposed changes
Issue Number: close #xxx
before:
```
mysql> create table illegal(
-> k0 datetime(6) NOT null,
-> k1 datetime(6) NOT null
-> )
-> auto partition by range date_trunc(k0, k1, 'hour')
-> (
-> )
-> DISTRIBUTED BY HASH(`k0`) BUCKETS 2
-> properties("replication_num" = "1");
Query OK, 0 rows affected (0.15 sec)
```
now:
```
mysql> create table illegal( k0 datetime(6) NOT null, k1 datetime(6) NOT null ) auto partition by range date_trunc(k0, k1, 'hour') ( ) DISTRIBUTED BY HASH(`k0`) BUCKETS 2 properties("replication_num" = "1");
ERROR 1105 (HY000): errCode = 2, detailMessage = errCode = 2, detailMessage = partition expr date_trunc is illegal!
```
## 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1967303881
<details>
<summary>TPC-DS: <b>Total hot run time: 169277 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 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
query1 926 331 327 327
query2 6559 1696 1704 1696
query3 6698 216 210 210
query4 23519 20586 20526 20526
query5 4297 365 354 354
query6 256 177 172 172
query7 4603 298 294 294
query8 254 187 192 187
query9 8406 2234 2219 2219
query10 415 208 217 208
query11 14565 14163 14067 14067
query12 141 83 81 81
query13 1648 426 418 418
query14 8477 6729 6608 6608
query15 207 178 174 174
query16 7082 253 252 252
query17 1053 518 498 498
query18 1895 279 259 259
query19 191 143 148 143
query20 88 81 83 81
query21 199 130 113 113
query22 4768 4505 4553 4505
query23 30533 29864 29920 29864
query24 11981 3114 3060 3060
query25 645 349 355 349
query26 1855 152 155 152
query27 3031 313 321 313
query28 7036 1797 1768 1768
query29 1226 558 550 550
query30 285 133 137 133
query31 868 683 683 683
query32 97 60 59 59
query33 712 220 227 220
query34 1031 491 490 490
query35 866 736 749 736
query36 934 837 822 822
query37 266 61 62 61
query38 3074 2978 2975 2975
query39 1314 1260 1248 1248
query40 278 100 98 98
query41 37 36 35 35
query42 110 100 101 100
query43 464 424 465 424
query44 1078 688 703 688
query45 188 184 170 170
query46 1036 794 767 767
query47 1545 1481 1504 1481
query48 417 338 345 338
query49 1165 320 295 295
query50 768 370 379 370
query51 4371 4375 4305 4305
query52 99 90 96 90
query53 335 262 266 262
query54 295 222 221 221
query55 93 84 81 81
query56 224 202 196 196
query57 991 913 886 886
query58 210 196 199 196
query59 2159 2144 2041 2041
query60 238 225 210 210
query61 86 84 81 81
query62 592 360 323 323
query63 280 254 274 254
query64 6549 3036 3095 3036
query65 3216 3192 3196 3192
query66 1443 319 325 319
query67 14386 14179 14184 14179
query68 3864 546 567 546
query69 497 373 373 373
query70 1221 1158 1212 1158
query71 322 246 253 246
query72 5908 2816 2660 2660
query73 703 329 327 327
query74 6323 6043 6028 6028
query75 3032 2429 2417 2417
query76 2348 1031 1165 1031
query77 329 237 225 225
query78 8921 8440 8449 8440
query79 1582 517 515 515
query80 1109 360 366 360
query81 475 192 196 192
query82 954 86 84 84
query83 216 122 120 120
query84 274 80 80 80
query85 1312 353 340 340
query86 374 266 302 266
query87 3301 3087 3145 3087
query88 2746 2361 2320 2320
query89 385 343 328 328
query90 1914 172 169 169
query91 171 125 122 122
query92 57 46 50 46
query93 1270 496 490 490
query94 1287 181 178 178
query95 438 341 342 341
query96 579 266 267 266
query97 4227 4157 4165 4157
query98 214 194 190 190
query99 1067 697 662 662
Total cold run time: 262074 ms
Total hot run time: 169277 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970343377
<details>
<summary>TPC-DS: <b>Total hot run time: 169202 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 2379a640801bfcf80a749527d66547afd5a6c097, data reload: false
query1 925 354 336 336
query2 6518 1753 1710 1710
query3 6718 209 203 203
query4 23367 20783 20521 20521
query5 4313 362 368 362
query6 260 171 165 165
query7 4617 290 291 290
query8 247 191 199 191
query9 8517 2240 2231 2231
query10 423 221 213 213
query11 14729 14183 14118 14118
query12 137 83 85 83
query13 1645 424 433 424
query14 8345 6618 6257 6257
query15 208 172 185 172
query16 7104 259 259 259
query17 1031 519 508 508
query18 1897 290 269 269
query19 199 149 150 149
query20 88 81 80 80
query21 197 131 115 115
query22 4855 4658 4645 4645
query23 30514 29988 29935 29935
query24 11961 3081 3120 3081
query25 639 354 345 345
query26 1845 155 165 155
query27 3053 320 307 307
query28 7058 1833 1816 1816
query29 1224 561 554 554
query30 284 130 141 130
query31 852 672 689 672
query32 101 59 57 57
query33 716 213 221 213
query34 1058 486 487 486
query35 867 754 746 746
query36 920 908 890 890
query37 225 65 62 62
query38 3126 3019 3026 3019
query39 1306 1267 1247 1247
query40 278 105 96 96
query41 38 37 35 35
query42 101 97 97 97
query43 446 470 417 417
query44 1076 708 716 708
query45 192 173 167 167
query46 1026 778 767 767
query47 1473 1448 1456 1448
query48 421 346 339 339
query49 1179 299 293 293
query50 776 374 372 372
query51 4382 4250 4293 4250
query52 102 90 89 89
query53 330 270 267 267
query54 293 221 226 221
query55 87 84 79 79
query56 220 197 199 197
query57 955 918 883 883
query58 210 192 196 192
query59 2101 1967 2117 1967
query60 239 221 209 209
query61 86 87 86 86
query62 591 367 357 357
query63 297 265 264 264
query64 6586 2971 3117 2971
query65 3238 3235 3206 3206
query66 1442 330 327 327
query67 14238 14160 14076 14076
query68 5046 546 577 546
query69 531 392 370 370
query70 1246 1165 1136 1136
query71 394 248 246 246
query72 6224 2823 2667 2667
query73 706 316 316 316
query74 6244 5987 5950 5950
query75 3060 2465 2399 2399
query76 2853 1026 1150 1026
query77 339 238 227 227
query78 9085 8632 8579 8579
query79 980 533 534 533
query80 528 358 356 356
query81 454 196 196 196
query82 163 93 84 84
query83 140 123 119 119
query84 258 76 76 76
query85 1032 353 359 353
query86 294 288 298 288
query87 3269 3116 3083 3083
query88 2690 2284 2261 2261
query89 376 321 344 321
query90 1818 169 167 167
query91 153 126 125 125
query92 57 47 54 47
query93 1006 523 532 523
query94 1068 186 182 182
query95 448 348 346 346
query96 572 262 260 260
query97 4228 4152 4158 4152
query98 217 197 194 194
query99 1020 691 678 678
Total cold run time: 260991 ms
Total hot run time: 169202 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970347919
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969538894
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970371418
<details>
<summary>ClickBench: <b>Total hot run time: 31.57 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 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.02 0.03
query3 0.23 0.06 0.06
query4 1.67 0.10 0.10
query5 0.52 0.52 0.52
query6 1.29 0.68 0.68
query7 0.02 0.01 0.01
query8 0.03 0.02 0.02
query9 0.58 0.49 0.52
query10 0.56 0.56 0.56
query11 0.12 0.10 0.09
query12 0.13 0.10 0.10
query13 0.62 0.62 0.61
query14 0.79 0.79 0.81
query15 0.83 0.82 0.81
query16 0.37 0.38 0.37
query17 0.97 0.96 1.00
query18 0.25 0.25 0.26
query19 1.79 1.67 1.78
query20 0.01 0.02 0.02
query21 15.41 0.65 0.67
query22 3.22 4.58 2.01
query23 17.46 1.05 0.99
query24 2.15 0.74 0.12
query25 0.18 0.05 0.04
query26 0.15 0.14 0.14
query27 0.03 0.04 0.03
query28 12.38 0.83 0.81
query29 12.59 3.45 3.33
query30 0.60 0.52 0.53
query31 2.77 0.35 0.36
query32 3.36 0.47 0.48
query33 3.17 3.17 3.23
query34 15.37 4.73 4.75
query35 4.79 4.72 4.76
query36 1.14 1.06 1.07
query37 0.07 0.05 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.02
query40 0.17 0.15 0.13
query41 0.07 0.02 0.01
query42 0.03 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 106.07 s
Total hot run time: 31.57 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
Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970312667
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970334657
<details>
<summary>TPC-H: <b>Total hot run time: 38430 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 2379a640801bfcf80a749527d66547afd5a6c097, data reload: false
------ Round 1 ----------------------------------
q1 18352 4186 4167 4167
q2 2104 147 146 146
q3 11535 975 963 963
q4 4826 972 970 970
q5 8405 3029 3114 3029
q6 184 127 124 124
q7 1288 786 788 786
q8 9642 2053 2048 2048
q9 7238 6350 6304 6304
q10 8177 2505 2503 2503
q11 420 218 220 218
q12 781 324 317 317
q13 17938 3254 3221 3221
q14 280 244 254 244
q15 537 507 483 483
q16 466 402 426 402
q17 941 899 897 897
q18 6694 5947 6089 5947
q19 1576 1535 1514 1514
q20 553 281 270 270
q21 6621 3587 3617 3587
q22 791 290 291 290
Total cold run time: 109349 ms
Total hot run time: 38430 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4017 4005 4015 4005
q2 313 213 220 213
q3 2996 2920 2987 2920
q4 1854 1850 1868 1850
q5 5190 5078 5156 5078
q6 201 115 116 115
q7 2137 1786 1731 1731
q8 3157 3201 3224 3201
q9 8307 8299 8257 8257
q10 6202 3691 3680 3680
q11 510 434 425 425
q12 701 566 520 520
q13 3802 3100 3083 3083
q14 283 255 256 255
q15 536 493 489 489
q16 519 457 465 457
q17 1708 1696 1686 1686
q18 7764 7647 7399 7399
q19 1688 1648 1646 1646
q20 2092 1896 1886 1886
q21 4762 4614 4667 4614
q22 497 434 432 432
Total cold run time: 59236 ms
Total hot run time: 53942 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969615185
<details>
<summary>ClickBench: <b>Total hot run time: 32.78 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 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.02
query3 0.23 0.05 0.06
query4 1.66 0.10 0.10
query5 0.53 0.51 0.52
query6 1.26 0.67 0.68
query7 0.02 0.01 0.01
query8 0.03 0.03 0.03
query9 0.55 0.50 0.52
query10 0.57 0.58 0.56
query11 0.13 0.09 0.09
query12 0.11 0.10 0.10
query13 0.62 0.61 0.60
query14 0.79 0.80 0.80
query15 0.83 0.82 0.82
query16 0.38 0.38 0.37
query17 1.01 0.97 0.95
query18 0.26 0.25 0.26
query19 1.80 1.69 1.72
query20 0.01 0.01 0.02
query21 15.42 0.62 0.65
query22 3.09 3.61 3.07
query23 17.74 1.06 0.98
query24 2.27 0.44 0.39
query25 0.22 0.06 0.06
query26 0.17 0.14 0.14
query27 0.03 0.03 0.04
query28 12.12 0.84 0.83
query29 12.59 3.41 3.18
query30 0.55 0.56 0.53
query31 2.80 0.34 0.36
query32 3.35 0.48 0.47
query33 3.21 3.21 3.25
query34 15.34 4.75 4.74
query35 4.76 4.73 4.75
query36 1.15 1.06 1.06
query37 0.07 0.05 0.04
query38 0.04 0.03 0.02
query39 0.03 0.01 0.01
query40 0.17 0.13 0.14
query41 0.08 0.01 0.01
query42 0.02 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 106.15 s
Total hot run time: 32.78 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
Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970373606
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 868a461d21c92481867ab5ccd8644f728d5c01e3 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 18.0 seconds inserted 10000000 Rows, about 555K 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969167484
<details>
<summary>TPC-H: <b>Total hot run time: 37470 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 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
------ Round 1 ----------------------------------
q1 17748 3996 4014 3996
q2 2043 139 133 133
q3 10597 927 934 927
q4 4661 923 936 923
q5 7627 2855 2952 2855
q6 178 121 122 121
q7 1234 753 736 736
q8 9257 1971 2016 1971
q9 7201 6242 6260 6242
q10 8153 2475 2488 2475
q11 421 214 214 214
q12 765 306 314 306
q13 17922 3198 3217 3198
q14 273 253 252 252
q15 528 496 499 496
q16 488 408 405 405
q17 930 865 852 852
q18 6608 5949 5911 5911
q19 1566 1499 1499 1499
q20 541 266 266 266
q21 6312 3408 3546 3408
q22 803 284 286 284
Total cold run time: 105856 ms
Total hot run time: 37470 ms
----- Round 2, with runtime_filter_mode=off -----
q1 3985 3955 3968 3955
q2 305 225 214 214
q3 2955 2943 2953 2943
q4 1875 1800 1791 1791
q5 5126 5075 5085 5075
q6 197 115 116 115
q7 2135 1682 1737 1682
q8 3103 3173 3207 3173
q9 8210 8199 8209 8199
q10 6087 3632 3643 3632
q11 508 427 426 426
q12 682 528 520 520
q13 8970 3053 3039 3039
q14 268 250 254 250
q15 531 494 495 494
q16 499 448 469 448
q17 1696 1693 1668 1668
q18 7749 7527 7369 7369
q19 1636 1619 1625 1619
q20 2076 1887 1899 1887
q21 4802 4675 4581 4581
q22 496 425 432 425
Total cold run time: 63891 ms
Total hot run time: 53505 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969104167
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969202236
<details>
<summary>ClickBench: <b>Total hot run time: 32.29 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 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.03
query3 0.23 0.06 0.06
query4 1.68 0.10 0.10
query5 0.52 0.51 0.51
query6 1.29 0.68 0.68
query7 0.02 0.02 0.01
query8 0.03 0.03 0.03
query9 0.56 0.53 0.52
query10 0.57 0.59 0.57
query11 0.12 0.10 0.10
query12 0.13 0.10 0.10
query13 0.62 0.61 0.61
query14 0.78 0.81 0.82
query15 0.83 0.82 0.82
query16 0.38 0.36 0.36
query17 0.98 0.99 0.96
query18 0.27 0.25 0.26
query19 1.88 1.67 1.74
query20 0.01 0.00 0.01
query21 15.40 0.66 0.66
query22 3.55 3.82 2.50
query23 17.57 1.07 0.94
query24 2.18 0.35 0.58
query25 0.34 0.06 0.04
query26 0.17 0.14 0.13
query27 0.03 0.04 0.03
query28 12.09 0.83 0.83
query29 12.55 3.43 3.23
query30 0.60 0.53 0.53
query31 2.79 0.34 0.36
query32 3.35 0.47 0.48
query33 3.22 3.18 3.20
query34 15.35 4.77 4.78
query35 4.74 4.78 4.74
query36 1.14 1.07 1.07
query37 0.07 0.05 0.05
query38 0.04 0.02 0.03
query39 0.02 0.02 0.02
query40 0.17 0.13 0.15
query41 0.07 0.01 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.03
Total cold run time: 106.49 s
Total hot run time: 32.29 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
Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970359691
<details>
<summary>TPC-H: <b>Total hot run time: 37876 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 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
------ Round 1 ----------------------------------
q1 17636 4264 4036 4036
q2 2062 142 134 134
q3 10682 960 933 933
q4 4691 943 953 943
q5 7622 2859 3012 2859
q6 180 122 120 120
q7 1241 761 755 755
q8 9347 1995 2057 1995
q9 7143 6269 6298 6269
q10 8187 2500 2522 2500
q11 420 213 214 213
q12 754 316 306 306
q13 17954 3220 3198 3198
q14 282 249 256 249
q15 528 487 489 487
q16 464 393 420 393
q17 936 842 856 842
q18 6739 6022 6033 6022
q19 1574 1507 1510 1507
q20 537 278 263 263
q21 6692 3575 3575 3575
q22 795 277 288 277
Total cold run time: 106466 ms
Total hot run time: 37876 ms
----- Round 2, with runtime_filter_mode=off -----
q1 3996 4011 3998 3998
q2 306 228 210 210
q3 2982 2909 2960 2909
q4 1833 1798 1771 1771
q5 5134 5183 5126 5126
q6 198 114 114 114
q7 2137 1790 1725 1725
q8 3133 3197 3201 3197
q9 8313 8286 8238 8238
q10 6144 3670 3648 3648
q11 509 414 449 414
q12 674 538 527 527
q13 5037 3064 3042 3042
q14 285 260 250 250
q15 545 493 483 483
q16 503 465 460 460
q17 1705 1675 1688 1675
q18 7906 7585 7513 7513
q19 1638 1633 1628 1628
q20 2069 1908 1887 1887
q21 4766 4603 4640 4603
q22 510 443 461 443
Total cold run time: 60323 ms
Total hot run time: 53861 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1967312626
<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 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
query1 0.04 0.03 0.04
query2 0.06 0.02 0.03
query3 0.25 0.06 0.06
query4 1.65 0.10 0.09
query5 0.52 0.52 0.51
query6 1.31 0.67 0.68
query7 0.01 0.01 0.02
query8 0.03 0.02 0.02
query9 0.55 0.50 0.51
query10 0.57 0.57 0.57
query11 0.12 0.09 0.10
query12 0.12 0.11 0.10
query13 0.62 0.61 0.62
query14 0.80 0.81 0.82
query15 0.83 0.82 0.81
query16 0.37 0.37 0.37
query17 0.96 0.95 0.98
query18 0.25 0.24 0.25
query19 1.79 1.71 1.74
query20 0.01 0.01 0.01
query21 15.41 0.62 0.55
query22 3.07 3.16 1.35
query23 17.92 1.06 1.08
query24 2.00 0.76 0.12
query25 0.32 0.12 0.10
query26 0.16 0.15 0.16
query27 0.05 0.05 0.04
query28 12.25 0.84 0.86
query29 12.73 3.55 3.31
query30 0.58 0.58 0.54
query31 2.81 0.34 0.36
query32 3.34 0.48 0.48
query33 3.18 3.21 3.17
query34 15.33 4.73 4.75
query35 4.78 4.77 4.74
query36 1.13 1.07 1.07
query37 0.07 0.05 0.05
query38 0.04 0.03 0.02
query39 0.02 0.02 0.01
query40 0.16 0.12 0.13
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.33 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
Re: [PR] [fix](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1967220779
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969190734
<details>
<summary>TPC-DS: <b>Total hot run time: 169013 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 578da166d70da4fe17ef709a34b71b341f21b75b, data reload: false
query1 937 338 329 329
query2 6548 1635 1812 1635
query3 6696 209 206 206
query4 23586 20939 20675 20675
query5 4266 358 349 349
query6 272 184 173 173
query7 5722 314 308 308
query8 1012 197 203 197
query9 9030 2287 2256 2256
query10 415 222 217 217
query11 14675 14244 14158 14158
query12 128 82 82 82
query13 1644 427 447 427
query14 9002 6665 6356 6356
query15 224 183 188 183
query16 7635 273 285 273
query17 1409 583 559 559
query18 3794 311 299 299
query19 653 163 178 163
query20 301 103 109 103
query21 595 145 139 139
query22 5217 4556 4580 4556
query23 30408 29892 29875 29875
query24 11933 3139 3093 3093
query25 640 355 349 349
query26 1795 154 159 154
query27 2992 316 303 303
query28 6977 1839 1845 1839
query29 1120 559 567 559
query30 284 132 139 132
query31 875 678 699 678
query32 101 60 59 59
query33 700 225 218 218
query34 1051 488 483 483
query35 849 733 741 733
query36 964 891 844 844
query37 255 60 66 60
query38 3069 2996 3007 2996
query39 1285 1260 1243 1243
query40 282 101 99 99
query41 38 36 34 34
query42 106 96 96 96
query43 501 461 418 418
query44 1065 683 701 683
query45 192 176 172 172
query46 1033 769 784 769
query47 1520 1399 1466 1399
query48 409 334 338 334
query49 1221 284 295 284
query50 762 360 358 358
query51 4428 4271 4282 4271
query52 101 89 91 89
query53 332 270 262 262
query54 287 215 219 215
query55 79 84 77 77
query56 222 199 197 197
query57 980 920 859 859
query58 213 197 193 193
query59 2162 2024 2138 2024
query60 234 215 215 215
query61 87 95 90 90
query62 592 356 330 330
query63 276 256 259 256
query64 6409 2948 3115 2948
query65 3212 3210 3216 3210
query66 1381 317 313 313
query67 14549 14350 13887 13887
query68 4907 556 558 556
query69 518 370 351 351
query70 1190 1253 1251 1251
query71 418 246 246 246
query72 6235 2809 2668 2668
query73 701 317 324 317
query74 6334 5977 5961 5961
query75 3103 2447 2433 2433
query76 3229 1038 1140 1038
query77 343 228 232 228
query78 8943 8493 8494 8493
query79 959 515 515 515
query80 510 356 347 347
query81 445 199 195 195
query82 238 82 80 80
query83 136 122 124 122
query84 231 74 78 74
query85 1045 359 346 346
query86 291 299 300 299
query87 3260 3129 3030 3030
query88 2641 2246 2239 2239
query89 383 361 321 321
query90 1966 160 160 160
query91 155 124 125 124
query92 53 48 48 48
query93 1025 520 498 498
query94 1097 185 178 178
query95 427 322 336 322
query96 565 259 258 258
query97 4232 4125 4135 4125
query98 202 202 199 199
query99 1063 648 684 648
Total cold run time: 268577 ms
Total hot run time: 169013 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1967286957
<details>
<summary>TPC-H: <b>Total hot run time: 37546 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 35417fe1a3bf518d7139a6c94d6471484db82a09, data reload: false
------ Round 1 ----------------------------------
q1 17740 3995 3973 3973
q2 2044 142 134 134
q3 10579 943 920 920
q4 4664 931 934 931
q5 7610 2871 2971 2871
q6 182 122 120 120
q7 1229 746 725 725
q8 9237 1950 1992 1950
q9 7155 6241 6242 6241
q10 8185 2490 2494 2490
q11 421 217 211 211
q12 794 307 307 307
q13 17949 3201 3202 3201
q14 272 246 256 246
q15 526 506 493 493
q16 472 397 399 397
q17 921 864 869 864
q18 6633 5966 5951 5951
q19 1572 1491 1498 1491
q20 549 285 275 275
q21 6229 3464 3533 3464
q22 808 291 291 291
Total cold run time: 105771 ms
Total hot run time: 37546 ms
----- Round 2, with runtime_filter_mode=off -----
q1 3999 3996 3981 3981
q2 300 219 223 219
q3 2976 2931 2922 2922
q4 1806 1819 1802 1802
q5 5093 5081 5091 5081
q6 197 115 115 115
q7 2140 1751 1691 1691
q8 3103 3181 3183 3181
q9 8255 8241 8268 8241
q10 6129 3632 3623 3623
q11 498 428 428 428
q12 683 518 530 518
q13 11956 3055 3027 3027
q14 275 259 262 259
q15 530 497 491 491
q16 515 459 467 459
q17 1681 1661 1662 1661
q18 7790 7376 7426 7376
q19 1648 1625 1624 1624
q20 2097 1903 1906 1903
q21 4738 4735 4660 4660
q22 505 430 443 430
Total cold run time: 66914 ms
Total hot run time: 53692 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969606163
<details>
<summary>TPC-DS: <b>Total hot run time: 169450 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 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
query1 921 333 333 333
query2 6563 1681 1743 1681
query3 6695 213 213 213
query4 23086 20632 20746 20632
query5 4336 370 361 361
query6 263 165 165 165
query7 4612 304 299 299
query8 263 195 206 195
query9 8455 2270 2277 2270
query10 424 207 205 205
query11 14838 14360 14386 14360
query12 133 85 82 82
query13 1647 457 442 442
query14 8417 6767 6357 6357
query15 225 185 196 185
query16 7373 295 271 271
query17 1411 577 553 553
query18 2704 313 305 305
query19 507 180 199 180
query20 140 96 99 96
query21 823 149 160 149
query22 5388 4506 4594 4506
query23 30808 29960 29925 29925
query24 12043 3087 3112 3087
query25 635 343 351 343
query26 1867 157 164 157
query27 3059 305 311 305
query28 6993 1835 1831 1831
query29 1209 557 555 555
query30 288 132 143 132
query31 895 671 686 671
query32 100 66 57 57
query33 716 229 226 226
query34 1060 479 494 479
query35 858 745 742 742
query36 933 853 879 853
query37 179 61 62 61
query38 3076 2928 2983 2928
query39 1320 1252 1240 1240
query40 280 104 103 103
query41 39 37 36 36
query42 105 104 96 96
query43 458 421 431 421
query44 1073 691 706 691
query45 191 180 175 175
query46 1029 792 783 783
query47 1573 1416 1438 1416
query48 428 343 337 337
query49 1237 311 303 303
query50 767 369 373 369
query51 4331 4286 4265 4265
query52 107 97 96 96
query53 337 260 268 260
query54 295 220 223 220
query55 89 77 81 77
query56 218 199 200 199
query57 964 901 864 864
query58 218 194 198 194
query59 2191 2045 2017 2017
query60 235 211 215 211
query61 90 81 81 81
query62 617 362 359 359
query63 279 257 267 257
query64 6406 2991 3422 2991
query65 3232 3333 3213 3213
query66 1364 321 312 312
query67 14184 14093 14081 14081
query68 5024 566 585 566
query69 529 382 380 380
query70 1240 1227 1209 1209
query71 409 250 255 250
query72 6234 2771 2653 2653
query73 697 326 323 323
query74 6308 5972 5967 5967
query75 3105 2431 2408 2408
query76 3216 1043 1138 1043
query77 346 238 225 225
query78 9178 8660 8424 8424
query79 1131 531 542 531
query80 903 359 347 347
query81 477 198 194 194
query82 1248 89 90 89
query83 223 123 117 117
query84 233 77 75 75
query85 1314 349 337 337
query86 371 295 310 295
query87 3258 3079 3071 3071
query88 2712 2235 2225 2225
query89 402 328 320 320
query90 1900 171 164 164
query91 149 121 121 121
query92 54 49 51 49
query93 1067 534 506 506
query94 1321 179 178 178
query95 448 335 339 335
query96 582 257 262 257
query97 4281 4111 4161 4111
query98 212 201 190 190
query99 1023 646 631 631
Total cold run time: 267195 ms
Total hot run time: 169450 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970343412
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970366897
<details>
<summary>TPC-DS: <b>Total hot run time: 169245 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 868a461d21c92481867ab5ccd8644f728d5c01e3, data reload: false
query1 934 343 336 336
query2 6528 1766 1696 1696
query3 6713 202 203 202
query4 23523 20522 20606 20522
query5 4283 362 362 362
query6 266 164 171 164
query7 4599 287 294 287
query8 252 197 193 193
query9 8372 2222 2218 2218
query10 417 220 225 220
query11 14656 14239 14103 14103
query12 141 83 81 81
query13 1629 462 427 427
query14 8462 6643 6471 6471
query15 217 181 182 181
query16 7086 258 257 257
query17 1036 527 501 501
query18 1911 280 263 263
query19 194 146 148 146
query20 85 79 88 79
query21 197 123 114 114
query22 4975 4759 4770 4759
query23 30505 29866 29765 29765
query24 11963 3043 3113 3043
query25 649 346 341 341
query26 1831 154 163 154
query27 3049 312 318 312
query28 6996 1817 1824 1817
query29 1124 552 551 551
query30 287 132 140 132
query31 873 685 680 680
query32 85 54 56 54
query33 724 219 232 219
query34 1060 472 484 472
query35 854 735 746 735
query36 950 882 835 835
query37 230 59 60 59
query38 3084 3022 2990 2990
query39 1288 1242 1237 1237
query40 280 100 102 100
query41 40 37 35 35
query42 102 95 98 95
query43 462 437 418 418
query44 1058 694 720 694
query45 188 180 171 171
query46 1031 795 793 793
query47 1553 1507 1461 1461
query48 410 340 334 334
query49 1153 299 289 289
query50 766 365 366 365
query51 4456 4286 4290 4286
query52 101 89 90 89
query53 339 261 264 261
query54 297 216 224 216
query55 82 78 71 71
query56 231 195 206 195
query57 976 874 882 874
query58 217 194 193 193
query59 2158 1957 2124 1957
query60 229 217 209 209
query61 89 89 85 85
query62 609 338 363 338
query63 288 257 250 250
query64 6297 3018 3057 3018
query65 3247 3203 3207 3203
query66 1350 322 318 318
query67 14377 14242 14276 14242
query68 4983 543 560 543
query69 538 386 373 373
query70 1213 1217 1203 1203
query71 366 248 246 246
query72 6237 2814 2631 2631
query73 714 327 321 321
query74 6480 6031 5943 5943
query75 3050 2455 2422 2422
query76 2793 1021 1160 1021
query77 344 224 228 224
query78 10166 8571 8505 8505
query79 998 544 520 520
query80 602 365 355 355
query81 450 196 194 194
query82 482 87 83 83
query83 241 122 125 122
query84 281 76 74 74
query85 1144 351 344 344
query86 300 295 263 263
query87 3234 3120 3114 3114
query88 2698 2284 2255 2255
query89 384 339 326 326
query90 1984 164 170 164
query91 152 123 124 123
query92 55 50 47 47
query93 1014 527 516 516
query94 1075 189 187 187
query95 445 337 344 337
query96 577 259 261 259
query97 4241 4138 4184 4138
query98 216 198 188 188
query99 1022 666 694 666
Total cold run time: 262893 ms
Total hot run time: 169245 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970346717
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969620519
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 8425ba6d368d1ff3c35b76519bfa725c436b14ef with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 18.0 seconds inserted 10000000 Rows, about 555K 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1970347945
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #31498:
URL: https://github.com/apache/doris/pull/31498
--
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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1969589444
<details>
<summary>TPC-H: <b>Total hot run time: 37640 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 8425ba6d368d1ff3c35b76519bfa725c436b14ef, data reload: false
------ Round 1 ----------------------------------
q1 17660 4049 4009 4009
q2 2035 140 138 138
q3 10574 936 936 936
q4 4656 935 927 927
q5 7610 2815 3015 2815
q6 179 122 121 121
q7 1222 750 740 740
q8 9245 1984 2000 1984
q9 7167 6277 6249 6249
q10 8182 2485 2509 2485
q11 406 216 206 206
q12 769 309 306 306
q13 17936 3201 3195 3195
q14 279 257 267 257
q15 531 491 492 491
q16 465 410 400 400
q17 925 869 890 869
q18 6721 5911 5976 5911
q19 1567 1490 1502 1490
q20 541 279 269 269
q21 6680 3561 3622 3561
q22 811 281 287 281
Total cold run time: 106161 ms
Total hot run time: 37640 ms
----- Round 2, with runtime_filter_mode=off -----
q1 3978 3964 3989 3964
q2 307 213 218 213
q3 2936 2991 2981 2981
q4 1886 1902 1891 1891
q5 5250 5147 5127 5127
q6 194 116 115 115
q7 2128 1694 1732 1694
q8 3099 3177 3176 3176
q9 8199 8202 8184 8184
q10 6091 3654 3624 3624
q11 534 418 426 418
q12 700 527 527 527
q13 9408 3055 3049 3049
q14 280 252 258 252
q15 530 487 496 487
q16 496 463 455 455
q17 1680 1671 1662 1662
q18 7852 7511 7469 7469
q19 1667 1625 1607 1607
q20 2095 1905 1899 1899
q21 4788 4593 4634 4593
q22 535 445 446 445
Total cold run time: 64633 ms
Total hot run time: 53832 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](nereids) forbid create table with illegal auto partition expr [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31498:
URL: https://github.com/apache/doris/pull/31498#issuecomment-1967219300
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
--
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