You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/03/28 04:31:31 UTC
[PR] [fix](Nereids) support variant column with index when create table [doris]
morrySnow opened a new pull request, #32948:
URL: https://github.com/apache/doris/pull/32948
## 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](Nereids) support variant column with index when create table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024400528
<details>
<summary>TPC-DS: <b>Total hot run time: 182166 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 947216aef74762f1c91036d13ee72e74e7e1642b, data reload: false
query1 929 385 352 352
query2 6550 2094 2054 2054
query3 6706 214 224 214
query4 31841 21321 21318 21318
query5 4334 399 386 386
query6 263 180 194 180
query7 4638 294 308 294
query8 237 171 182 171
query9 9268 2365 2326 2326
query10 607 256 278 256
query11 15452 14235 14318 14235
query12 138 97 90 90
query13 1630 426 414 414
query14 10074 7957 7950 7950
query15 345 206 194 194
query16 8252 264 265 264
query17 2106 581 555 555
query18 2127 290 292 290
query19 371 153 160 153
query20 98 91 94 91
query21 204 130 125 125
query22 4930 4787 4819 4787
query23 33862 32602 32889 32602
query24 11730 2833 2849 2833
query25 648 392 389 389
query26 1792 161 162 161
query27 3043 358 362 358
query28 7766 1906 1897 1897
query29 1058 652 637 637
query30 311 156 150 150
query31 968 730 739 730
query32 107 58 59 58
query33 784 263 267 263
query34 1077 491 486 486
query35 837 612 614 612
query36 1040 870 878 870
query37 278 65 67 65
query38 3640 3433 3437 3433
query39 1472 1466 1439 1439
query40 292 115 117 115
query41 54 48 49 48
query42 110 99 96 96
query43 519 443 461 443
query44 1110 740 736 736
query45 310 273 270 270
query46 1116 707 702 702
query47 1908 1833 1831 1831
query48 458 362 363 362
query49 1258 352 337 337
query50 755 378 370 370
query51 6745 6612 6626 6612
query52 110 97 98 97
query53 350 280 277 277
query54 321 251 263 251
query55 90 79 79 79
query56 256 240 229 229
query57 1209 1146 1154 1146
query58 243 215 221 215
query59 2810 2744 2537 2537
query60 271 253 253 253
query61 115 115 117 115
query62 653 452 464 452
query63 316 283 277 277
query64 6858 4065 3892 3892
query65 3137 3069 3042 3042
query66 1421 375 355 355
query67 15618 14868 15087 14868
query68 9322 526 540 526
query69 676 394 397 394
query70 1350 1103 1160 1103
query71 521 266 262 262
query72 7000 2724 2533 2533
query73 1620 318 321 318
query74 8453 6381 6512 6381
query75 3935 2202 2261 2202
query76 5780 908 927 908
query77 639 266 260 260
query78 11158 10208 10166 10166
query79 11375 535 526 526
query80 1872 376 376 376
query81 510 221 209 209
query82 395 88 89 88
query83 230 143 144 143
query84 283 80 77 77
query85 1100 318 318 318
query86 353 287 293 287
query87 3782 3612 3474 3474
query88 4805 2300 2302 2300
query89 496 383 378 378
query90 2050 180 177 177
query91 201 143 140 140
query92 59 52 49 49
query93 6813 505 484 484
query94 1320 182 181 181
query95 440 335 337 335
query96 616 268 273 268
query97 2627 2528 2502 2502
query98 238 220 212 212
query99 1171 900 926 900
Total cold run time: 321116 ms
Total hot run time: 182166 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) support variant column with index when create table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024547547
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) support variant column with index when create table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024375304
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] [fix](Nereids) support variant column with index when create table [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024375478
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) support variant column with index when create table [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024547500
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) support variant column with index when create table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024406882
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 947216aef74762f1c91036d13ee72e74e7e1642b 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.7 seconds inserted 10000000 Rows, about 729K 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) support variant column with index when create table [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024452971
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] [fix](Nereids) support variant column with index when create table [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32948:
URL: https://github.com/apache/doris/pull/32948#issuecomment-2024389224
<details>
<summary>TPC-H: <b>Total hot run time: 38351 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 947216aef74762f1c91036d13ee72e74e7e1642b, data reload: false
------ Round 1 ----------------------------------
q1 17662 4182 4141 4141
q2 2124 170 167 167
q3 10567 1169 1195 1169
q4 10239 775 799 775
q5 7472 3030 2985 2985
q6 207 133 128 128
q7 1071 632 586 586
q8 9360 2053 1992 1992
q9 7235 6601 6608 6601
q10 8438 3551 3576 3551
q11 445 244 222 222
q12 382 214 200 200
q13 17797 2881 2863 2863
q14 241 205 205 205
q15 512 469 485 469
q16 502 374 377 374
q17 951 551 592 551
q18 7329 6529 6492 6492
q19 1533 1448 1495 1448
q20 558 264 250 250
q21 3641 2923 2876 2876
q22 359 306 316 306
Total cold run time: 108625 ms
Total hot run time: 38351 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4122 4102 4128 4102
q2 323 226 230 226
q3 2958 2865 2914 2865
q4 1846 1508 1540 1508
q5 5343 5355 5346 5346
q6 193 117 120 117
q7 2278 1902 1841 1841
q8 3155 3277 3263 3263
q9 8755 8686 8755 8686
q10 3788 3846 3798 3798
q11 549 447 443 443
q12 707 535 525 525
q13 16926 2893 2838 2838
q14 283 250 255 250
q15 496 477 467 467
q16 489 419 441 419
q17 1724 1495 1466 1466
q18 7394 7135 7151 7135
q19 1607 1519 1555 1519
q20 1933 1770 1735 1735
q21 4819 4704 4684 4684
q22 549 452 453 452
Total cold run time: 70237 ms
Total hot run time: 53685 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) support variant column with index when create table [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #32948:
URL: https://github.com/apache/doris/pull/32948
--
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