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/01/22 08:51:50 UTC
[PR] [fix](Nereids) user identify syntax is wrong [doris]
morrySnow opened a new pull request, #30226:
URL: https://github.com/apache/doris/pull/30226
## 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) user identify syntax is wrong [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #30226:
URL: https://github.com/apache/doris/pull/30226
--
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) user identify syntax is wrong [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903584848
<details>
<summary>ClickBench: <b>Total hot run time: 30.91 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 50e046b9aa1da1f7243e784d8d794b31e9804689, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.22 0.04 0.05
query4 1.70 0.09 0.07
query5 0.53 0.52 0.52
query6 1.31 0.64 0.63
query7 0.02 0.02 0.01
query8 0.04 0.03 0.03
query9 0.55 0.51 0.50
query10 0.55 0.56 0.57
query11 0.11 0.08 0.09
query12 0.11 0.09 0.09
query13 0.61 0.62 0.61
query14 0.78 0.83 0.77
query15 0.79 0.78 0.78
query16 0.37 0.38 0.36
query17 1.00 1.01 0.97
query18 0.23 0.24 0.26
query19 1.82 1.79 1.68
query20 0.02 0.01 0.01
query21 15.41 0.58 0.59
query22 2.73 2.09 1.57
query23 17.11 0.90 0.73
query24 2.52 1.32 1.30
query25 0.45 0.30 0.18
query26 0.55 0.14 0.13
query27 0.06 0.05 0.05
query28 10.99 0.78 0.76
query29 12.53 3.24 3.17
query30 0.51 0.49 0.53
query31 2.78 0.35 0.36
query32 3.36 0.47 0.49
query33 3.20 3.26 3.22
query34 15.66 4.30 4.33
query35 4.35 4.44 4.27
query36 1.11 1.09 1.08
query37 0.06 0.05 0.05
query38 0.03 0.03 0.03
query39 0.02 0.01 0.02
query40 0.15 0.13 0.13
query41 0.08 0.01 0.01
query42 0.03 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 104.57 s
Total hot run time: 30.91 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](Nereids) user identify syntax is wrong [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903630767
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) user identify syntax is wrong [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903575457
<details>
<summary>TPC-DS: <b>Total hot run time: 176492 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 50e046b9aa1da1f7243e784d8d794b31e9804689, data reload: false
query1 962 332 332 332
query2 6552 2137 1865 1865
query3 6705 198 195 195
query4 32275 22213 22296 22213
query5 4457 423 441 423
query6 253 155 154 154
query7 4595 263 258 258
query8 234 178 185 178
query9 8318 2507 2495 2495
query10 444 238 227 227
query11 16795 15501 15434 15434
query12 120 70 66 66
query13 1671 382 392 382
query14 10591 7014 6986 6986
query15 208 195 182 182
query16 5793 253 251 251
query17 942 474 468 468
query18 1794 265 256 256
query19 177 135 130 130
query20 72 82 70 70
query21 184 132 131 131
query22 4904 4686 4700 4686
query23 31521 30877 30842 30842
query24 12461 2850 2790 2790
query25 578 318 308 308
query26 1673 154 147 147
query27 3205 291 288 288
query28 7315 1833 1838 1833
query29 1741 625 622 622
query30 282 137 137 137
query31 939 760 747 747
query32 73 51 48 48
query33 701 215 216 215
query34 1136 450 460 450
query35 911 751 733 733
query36 1247 1197 1200 1197
query37 94 62 60 60
query38 3401 3299 3198 3198
query39 1302 1262 1267 1262
query40 348 90 84 84
query41 40 36 35 35
query42 90 83 79 79
query43 513 497 473 473
query44 1064 691 683 683
query45 197 180 173 173
query46 1059 644 654 644
query47 1666 1531 1595 1531
query48 387 309 315 309
query49 1167 286 275 275
query50 685 309 323 309
query51 5324 5240 5229 5229
query52 93 81 76 76
query53 327 253 258 253
query54 243 176 179 176
query55 80 85 75 75
query56 172 170 173 170
query57 1048 931 943 931
query58 178 162 157 157
query59 2969 2698 2859 2698
query60 212 180 185 180
query61 83 90 83 83
query62 582 375 365 365
query63 287 267 259 259
query64 6052 1778 1753 1753
query65 3332 3253 3215 3215
query66 1276 319 314 314
query67 15816 15054 14965 14965
query68 12409 540 516 516
query69 626 311 300 300
query70 1609 1481 1406 1406
query71 547 217 219 217
query72 4865 2840 2848 2840
query73 2618 317 316 316
query74 7009 6412 6354 6354
query75 5013 2316 2304 2304
query76 6676 1020 1042 1020
query77 658 232 230 230
query78 9342 8799 8730 8730
query79 977 491 500 491
query80 547 318 312 312
query81 444 209 202 202
query82 201 82 84 82
query83 142 118 119 118
query84 276 73 71 71
query85 1090 337 324 324
query86 391 370 388 370
query87 3479 3343 3298 3298
query88 2989 2181 2182 2181
query89 423 364 339 339
query90 1975 189 183 183
query91 171 130 136 130
query92 51 43 44 43
query93 1306 461 414 414
query94 1212 156 157 156
query95 490 462 447 447
query96 615 317 325 317
query97 4283 4130 4186 4130
query98 204 186 197 186
query99 1068 712 730 712
Total cold run time: 295622 ms
Total hot run time: 176492 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) user identify syntax is wrong [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903518225
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) user identify syntax is wrong [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903630831
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) user identify syntax is wrong [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903552400
<details>
<summary>TPC-H: <b>Total hot run time: 39023 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 50e046b9aa1da1f7243e784d8d794b31e9804689, data reload: false
------ Round 1 ----------------------------------
q1 18842 5342 5401 5342
q2 2123 149 137 137
q3 11319 1205 1172 1172
q4 10604 811 822 811
q5 8209 3216 3145 3145
q6 193 122 119 119
q7 863 504 484 484
q8 9222 1957 1958 1957
q9 7266 6411 6375 6375
q10 8222 3041 3002 3002
q11 421 215 207 207
q12 352 187 189 187
q13 18012 3351 3343 3343
q14 245 224 207 207
q15 540 510 535 510
q16 440 379 373 373
q17 931 513 500 500
q18 7613 7004 6832 6832
q19 1551 1380 1375 1375
q20 565 309 285 285
q21 2925 2401 2356 2356
q22 352 318 304 304
Total cold run time: 110810 ms
Total hot run time: 39023 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5481 5190 5470 5190
q2 330 217 221 217
q3 3383 3185 3215 3185
q4 2103 2059 2022 2022
q5 5890 5913 5932 5913
q6 197 114 116 114
q7 2310 1901 1947 1901
q8 3223 3383 3392 3383
q9 8970 9024 9544 9024
q10 3910 3742 3809 3742
q11 565 449 453 449
q12 796 618 614 614
q13 16966 3163 3115 3115
q14 298 257 258 257
q15 548 496 504 496
q16 514 473 459 459
q17 1850 1821 1879 1821
q18 9566 17091 9471 9471
q19 26862 1598 1525 1525
q20 4603 1943 1894 1894
q21 14502 5423 5388 5388
q22 990 539 554 539
Total cold run time: 113857 ms
Total hot run time: 60719 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) user identify syntax is wrong [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30226:
URL: https://github.com/apache/doris/pull/30226#issuecomment-1903590122
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 50e046b9aa1da1f7243e784d8d794b31e9804689 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.6 seconds inserted 10000000 Rows, about 735K 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