You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "eldenmoon (via GitHub)" <gi...@apache.org> on 2024/03/27 05:11:29 UTC
[PR] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
eldenmoon opened a new pull request, #32884:
URL: https://github.com/apache/doris/pull/32884
## 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2021947970
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2021973126
<details>
<summary>TPC-H: <b>Total hot run time: 38200 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 a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c, data reload: false
------ Round 1 ----------------------------------
q1 17614 4198 4141 4141
q2 2111 153 155 153
q3 10637 1179 1218 1179
q4 10229 756 771 756
q5 7463 3001 2976 2976
q6 207 125 124 124
q7 1047 598 577 577
q8 9350 2007 2016 2007
q9 7226 6614 6592 6592
q10 8360 3469 3577 3469
q11 420 238 221 221
q12 361 199 196 196
q13 17791 2868 2893 2868
q14 242 204 205 204
q15 492 467 462 462
q16 477 372 372 372
q17 950 523 627 523
q18 7062 6508 6536 6508
q19 1553 1477 1414 1414
q20 541 254 250 250
q21 3682 2988 2899 2899
q22 349 319 309 309
Total cold run time: 108164 ms
Total hot run time: 38200 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4064 4183 4132 4132
q2 322 231 225 225
q3 2972 2889 2856 2856
q4 1851 1507 1550 1507
q5 5339 5336 5351 5336
q6 196 117 116 116
q7 2283 1844 1865 1844
q8 3159 3273 3262 3262
q9 8708 8705 8729 8705
q10 3766 3815 3737 3737
q11 566 443 446 443
q12 747 567 552 552
q13 16909 2932 2879 2879
q14 280 256 266 256
q15 494 452 465 452
q16 472 433 432 432
q17 1740 1509 1479 1479
q18 7380 7174 7122 7122
q19 1610 1554 1528 1528
q20 1902 1718 1709 1709
q21 4896 4724 4763 4724
q22 542 472 483 472
Total cold run time: 70198 ms
Total hot run time: 53768 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "qidaye (via GitHub)" <gi...@apache.org>.
qidaye merged PR #32884:
URL: https://github.com/apache/doris/pull/32884
--
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2026634267
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2021994634
<details>
<summary>TPC-DS: <b>Total hot run time: 181786 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 a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c, data reload: false
query1 930 376 355 355
query2 6763 1885 1890 1885
query3 6701 215 219 215
query4 31779 21425 21358 21358
query5 4310 395 407 395
query6 267 171 182 171
query7 4640 298 300 298
query8 233 176 185 176
query9 9331 2277 2262 2262
query10 561 251 259 251
query11 14650 14291 14212 14212
query12 139 92 87 87
query13 1633 430 417 417
query14 9530 8036 7940 7940
query15 263 194 201 194
query16 8242 260 275 260
query17 1971 567 562 562
query18 2108 291 287 287
query19 334 162 166 162
query20 94 90 92 90
query21 210 128 125 125
query22 4958 4842 4802 4802
query23 33784 32446 32966 32446
query24 11846 2885 2837 2837
query25 654 392 379 379
query26 1773 158 158 158
query27 3087 357 362 357
query28 7793 1874 1916 1874
query29 1041 660 623 623
query30 306 149 148 148
query31 954 718 734 718
query32 102 57 57 57
query33 774 257 260 257
query34 1131 487 488 487
query35 848 611 609 609
query36 998 874 895 874
query37 276 66 65 65
query38 3582 3456 3463 3456
query39 1489 1470 1449 1449
query40 292 116 113 113
query41 53 48 49 48
query42 105 99 104 99
query43 497 473 457 457
query44 1144 746 736 736
query45 279 249 262 249
query46 1109 709 702 702
query47 1924 1847 1842 1842
query48 453 362 359 359
query49 1240 335 345 335
query50 771 371 378 371
query51 6649 6610 6594 6594
query52 109 95 92 92
query53 351 276 274 274
query54 324 253 236 236
query55 87 77 79 77
query56 240 235 227 227
query57 1205 1141 1159 1141
query58 238 211 210 210
query59 2759 2654 2479 2479
query60 274 245 254 245
query61 134 108 122 108
query62 663 463 453 453
query63 301 281 275 275
query64 6332 4031 4077 4031
query65 3112 3026 3034 3026
query66 1433 388 353 353
query67 15534 15158 14916 14916
query68 9117 553 539 539
query69 654 383 378 378
query70 1402 1096 1102 1096
query71 522 262 257 257
query72 6401 2718 2551 2551
query73 1648 326 316 316
query74 6890 6448 6393 6393
query75 3774 2218 2226 2218
query76 5449 878 901 878
query77 648 259 255 255
query78 10928 10280 10084 10084
query79 10932 539 533 533
query80 1417 371 366 366
query81 501 223 214 214
query82 234 87 83 83
query83 208 146 150 146
query84 295 76 78 76
query85 1083 313 311 311
query86 347 309 292 292
query87 3794 3525 3521 3521
query88 5599 2402 2375 2375
query89 489 365 377 365
query90 2080 180 174 174
query91 165 139 138 138
query92 65 46 47 46
query93 6226 509 496 496
query94 1320 172 173 172
query95 420 333 330 330
query96 618 270 275 270
query97 2652 2477 2470 2470
query98 226 221 210 210
query99 1072 906 887 887
Total cold run time: 314873 ms
Total hot run time: 181786 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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2026634247
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2021947823
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] [Bug](Variant) forbit variant column with filter, group by or order by [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32884:
URL: https://github.com/apache/doris/pull/32884#issuecomment-2022003780
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a3e91b71e9205f1a46e969f09cb50cb3a85fcb0c 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: 14.1 seconds inserted 10000000 Rows, about 709K 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