You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "wuwenchi (via GitHub)" <gi...@apache.org> on 2024/03/11 11:15:50 UTC
[PR] [fix](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
wuwenchi opened a new pull request, #32066:
URL: https://github.com/apache/doris/pull/32066
## Proposed changes
mirror: #32061
<!--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](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988292975
<details>
<summary>TPC-DS: <b>Total hot run time: 204663 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 4cab03e404e50b4f8ae3d3ab2f4fbb91b9a22867, data reload: false
query1 921 390 378 378
query2 6539 2246 1997 1997
query3 6922 198 198 198
query4 20929 17835 17928 17835
query5 19719 6589 6532 6532
query6 285 215 232 215
query7 4173 295 291 291
query8 241 241 231 231
query9 3129 2674 2594 2594
query10 411 281 295 281
query11 11345 10743 10713 10713
query12 121 76 69 69
query13 5565 657 640 640
query14 17764 13138 13912 13138
query15 358 238 234 234
query16 6427 263 281 263
query17 1721 1440 870 870
query18 2312 418 406 406
query19 207 149 154 149
query20 76 77 72 72
query21 184 94 95 94
query22 5192 5104 5103 5103
query23 32709 32188 32113 32113
query24 6964 6611 6475 6475
query25 510 416 407 407
query26 527 165 160 160
query27 1874 300 303 300
query28 6279 2260 2236 2236
query29 3193 2973 3000 2973
query30 251 239 170 170
query31 928 773 781 773
query32 70 67 63 63
query33 395 291 277 277
query34 867 472 491 472
query35 1197 1004 906 906
query36 1860 1594 1572 1572
query37 93 74 68 68
query38 3143 2954 2947 2947
query39 1367 1362 1363 1362
query40 714 113 105 105
query41 52 49 41 41
query42 78 96 118 96
query43 654 659 650 650
query44 1858 726 721 721
query45 274 251 231 231
query46 1288 993 958 958
query47 1880 1738 1716 1716
query48 999 695 683 683
query49 613 362 376 362
query50 863 599 585 585
query51 4728 4666 4656 4656
query52 85 86 77 77
query53 459 319 319 319
query54 2652 2482 2492 2482
query55 86 84 80 80
query56 209 210 217 210
query57 1277 1116 1126 1116
query58 197 202 186 186
query59 3361 3214 3146 3146
query60 208 187 207 187
query61 90 88 87 87
query62 710 569 509 509
query63 484 338 330 330
query64 2473 1519 1458 1458
query65 3614 3557 3533 3533
query66 743 358 369 358
query67 16803 15232 15530 15232
query68 9185 660 652 652
query69 572 365 344 344
query70 1996 1875 1820 1820
query71 418 291 301 291
query72 6677 3516 3477 3477
query73 727 324 309 309
query74 6321 5893 5780 5780
query75 5455 3656 3709 3656
query76 5727 1202 1167 1167
query77 986 244 242 242
query78 12819 13577 13727 13577
query79 10964 652 658 652
query80 744 412 386 386
query81 496 234 229 229
query82 260 93 93 93
query83 171 132 137 132
query84 253 68 68 68
query85 724 298 292 292
query86 386 376 359 359
query87 3281 3030 2962 2962
query88 5017 2305 2286 2286
query89 367 280 282 280
query90 2605 206 211 206
query91 154 116 118 116
query92 52 53 56 53
query93 2133 533 597 533
query94 999 205 208 205
query95 1126 1074 1048 1048
query96 633 319 322 319
query97 6555 6451 6396 6396
query98 202 176 176 176
query99 2886 866 979 866
Total cold run time: 315111 ms
Total hot run time: 204663 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](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988198769
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] [fix](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988307792
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 4cab03e404e50b4f8ae3d3ab2f4fbb91b9a22867 with default session variables
Stream load json: 21 seconds loaded 2358488459 Bytes, about 107 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: 20.8 seconds inserted 10000000 Rows, about 480K 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](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988302313
<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 4cab03e404e50b4f8ae3d3ab2f4fbb91b9a22867, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.24 0.05 0.05
query4 1.82 0.07 0.07
query5 0.53 0.52 0.52
query6 1.24 0.66 0.62
query7 0.02 0.02 0.02
query8 0.04 0.02 0.03
query9 0.52 0.50 0.48
query10 0.54 0.53 0.54
query11 0.11 0.08 0.08
query12 0.11 0.09 0.09
query13 0.61 0.61 0.61
query14 0.79 0.83 0.79
query15 0.77 0.75 0.76
query16 0.37 0.36 0.35
query17 1.00 0.96 1.00
query18 0.21 0.28 0.24
query19 1.91 1.83 1.86
query20 0.01 0.01 0.01
query21 15.49 0.60 0.55
query22 2.19 2.14 1.37
query23 17.33 1.03 0.89
query24 5.08 0.95 1.76
query25 0.40 0.10 0.06
query26 0.65 0.17 0.16
query27 0.05 0.03 0.04
query28 7.40 0.72 0.76
query29 12.72 2.35 2.30
query30 0.54 0.53 0.52
query31 2.82 0.39 0.37
query32 3.41 0.50 0.49
query33 3.07 3.04 3.08
query34 15.25 4.83 4.77
query35 4.87 4.82 4.85
query36 1.04 1.03 1.02
query37 0.06 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.02
query40 0.15 0.14 0.14
query41 0.06 0.01 0.01
query42 0.02 0.01 0.01
query43 0.02 0.01 0.01
Total cold run time: 103.59 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] [fix](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "wuwenchi (via GitHub)" <gi...@apache.org>.
wuwenchi commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988199097
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](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32066:
URL: https://github.com/apache/doris/pull/32066#issuecomment-1988270291
<details>
<summary>TPC-H: <b>Total hot run time: 50104 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 4cab03e404e50b4f8ae3d3ab2f4fbb91b9a22867, data reload: false
------ Round 1 ----------------------------------
q1 18285 4381 4324 4324
q2 2013 149 142 142
q3 10323 1894 1919 1894
q4 10356 1245 1304 1245
q5 8375 3973 3962 3962
q6 224 124 123 123
q7 2029 1609 1612 1609
q8 9495 2695 2766 2695
q9 14245 10695 10806 10695
q10 8638 3486 3479 3479
q11 405 242 240 240
q12 469 298 301 298
q13 18366 3978 4011 3978
q14 365 317 321 317
q15 500 452 454 452
q16 688 596 580 580
q17 1109 953 926 926
q18 7284 7010 6872 6872
q19 1671 1538 1500 1500
q20 525 302 310 302
q21 4438 4087 4121 4087
q22 498 397 384 384
Total cold run time: 120301 ms
Total hot run time: 50104 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4315 4284 4324 4284
q2 313 219 224 219
q3 4186 4157 4152 4152
q4 2748 2751 2759 2751
q5 7219 7139 7219 7139
q6 233 118 117 117
q7 3221 2834 2863 2834
q8 4348 4446 4440 4440
q9 17552 17442 17170 17170
q10 4209 4233 4201 4201
q11 756 694 661 661
q12 1016 853 829 829
q13 7141 3731 3723 3723
q14 442 411 420 411
q15 494 445 455 445
q16 744 695 686 686
q17 3768 3810 3820 3810
q18 8789 8729 8687 8687
q19 1745 1681 1648 1648
q20 2377 2166 2121 2121
q21 8359 8416 8456 8416
q22 1002 1008 978 978
Total cold run time: 84977 ms
Total hot run time: 79722 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](hive) fix spelling mistakes for "separatorChar" for 2.0 [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #32066:
URL: https://github.com/apache/doris/pull/32066
--
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