You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XieJiann (via GitHub)" <gi...@apache.org> on 2024/01/24 02:26:04 UTC
[PR] [enhancement](Nereids): relation in constraints should be multi parts [doris]
XieJiann opened a new pull request, #30293:
URL: https://github.com/apache/doris/pull/30293
## Proposed changes
relation in constraints should be multi parts
<!--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] [enhancement](Nereids): relation in constraints should be `multipartIdentifier` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907430991
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] [enhancement](Nereids): relation in constraints should be multi parts [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907276541
<details>
<summary>TPC-DS: <b>Total hot run time: 186967 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 6c48767af5ede2a782be50acc0e259b1dc488762, data reload: false
query1 934 330 329 329
query2 6565 1991 1893 1893
query3 6699 201 202 201
query4 33272 22166 22015 22015
query5 4450 371 374 371
query6 244 151 150 150
query7 4914 264 262 262
query8 223 186 179 179
query9 8353 2581 2558 2558
query10 406 246 231 231
query11 17052 15708 15718 15708
query12 116 70 68 68
query13 1702 371 382 371
query14 10552 7006 6993 6993
query15 209 193 188 188
query16 5800 257 256 256
query17 943 495 479 479
query18 1796 251 254 251
query19 174 131 133 131
query20 74 68 64 64
query21 187 128 133 128
query22 5048 4979 5169 4979
query23 32568 31245 30817 30817
query24 12482 2846 2810 2810
query25 561 318 312 312
query26 1807 147 140 140
query27 3197 289 286 286
query28 7252 1830 1814 1814
query29 1836 640 642 640
query30 279 137 142 137
query31 939 763 760 760
query32 76 53 49 49
query33 709 213 222 213
query34 1144 465 459 459
query35 861 780 759 759
query36 1303 1197 1210 1197
query37 92 60 61 60
query38 3359 3245 3225 3225
query39 1319 1273 1267 1267
query40 344 88 84 84
query41 37 37 35 35
query42 87 83 83 83
query43 528 451 483 451
query44 1069 689 686 686
query45 188 181 175 175
query46 1097 660 678 660
query47 1634 1583 1560 1560
query48 394 308 335 308
query49 1184 288 286 286
query50 675 312 317 312
query51 5260 5157 5216 5157
query52 95 75 80 75
query53 324 257 250 250
query54 240 185 191 185
query55 83 80 74 74
query56 175 176 177 176
query57 980 932 917 917
query58 187 160 160 160
query59 2873 2703 2644 2644
query60 214 205 183 183
query61 84 87 82 82
query62 633 372 362 362
query63 300 261 262 261
query64 6122 1752 1739 1739
query65 3303 3267 3236 3236
query66 1300 305 317 305
query67 15506 15049 14988 14988
query68 12348 512 495 495
query69 605 290 296 290
query70 1620 1535 1492 1492
query71 10487 10196 10197 10196
query72 4902 2818 2815 2815
query73 2518 319 315 315
query74 6945 6387 6366 6366
query75 5057 2268 2340 2268
query76 6694 1004 1020 1004
query77 831 228 240 228
query78 9849 8904 8694 8694
query79 1453 496 498 496
query80 676 323 312 312
query81 446 207 207 207
query82 198 76 82 76
query83 149 117 117 117
query84 270 67 72 67
query85 1084 325 324 324
query86 384 353 381 353
query87 3542 3350 3377 3350
query88 3339 2218 2210 2210
query89 434 356 353 353
query90 2008 187 187 187
query91 167 122 128 122
query92 58 46 44 44
query93 2143 447 433 433
query94 1263 159 160 159
query95 502 449 460 449
query96 610 323 318 318
query97 4331 4157 4174 4157
query98 195 197 185 185
query99 1045 714 701 701
Total cold run time: 310566 ms
Total hot run time: 186967 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] [enhancement](Nereids): relation in constraints should be multi parts [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907281144
<details>
<summary>ClickBench: <b>Total hot run time: 30.68 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 6c48767af5ede2a782be50acc0e259b1dc488762, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.03
query3 0.22 0.04 0.04
query4 1.72 0.06 0.10
query5 0.53 0.52 0.52
query6 1.31 0.64 0.63
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.54 0.50 0.50
query10 0.56 0.56 0.55
query11 0.12 0.09 0.09
query12 0.10 0.09 0.09
query13 0.60 0.61 0.61
query14 0.77 0.81 0.80
query15 0.79 0.77 0.78
query16 0.38 0.39 0.36
query17 1.05 0.99 1.00
query18 0.24 0.25 0.27
query19 1.82 1.80 1.75
query20 0.01 0.02 0.01
query21 15.40 0.58 0.57
query22 2.69 2.47 1.90
query23 17.23 0.74 0.74
query24 2.34 0.73 1.11
query25 0.42 0.19 0.15
query26 0.60 0.15 0.15
query27 0.05 0.04 0.06
query28 11.70 0.76 0.77
query29 12.54 3.10 3.10
query30 0.59 0.50 0.55
query31 2.78 0.35 0.35
query32 3.38 0.50 0.48
query33 3.25 3.24 3.23
query34 15.73 4.26 4.30
query35 4.28 4.32 4.30
query36 1.10 1.07 1.09
query37 0.06 0.05 0.05
query38 0.03 0.02 0.02
query39 0.02 0.01 0.02
query40 0.17 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.38 s
Total hot run time: 30.68 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] [enhancement](Nereids): relation in constraints should be multi parts [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907287600
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 6c48767af5ede2a782be50acc0e259b1dc488762 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 14.7 seconds inserted 10000000 Rows, about 680K 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] [enhancement](Nereids): relation in constraints should be `multipartIdentifier` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907430938
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] [enhancement](Nereids): relation in constraints should be `multipartIdentifier` [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #30293:
URL: https://github.com/apache/doris/pull/30293
--
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] [enhancement](Nereids): relation in constraints should be multi parts [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907267646
<details>
<summary>TPC-H: <b>Total hot run time: 38561 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 6c48767af5ede2a782be50acc0e259b1dc488762, data reload: false
------ Round 1 ----------------------------------
q1 17666 5278 5102 5102
q2 2039 136 131 131
q3 10774 1146 1155 1146
q4 10360 750 789 750
q5 7737 3179 3156 3156
q6 199 120 120 120
q7 856 491 477 477
q8 9225 1914 1932 1914
q9 7277 6339 6324 6324
q10 8210 3023 2989 2989
q11 415 214 203 203
q12 347 191 184 184
q13 17987 3353 3372 3353
q14 251 211 213 211
q15 538 528 489 489
q16 451 367 374 367
q17 929 611 533 533
q18 7300 6909 6758 6758
q19 1542 1397 1357 1357
q20 603 298 285 285
q21 2748 2414 2415 2414
q22 360 298 317 298
Total cold run time: 107814 ms
Total hot run time: 38561 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5445 5470 5403 5403
q2 320 218 214 214
q3 3357 3258 3220 3220
q4 2090 2063 2007 2007
q5 6059 5944 5982 5944
q6 199 115 117 115
q7 2336 1913 1916 1913
q8 3230 3359 3390 3359
q9 8901 8874 8728 8728
q10 3932 3816 3889 3816
q11 569 465 462 462
q12 809 622 639 622
q13 16895 3147 3127 3127
q14 294 246 270 246
q15 548 501 508 501
q16 517 476 467 467
q17 1868 1825 1817 1817
q18 9448 14239 9658 9658
q19 21816 1551 1527 1527
q20 4609 1938 1922 1922
q21 14647 5360 5386 5360
q22 1088 564 537 537
Total cold run time: 108977 ms
Total hot run time: 60965 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] [enhancement](Nereids): relation in constraints should be multi parts [doris]
Posted by "XieJiann (via GitHub)" <gi...@apache.org>.
XieJiann commented on PR #30293:
URL: https://github.com/apache/doris/pull/30293#issuecomment-1907243767
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