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 05:40:50 UTC
[PR] [opt](Nereids) support create table with variant type [doris]
morrySnow opened a new pull request, #32953:
URL: https://github.com/apache/doris/pull/32953
## 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] [opt](Nereids) support create table with variant type [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024446711
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] [opt](Nereids) support create table with variant type [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024538075
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] [opt](Nereids) support create table with variant type [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024494574
<details>
<summary>TPC-DS: <b>Total hot run time: 183087 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 e99c7dc118af5670b110ffde28461baa5870383b, data reload: false
query1 939 379 358 358
query2 6563 1913 1878 1878
query3 6700 212 210 210
query4 31849 21406 21405 21405
query5 4331 436 429 429
query6 271 187 177 177
query7 4633 306 314 306
query8 236 177 178 177
query9 9334 2372 2333 2333
query10 574 248 265 248
query11 17331 14361 14312 14312
query12 148 90 89 89
query13 1626 409 418 409
query14 10455 7657 7767 7657
query15 243 207 203 203
query16 8151 260 260 260
query17 1950 603 574 574
query18 2095 297 290 290
query19 317 159 161 159
query20 100 92 88 88
query21 200 135 132 132
query22 5048 4788 4755 4755
query23 33465 32831 32652 32652
query24 10828 3009 3035 3009
query25 644 411 410 410
query26 1205 164 163 163
query27 2764 349 362 349
query28 7432 1934 1887 1887
query29 940 651 639 639
query30 304 154 154 154
query31 994 758 739 739
query32 95 58 60 58
query33 776 260 258 258
query34 1086 509 523 509
query35 848 653 622 622
query36 1057 876 888 876
query37 131 68 67 67
query38 3549 3421 3435 3421
query39 1468 1476 1439 1439
query40 220 122 120 120
query41 52 50 51 50
query42 106 100 101 100
query43 513 466 465 465
query44 1201 739 729 729
query45 287 269 268 268
query46 1212 749 740 740
query47 1948 1822 1904 1822
query48 462 354 375 354
query49 1132 353 365 353
query50 827 383 376 376
query51 6838 6696 6600 6600
query52 111 92 91 91
query53 376 285 285 285
query54 312 246 250 246
query55 85 82 84 82
query56 260 237 236 236
query57 1239 1134 1160 1134
query58 243 222 219 219
query59 2908 2648 2604 2604
query60 285 255 265 255
query61 120 112 124 112
query62 687 462 460 460
query63 316 285 282 282
query64 5944 4263 4273 4263
query65 3138 3058 3090 3058
query66 988 382 356 356
query67 15513 14849 14852 14849
query68 7372 516 526 516
query69 644 384 379 379
query70 1253 1148 1122 1122
query71 523 268 266 266
query72 6360 2790 2594 2594
query73 774 318 313 313
query74 7972 6508 6381 6381
query75 3633 2334 2357 2334
query76 5035 933 967 933
query77 669 263 266 263
query78 11108 10204 10200 10200
query79 10148 553 551 551
query80 1594 395 387 387
query81 543 226 226 226
query82 891 90 87 87
query83 212 148 150 148
query84 284 77 82 77
query85 1503 336 323 323
query86 476 289 307 289
query87 3809 3613 3547 3547
query88 5105 2302 2303 2302
query89 527 391 386 386
query90 1998 176 183 176
query91 182 134 142 134
query92 59 51 52 51
query93 7080 505 496 496
query94 1244 183 183 183
query95 427 338 333 333
query96 674 277 268 268
query97 2657 2476 2485 2476
query98 238 234 222 222
query99 1282 917 914 914
Total cold run time: 314279 ms
Total hot run time: 183087 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] [opt](Nereids) support create table with variant type [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024480698
<details>
<summary>TPC-H: <b>Total hot run time: 37790 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 e99c7dc118af5670b110ffde28461baa5870383b, data reload: false
------ Round 1 ----------------------------------
q1 17627 4283 4092 4092
q2 2110 155 147 147
q3 10591 1122 1210 1122
q4 10229 729 821 729
q5 7469 3018 2975 2975
q6 207 127 121 121
q7 1022 591 572 572
q8 9345 2010 1991 1991
q9 7587 6563 6547 6547
q10 8421 3496 3599 3496
q11 443 218 215 215
q12 416 198 200 198
q13 17797 2832 2841 2832
q14 229 198 202 198
q15 507 478 466 466
q16 507 375 370 370
q17 944 530 610 530
q18 7061 6379 6388 6379
q19 2043 1422 1478 1422
q20 533 283 243 243
q21 3544 2947 2856 2856
q22 332 295 289 289
Total cold run time: 108964 ms
Total hot run time: 37790 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4149 4119 4080 4080
q2 322 230 231 230
q3 2967 2811 2829 2811
q4 1817 1544 1507 1507
q5 5260 5299 5296 5296
q6 190 115 114 114
q7 2226 1834 1851 1834
q8 3153 3302 3261 3261
q9 8706 8669 8637 8637
q10 3824 3794 3788 3788
q11 550 446 443 443
q12 729 564 519 519
q13 16928 2880 2866 2866
q14 274 256 256 256
q15 503 462 461 461
q16 473 418 438 418
q17 1698 1496 1467 1467
q18 7322 6998 7087 6998
q19 1590 1480 1536 1480
q20 1907 1721 1695 1695
q21 4747 4489 4635 4489
q22 511 465 451 451
Total cold run time: 69846 ms
Total hot run time: 53101 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] [opt](Nereids) support create table with variant type [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #32953:
URL: https://github.com/apache/doris/pull/32953
--
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] [opt](Nereids) support create table with variant type [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024504006
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit e99c7dc118af5670b110ffde28461baa5870383b 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: 13.8 seconds inserted 10000000 Rows, about 724K 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] [opt](Nereids) support create table with variant type [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024538112
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] [opt](Nereids) support create table with variant type [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32953:
URL: https://github.com/apache/doris/pull/32953#issuecomment-2024446704
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