You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "feiniaofeiafei (via GitHub)" <gi...@apache.org> on 2024/02/27 08:14:11 UTC
[PR] Current timestamp column default value restriction pick to 2.0 [doris]
feiniaofeiafei opened a new pull request, #31466:
URL: https://github.com/apache/doris/pull/31466
pr 31395 pick to branch-2.0
--
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](ddl) Only datetime and datetimev2 types can use current_timestamp as column default value [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #31466:
URL: https://github.com/apache/doris/pull/31466
--
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] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966031638
<details>
<summary>TPC-H: <b>Total hot run time: 50153 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 ee72f101a48691a802915c99a9cfbff12252ac63, data reload: false
------ Round 1 ----------------------------------
q1 17533 4386 4326 4326
q2 2030 151 141 141
q3 10271 1884 1917 1884
q4 10094 1240 1331 1240
q5 8506 3973 4023 3973
q6 233 122 122 122
q7 2038 1590 1599 1590
q8 9337 2742 2728 2728
q9 10827 11393 10524 10524
q10 8652 3543 3492 3492
q11 410 234 242 234
q12 457 296 296 296
q13 18351 3961 4035 3961
q14 362 323 321 321
q15 509 461 460 460
q16 685 595 575 575
q17 1133 962 977 962
q18 7283 6945 6972 6945
q19 1664 1588 1564 1564
q20 529 332 326 326
q21 4441 4126 4095 4095
q22 506 410 394 394
Total cold run time: 115851 ms
Total hot run time: 50153 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4342 4334 4300 4300
q2 318 226 217 217
q3 4153 4175 4166 4166
q4 2747 2775 2746 2746
q5 7215 7235 7242 7235
q6 236 121 120 120
q7 3286 2882 2815 2815
q8 4356 4488 4505 4488
q9 17098 16983 16996 16983
q10 4222 4274 4271 4271
q11 781 694 693 693
q12 1041 858 853 853
q13 4170 3788 3741 3741
q14 445 424 424 424
q15 508 455 453 453
q16 762 717 706 706
q17 3890 3847 3881 3847
q18 8878 8763 8815 8763
q19 1703 1706 1635 1635
q20 2374 2149 2103 2103
q21 8584 8579 8601 8579
q22 1088 963 988 963
Total cold run time: 82197 ms
Total hot run time: 80101 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] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966067079
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ee72f101a48691a802915c99a9cfbff12252ac63 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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: 21.2 seconds inserted 10000000 Rows, about 471K 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] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966001408
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
Re: [PR] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966061818
<details>
<summary>ClickBench: <b>Total hot run time: 30.37 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 ee72f101a48691a802915c99a9cfbff12252ac63, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.03 0.02
query3 0.25 0.05 0.05
query4 1.81 0.06 0.07
query5 0.53 0.52 0.51
query6 1.24 0.62 0.62
query7 0.01 0.00 0.01
query8 0.03 0.03 0.03
query9 0.52 0.49 0.49
query10 0.54 0.54 0.52
query11 0.11 0.08 0.09
query12 0.11 0.08 0.09
query13 0.61 0.62 0.62
query14 0.77 0.82 0.77
query15 0.79 0.76 0.77
query16 0.36 0.38 0.36
query17 1.00 0.96 1.01
query18 0.22 0.25 0.23
query19 1.89 1.85 1.84
query20 0.02 0.01 0.02
query21 15.50 0.55 0.55
query22 1.92 1.95 1.21
query23 16.89 1.05 0.91
query24 6.82 1.00 1.72
query25 1.49 0.12 0.11
query26 0.37 0.14 0.13
query27 0.10 0.10 0.11
query28 6.51 0.74 0.71
query29 12.64 2.28 2.30
query30 0.54 0.53 0.55
query31 2.82 0.38 0.39
query32 3.41 0.49 0.49
query33 3.07 3.13 3.07
query34 15.28 4.77 4.79
query35 4.84 4.86 4.83
query36 1.07 1.01 1.02
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.13 0.14
query41 0.06 0.02 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 104.53 s
Total hot run time: 30.37 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] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966052519
<details>
<summary>TPC-DS: <b>Total hot run time: 204746 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 ee72f101a48691a802915c99a9cfbff12252ac63, data reload: false
query1 896 387 381 381
query2 6522 2244 2186 2186
query3 6941 206 203 203
query4 20203 18067 18229 18067
query5 19720 6521 6479 6479
query6 281 217 223 217
query7 4148 294 295 294
query8 256 264 225 225
query9 3160 2753 2664 2664
query10 410 285 311 285
query11 11307 10696 10643 10643
query12 126 73 71 71
query13 5570 655 647 647
query14 18160 13706 13506 13506
query15 371 243 231 231
query16 6455 256 260 256
query17 1734 1469 853 853
query18 2346 401 408 401
query19 203 157 157 157
query20 72 80 76 76
query21 188 94 93 93
query22 5374 5093 5120 5093
query23 32597 31946 32111 31946
query24 7883 6561 6592 6561
query25 499 424 410 410
query26 1247 161 158 158
query27 2279 296 292 292
query28 6104 2207 2185 2185
query29 2776 2617 2694 2617
query30 242 161 159 159
query31 908 722 730 722
query32 67 60 55 55
query33 419 240 243 240
query34 834 467 472 467
query35 1118 905 849 849
query36 1595 1606 1656 1606
query37 172 62 60 60
query38 3091 2920 2946 2920
query39 1353 1306 1321 1306
query40 305 95 96 95
query41 35 32 34 32
query42 83 82 88 82
query43 708 607 606 606
query44 1146 721 709 709
query45 238 227 233 227
query46 1245 955 966 955
query47 1719 1788 1682 1682
query48 958 663 652 652
query49 625 388 367 367
query50 861 614 616 614
query51 4748 4605 4663 4605
query52 84 81 76 76
query53 439 312 318 312
query54 2632 2424 2485 2424
query55 79 81 80 80
query56 217 203 200 200
query57 1309 1197 1015 1015
query58 194 200 191 191
query59 3580 3368 3065 3065
query60 203 188 186 186
query61 86 79 82 79
query62 753 525 496 496
query63 467 338 334 334
query64 2713 1534 1471 1471
query65 3611 3559 3561 3559
query66 805 366 358 358
query67 16597 16185 16396 16185
query68 8528 645 670 645
query69 561 328 335 328
query70 1945 1944 1685 1685
query71 396 279 307 279
query72 6169 3419 3415 3415
query73 736 320 343 320
query74 6341 5803 5867 5803
query75 4808 3761 3699 3699
query76 4839 1174 1180 1174
query77 688 245 244 244
query78 12288 14720 13214 13214
query79 10459 658 639 639
query80 805 379 388 379
query81 491 229 227 227
query82 236 94 97 94
query83 165 133 126 126
query84 249 68 65 65
query85 810 277 276 276
query86 414 389 391 389
query87 3270 2976 2990 2976
query88 4581 2336 2339 2336
query89 336 289 302 289
query90 1867 215 209 209
query91 158 121 114 114
query92 55 50 49 49
query93 1261 547 522 522
query94 752 203 210 203
query95 1120 1072 1068 1068
query96 645 329 328 328
query97 6596 6350 6401 6350
query98 197 169 173 169
query99 2657 920 894 894
Total cold run time: 308490 ms
Total hot run time: 204746 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] Current timestamp column default value restriction pick to 2.0 [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #31466:
URL: https://github.com/apache/doris/pull/31466#issuecomment-1966002650
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