You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yulei-Yang (via GitHub)" <gi...@apache.org> on 2024/06/14 03:07:37 UTC
[PR] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Yulei-Yang opened a new pull request, #36294:
URL: https://github.com/apache/doris/pull/36294
bp: #28145
--
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167137392
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167533653
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167162860
<details>
<summary>ClickBench: <b>Total hot run time: 30.43 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 ef2193be32d303c670f571cf2403279630d90e15, data reload: false
query1 0.03 0.02 0.02
query2 0.07 0.03 0.02
query3 0.25 0.05 0.04
query4 1.78 0.06 0.06
query5 0.53 0.53 0.52
query6 1.24 0.62 0.63
query7 0.02 0.01 0.01
query8 0.02 0.02 0.02
query9 0.52 0.48 0.49
query10 0.54 0.55 0.54
query11 0.12 0.09 0.09
query12 0.11 0.10 0.09
query13 0.63 0.61 0.62
query14 0.79 0.80 0.79
query15 0.78 0.75 0.76
query16 0.37 0.38 0.35
query17 1.02 1.01 1.01
query18 0.24 0.24 0.24
query19 1.95 1.84 1.84
query20 0.01 0.01 0.01
query21 15.47 0.55 0.55
query22 2.05 2.51 1.62
query23 17.52 1.06 0.94
query24 6.04 0.68 1.03
query25 0.37 0.08 0.05
query26 0.65 0.16 0.15
query27 0.04 0.04 0.03
query28 7.51 0.71 0.72
query29 12.76 2.31 2.32
query30 0.59 0.53 0.49
query31 2.80 0.40 0.38
query32 3.35 0.52 0.49
query33 3.09 3.04 3.10
query34 15.24 4.82 4.78
query35 4.86 4.84 4.85
query36 1.05 1.01 1.01
query37 0.05 0.04 0.04
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.14
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 104.79 s
Total hot run time: 30.43 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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167158700
<details>
<summary>TPC-DS: <b>Total hot run time: 204071 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 ef2193be32d303c670f571cf2403279630d90e15, data reload: false
query1 970 389 390 389
query2 6526 2763 2699 2699
query3 6924 211 202 202
query4 20212 18174 18018 18018
query5 19744 6459 6442 6442
query6 276 218 229 218
query7 4149 301 318 301
query8 434 449 432 432
query9 3140 2714 2621 2621
query10 413 305 311 305
query11 11399 10733 10678 10678
query12 122 79 72 72
query13 5588 693 698 693
query14 17307 13466 13756 13466
query15 371 274 253 253
query16 6476 287 261 261
query17 1746 1468 878 878
query18 2308 420 415 415
query19 226 150 150 150
query20 80 78 82 78
query21 192 96 96 96
query22 5295 4954 4992 4954
query23 32824 32252 31992 31992
query24 7730 6530 6458 6458
query25 531 428 428 428
query26 713 167 165 165
query27 2136 304 297 297
query28 6171 2382 2319 2319
query29 2952 2743 2782 2743
query30 241 170 166 166
query31 938 745 734 734
query32 66 61 62 61
query33 406 261 258 258
query34 843 478 473 473
query35 1102 960 955 955
query36 1334 1118 1092 1092
query37 91 64 58 58
query38 3043 2920 2910 2910
query39 1376 1315 1322 1315
query40 314 98 99 98
query41 49 44 44 44
query42 85 85 86 85
query43 673 714 654 654
query44 1109 709 713 709
query45 253 237 242 237
query46 1242 967 1001 967
query47 1840 1718 1771 1718
query48 1011 724 703 703
query49 644 389 369 369
query50 881 635 568 568
query51 4802 4647 4686 4647
query52 93 83 88 83
query53 454 326 338 326
query54 2645 2471 2479 2471
query55 89 83 86 83
query56 228 218 202 202
query57 1122 1111 1052 1052
query58 218 194 203 194
query59 4337 3744 3974 3744
query60 232 192 225 192
query61 101 96 104 96
query62 786 475 479 475
query63 486 358 346 346
query64 2802 1598 1453 1453
query65 3625 3551 3544 3544
query66 802 392 390 390
query67 15538 17556 15911 15911
query68 8824 651 662 651
query69 568 352 342 342
query70 1591 1393 1454 1393
query71 409 315 329 315
query72 6503 3517 3491 3491
query73 735 326 322 322
query74 6320 5869 5814 5814
query75 5281 3857 3720 3720
query76 5282 1155 1096 1096
query77 907 255 263 255
query78 12615 11811 11532 11532
query79 10438 663 669 663
query80 1615 402 408 402
query81 487 242 235 235
query82 1640 99 97 97
query83 171 134 134 134
query84 268 70 73 70
query85 890 318 323 318
query86 342 293 290 290
query87 3265 3001 3006 3001
query88 5159 2322 2365 2322
query89 475 275 331 275
query90 1959 212 217 212
query91 175 146 140 140
query92 61 55 53 53
query93 7126 633 606 606
query94 701 208 208 208
query95 1111 1054 1051 1051
query96 648 326 329 326
query97 6472 6341 6467 6341
query98 201 183 168 168
query99 3042 822 993 822
Total cold run time: 318137 ms
Total hot run time: 204071 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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167229109
run feut
--
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167409737
run 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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167150260
<details>
<summary>TPC-H: <b>Total hot run time: 50061 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 ef2193be32d303c670f571cf2403279630d90e15, data reload: false
------ Round 1 ----------------------------------
q1 17544 4384 4375 4375
q2 2067 161 150 150
q3 11033 1943 1963 1943
q4 10391 1238 1336 1238
q5 8727 3923 4062 3923
q6 243 130 129 129
q7 2052 1604 1587 1587
q8 9291 2747 2695 2695
q9 10665 10276 10333 10276
q10 8633 3549 3501 3501
q11 432 250 254 250
q12 487 308 306 306
q13 18378 3993 4045 3993
q14 360 319 316 316
q15 500 462 465 462
q16 674 590 587 587
q17 1142 966 977 966
q18 7280 6919 6848 6848
q19 1821 1658 1647 1647
q20 520 326 295 295
q21 4444 4135 4125 4125
q22 534 452 449 449
Total cold run time: 117218 ms
Total hot run time: 50061 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4572 4305 4294 4294
q2 327 225 221 221
q3 4184 4158 4134 4134
q4 2731 2755 2741 2741
q5 7128 7106 7079 7079
q6 242 121 122 121
q7 3257 2937 2872 2872
q8 4367 4440 4473 4440
q9 16954 16843 16791 16791
q10 4247 4279 4261 4261
q11 758 710 676 676
q12 1035 859 871 859
q13 7083 3721 3770 3721
q14 451 429 423 423
q15 508 460 460 460
q16 739 683 668 668
q17 3863 3893 3823 3823
q18 8812 8836 8821 8821
q19 1735 1704 1666 1666
q20 2395 2128 2095 2095
q21 8480 8411 8455 8411
q22 1069 988 981 981
Total cold run time: 84937 ms
Total hot run time: 79558 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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "lide-reed (via GitHub)" <gi...@apache.org>.
lide-reed merged PR #36294:
URL: https://github.com/apache/doris/pull/36294
--
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167129649
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167165157
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ef2193be32d303c670f571cf2403279630d90e15 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: 32 seconds loaded 861443392 Bytes, about 25 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] [Improvement](hms catalog) support show_create_database for hms catalog [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36294:
URL: https://github.com/apache/doris/pull/36294#issuecomment-2167533711
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