You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morningman (via GitHub)" <gi...@apache.org> on 2024/09/06 08:17:19 UTC
[PR] [fix](catalog) should return error if try using a unknown database [doris]
morningman opened a new pull request, #40479:
URL: https://github.com/apache/doris/pull/40479
Previous, when `use db`, and `db` does not exist,
no error return.
But it should return error: `Uknown database xxx`
--
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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2333715862
<details>
<summary>TPC-DS: <b>Total hot run time: 192495 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 f933bfa7dc49aaee6678aa7cb50ee961e0660500, data reload: false
query1 1249 883 879 879
query2 6311 1944 1846 1846
query3 10604 4146 4071 4071
query4 59950 23883 23078 23078
query5 5361 500 491 491
query6 405 168 158 158
query7 5759 288 279 279
query8 311 214 210 210
query9 8796 2491 2460 2460
query10 491 264 257 257
query11 17785 14932 15206 14932
query12 157 107 106 106
query13 1567 386 380 380
query14 11027 7406 7447 7406
query15 229 176 166 166
query16 7230 500 427 427
query17 1119 584 565 565
query18 1925 306 306 306
query19 308 155 154 154
query20 126 112 111 111
query21 210 106 105 105
query22 4562 4672 4640 4640
query23 34257 33391 33351 33351
query24 5963 2841 2795 2795
query25 539 412 405 405
query26 671 149 154 149
query27 1756 274 273 273
query28 3649 2045 2027 2027
query29 667 423 414 414
query30 238 154 148 148
query31 967 790 773 773
query32 80 54 54 54
query33 449 292 286 286
query34 871 478 458 458
query35 839 716 732 716
query36 1079 938 945 938
query37 143 91 85 85
query38 3915 3908 3813 3813
query39 1447 1391 1393 1391
query40 203 120 114 114
query41 48 49 47 47
query42 112 93 95 93
query43 518 473 500 473
query44 1075 746 736 736
query45 201 170 170 170
query46 1085 746 736 736
query47 1909 1815 1859 1815
query48 367 281 295 281
query49 792 457 459 457
query50 810 401 414 401
query51 6929 6923 6855 6855
query52 98 85 87 85
query53 249 175 176 175
query54 553 446 455 446
query55 75 77 75 75
query56 275 267 265 265
query57 1174 1091 1062 1062
query58 226 239 243 239
query59 3127 3057 2820 2820
query60 293 276 282 276
query61 127 125 121 121
query62 747 650 661 650
query63 222 198 197 197
query64 2557 677 677 677
query65 3182 3104 3115 3104
query66 688 326 329 326
query67 15431 15183 15374 15183
query68 4329 561 556 556
query69 434 274 281 274
query70 1181 1134 1093 1093
query71 368 266 270 266
query72 6546 3974 3971 3971
query73 745 314 319 314
query74 9263 8722 8801 8722
query75 3339 2679 2677 2677
query76 1696 1010 1001 1001
query77 559 320 326 320
query78 10248 9253 9290 9253
query79 1079 538 523 523
query80 871 492 508 492
query81 545 231 225 225
query82 933 139 142 139
query83 172 152 149 149
query84 261 71 76 71
query85 827 280 268 268
query86 309 292 296 292
query87 4406 4213 4356 4213
query88 3051 2303 2272 2272
query89 390 288 284 284
query90 1900 185 179 179
query91 118 94 99 94
query92 60 49 48 48
query93 1260 523 524 523
query94 734 286 288 286
query95 347 247 249 247
query96 581 259 264 259
query97 3212 3058 3039 3039
query98 265 193 207 193
query99 1604 1270 1270 1270
Total cold run time: 307718 ms
Total hot run time: 192495 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](catalog) should return error if try using a unknown database [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360110175
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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2358209546
<details>
<summary>TPC-DS: <b>Total hot run time: 195123 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 4e8e2788dfab34453c4a7fe20bf5b2736267ec99, data reload: false
query1 987 365 358 358
query2 6519 2127 2076 2076
query3 6702 214 226 214
query4 34318 23518 23385 23385
query5 4318 466 442 442
query6 259 168 158 158
query7 4618 300 313 300
query8 279 221 226 221
query9 9441 2644 2641 2641
query10 451 273 294 273
query11 18220 15256 15306 15256
query12 154 97 96 96
query13 1632 415 396 396
query14 10412 7471 7431 7431
query15 254 172 177 172
query16 8005 452 462 452
query17 1661 585 566 566
query18 2027 316 308 308
query19 362 144 154 144
query20 118 111 107 107
query21 212 106 105 105
query22 4373 4223 4322 4223
query23 34548 34023 34346 34023
query24 11220 2902 2889 2889
query25 648 402 419 402
query26 1248 163 164 163
query27 2792 285 280 280
query28 8104 2468 2444 2444
query29 862 425 428 425
query30 329 158 155 155
query31 1025 775 838 775
query32 97 59 58 58
query33 777 301 298 298
query34 940 483 493 483
query35 846 707 718 707
query36 1135 949 962 949
query37 152 88 89 88
query38 4044 3872 3987 3872
query39 1463 1443 1424 1424
query40 205 99 100 99
query41 50 51 47 47
query42 126 104 99 99
query43 532 493 507 493
query44 1236 827 800 800
query45 197 164 165 164
query46 1145 717 763 717
query47 1871 1798 1820 1798
query48 462 368 369 368
query49 1144 403 404 403
query50 827 399 403 399
query51 7002 6919 6919 6919
query52 101 92 88 88
query53 255 180 182 180
query54 1181 465 477 465
query55 79 78 80 78
query56 291 271 274 271
query57 1227 1085 1098 1085
query58 252 254 244 244
query59 3165 3078 2841 2841
query60 320 278 274 274
query61 218 109 104 104
query62 838 671 657 657
query63 220 186 187 186
query64 5264 642 630 630
query65 3292 3208 3189 3189
query66 1233 308 325 308
query67 15972 15631 15513 15513
query68 3519 879 857 857
query69 450 347 343 343
query70 1187 1190 1138 1138
query71 344 325 335 325
query72 6148 3362 3381 3362
query73 588 588 579 579
query74 9290 8973 9080 8973
query75 3068 2941 2906 2906
query76 2047 863 872 863
query77 434 347 377 347
query78 9416 9219 9461 9219
query79 925 883 878 878
query80 606 589 581 581
query81 450 262 253 253
query82 234 227 232 227
query83 159 156 158 156
query84 231 97 100 97
query85 671 385 350 350
query86 319 327 312 312
query87 4544 4462 4449 4449
query88 4824 4084 4081 4081
query89 377 351 358 351
query90 1424 308 310 308
query91 160 171 185 171
query92 78 75 71 71
query93 899 900 897 897
query94 502 361 349 349
query95 422 405 407 405
query96 491 488 485 485
query97 3136 3106 3105 3105
query98 223 224 227 224
query99 1403 1307 1283 1283
Total cold run time: 292826 ms
Total hot run time: 195123 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](catalog) should return error if try using a unknown database [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #40479:
URL: https://github.com/apache/doris/pull/40479
--
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](catalog) should return error if try using a unknown database [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360123468
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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360180427
<details>
<summary>TPC-H: <b>Total hot run time: 41471 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 1f4490afc9bd3f7e297e2f0cffcc83c3709e4af3, data reload: false
------ Round 1 ----------------------------------
q1 17585 7387 7240 7240
q2 2065 154 161 154
q3 10661 1104 1158 1104
q4 10564 750 733 733
q5 7790 3080 3076 3076
q6 238 150 149 149
q7 1014 631 616 616
q8 9459 2048 2036 2036
q9 6859 6422 6426 6422
q10 7056 2325 2274 2274
q11 461 247 255 247
q12 403 218 217 217
q13 17789 2981 3002 2981
q14 239 210 206 206
q15 571 532 528 528
q16 690 628 609 609
q17 997 788 797 788
q18 7145 6743 6638 6638
q19 1409 1041 989 989
q20 576 282 289 282
q21 4040 3202 3274 3202
q22 1116 1033 980 980
Total cold run time: 108727 ms
Total hot run time: 41471 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7344 7231 7245 7231
q2 331 234 231 231
q3 2993 2935 2961 2935
q4 2002 1839 1812 1812
q5 5609 5624 5593 5593
q6 228 149 142 142
q7 2251 1825 1781 1781
q8 3315 3448 3389 3389
q9 8838 8822 8781 8781
q10 3518 3439 3459 3439
q11 589 510 485 485
q12 809 614 622 614
q13 9999 3159 3135 3135
q14 289 273 269 269
q15 588 525 523 523
q16 726 696 686 686
q17 1813 1623 1581 1581
q18 8250 7926 7829 7829
q19 1744 1565 1591 1565
q20 2129 1889 1871 1871
q21 5559 5408 5575 5408
q22 1132 1061 1039 1039
Total cold run time: 70056 ms
Total hot run time: 60339 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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2333505307
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](catalog) should return error if try using a unknown database [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2333511905
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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360215631
<details>
<summary>ClickBench: <b>Total hot run time: 32.83 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 1f4490afc9bd3f7e297e2f0cffcc83c3709e4af3, data reload: false
query1 0.05 0.05 0.04
query2 0.07 0.03 0.02
query3 0.22 0.06 0.06
query4 1.65 0.10 0.11
query5 0.51 0.50 0.51
query6 1.13 0.73 0.72
query7 0.02 0.02 0.02
query8 0.04 0.04 0.03
query9 0.57 0.50 0.49
query10 0.54 0.55 0.54
query11 0.15 0.10 0.11
query12 0.14 0.11 0.11
query13 0.61 0.61 0.59
query14 2.98 2.97 2.94
query15 0.90 0.83 0.83
query16 0.35 0.38 0.38
query17 0.98 1.00 1.06
query18 0.19 0.19 0.20
query19 1.96 1.87 2.00
query20 0.01 0.01 0.01
query21 15.35 0.58 0.56
query22 2.36 2.11 2.19
query23 17.34 0.73 0.70
query24 2.42 0.84 2.00
query25 0.19 0.22 0.08
query26 0.49 0.13 0.14
query27 0.04 0.04 0.04
query28 10.49 1.09 1.08
query29 12.56 3.28 3.22
query30 0.25 0.06 0.07
query31 2.86 0.38 0.38
query32 3.26 0.46 0.46
query33 2.99 3.04 3.09
query34 16.88 4.44 4.41
query35 4.48 4.47 4.44
query36 0.68 0.48 0.51
query37 0.08 0.06 0.05
query38 0.05 0.03 0.04
query39 0.03 0.02 0.02
query40 0.15 0.12 0.11
query41 0.08 0.02 0.02
query42 0.03 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.16 s
Total hot run time: 32.83 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](catalog) should return error if try using a unknown database [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2358151424
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](catalog) should return error if try using a unknown database [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360123549
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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2333726004
<details>
<summary>ClickBench: <b>Total hot run time: 31.4 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 f933bfa7dc49aaee6678aa7cb50ee961e0660500, data reload: false
query1 0.05 0.04 0.04
query2 0.08 0.03 0.04
query3 0.22 0.05 0.05
query4 1.69 0.08 0.07
query5 0.51 0.50 0.48
query6 1.13 0.72 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.48
query10 0.53 0.55 0.55
query11 0.15 0.12 0.12
query12 0.15 0.12 0.12
query13 0.60 0.59 0.60
query14 1.39 1.40 1.42
query15 0.83 0.82 0.81
query16 0.37 0.36 0.36
query17 0.97 0.99 1.02
query18 0.21 0.21 0.20
query19 1.93 1.85 1.76
query20 0.01 0.01 0.01
query21 15.39 0.66 0.65
query22 4.46 7.31 2.19
query23 18.27 1.30 1.22
query24 2.11 0.22 0.22
query25 0.14 0.08 0.08
query26 0.27 0.18 0.17
query27 0.09 0.08 0.08
query28 13.34 1.02 0.98
query29 12.62 3.31 3.29
query30 0.25 0.05 0.06
query31 2.89 0.39 0.39
query32 3.26 0.47 0.48
query33 2.94 2.97 2.94
query34 17.19 4.38 4.38
query35 4.41 4.39 4.39
query36 0.64 0.46 0.48
query37 0.20 0.16 0.16
query38 0.15 0.14 0.14
query39 0.05 0.04 0.04
query40 0.16 0.13 0.14
query41 0.10 0.06 0.05
query42 0.06 0.06 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.47 s
Total hot run time: 31.4 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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2333694263
<details>
<summary>TPC-H: <b>Total hot run time: 38026 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 f933bfa7dc49aaee6678aa7cb50ee961e0660500, data reload: false
------ Round 1 ----------------------------------
q1 18108 4456 4336 4336
q2 2025 188 191 188
q3 11064 948 1187 948
q4 10367 698 799 698
q5 7746 2880 2892 2880
q6 227 138 134 134
q7 969 611 587 587
q8 9299 2091 2103 2091
q9 7100 6589 6553 6553
q10 6995 2221 2200 2200
q11 469 245 242 242
q12 403 221 228 221
q13 19043 3070 3053 3053
q14 276 235 249 235
q15 533 480 489 480
q16 509 434 411 411
q17 989 716 685 685
q18 7385 6897 6886 6886
q19 1407 1049 963 963
q20 713 337 325 325
q21 3902 3024 2906 2906
q22 1121 1004 1017 1004
Total cold run time: 110650 ms
Total hot run time: 38026 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4404 4273 4263 4263
q2 394 268 272 268
q3 2849 2635 2627 2627
q4 1953 1700 1700 1700
q5 5632 5717 5785 5717
q6 225 147 139 139
q7 2247 1826 1788 1788
q8 3298 3484 3496 3484
q9 8767 8830 8797 8797
q10 3599 3381 3390 3381
q11 623 495 507 495
q12 828 679 659 659
q13 12796 3127 3283 3127
q14 318 283 285 283
q15 546 483 505 483
q16 531 484 512 484
q17 1818 1497 1510 1497
q18 8306 7822 7752 7752
q19 1728 1518 1504 1504
q20 2132 1901 1883 1883
q21 5828 5359 5521 5359
q22 1124 1029 1036 1029
Total cold run time: 69946 ms
Total hot run time: 56719 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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2360205021
<details>
<summary>TPC-DS: <b>Total hot run time: 195478 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 1f4490afc9bd3f7e297e2f0cffcc83c3709e4af3, data reload: false
query1 1243 866 879 866
query2 6398 2139 2078 2078
query3 10741 3811 3915 3811
query4 64369 27126 23773 23773
query5 5223 497 470 470
query6 425 175 177 175
query7 5500 301 304 301
query8 317 232 235 232
query9 8995 2688 2651 2651
query10 465 304 278 278
query11 18049 15220 15752 15220
query12 168 102 103 102
query13 1508 422 417 417
query14 11002 7187 7685 7187
query15 224 176 170 170
query16 7009 514 504 504
query17 1214 621 600 600
query18 1748 319 319 319
query19 216 157 154 154
query20 127 108 108 108
query21 211 115 107 107
query22 4829 4381 4561 4381
query23 34527 33905 33894 33894
query24 6016 2996 2903 2903
query25 527 405 410 405
query26 634 164 166 164
query27 1594 290 287 287
query28 4190 2468 2432 2432
query29 689 451 435 435
query30 236 158 156 156
query31 963 777 791 777
query32 80 57 59 57
query33 404 299 313 299
query34 898 509 487 487
query35 848 731 746 731
query36 1091 965 951 951
query37 145 92 89 89
query38 4003 3985 3911 3911
query39 1487 1418 1419 1418
query40 210 101 99 99
query41 51 49 48 48
query42 123 100 95 95
query43 529 503 486 486
query44 1167 810 794 794
query45 194 163 166 163
query46 1149 777 769 769
query47 1876 1799 1837 1799
query48 472 367 364 364
query49 673 384 405 384
query50 841 412 422 412
query51 6953 6797 6929 6797
query52 98 88 84 84
query53 254 186 182 182
query54 584 474 457 457
query55 76 80 75 75
query56 280 270 292 270
query57 1222 1097 1092 1092
query58 225 241 236 236
query59 3232 2924 2900 2900
query60 289 273 270 270
query61 108 107 105 105
query62 752 656 626 626
query63 232 182 185 182
query64 1416 657 623 623
query65 3291 3206 3182 3182
query66 677 302 298 298
query67 15883 15408 15562 15408
query68 4525 591 570 570
query69 455 316 307 307
query70 1217 1128 1099 1099
query71 347 280 281 280
query72 6387 4014 4002 4002
query73 805 328 330 328
query74 9594 8946 9146 8946
query75 3368 2664 2677 2664
query76 1922 989 855 855
query77 546 325 314 314
query78 9856 9152 9921 9152
query79 1084 564 548 548
query80 1068 481 453 453
query81 560 237 245 237
query82 295 146 141 141
query83 157 159 136 136
query84 285 80 73 73
query85 965 299 280 280
query86 376 296 308 296
query87 4573 4306 4402 4306
query88 3552 2354 2350 2350
query89 396 286 287 286
query90 1928 188 189 188
query91 180 145 147 145
query92 74 51 49 49
query93 1105 540 539 539
query94 786 302 291 291
query95 352 261 249 249
query96 622 280 286 280
query97 3242 3123 3115 3115
query98 213 199 199 199
query99 1720 1327 1300 1300
Total cold run time: 313725 ms
Total hot run time: 195478 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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2358219775
<details>
<summary>ClickBench: <b>Total hot run time: 33.09 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 4e8e2788dfab34453c4a7fe20bf5b2736267ec99, data reload: false
query1 0.05 0.04 0.04
query2 0.06 0.03 0.03
query3 0.23 0.06 0.06
query4 1.65 0.10 0.09
query5 0.50 0.49 0.51
query6 1.14 0.72 0.73
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.57 0.49 0.50
query10 0.55 0.56 0.57
query11 0.14 0.10 0.11
query12 0.14 0.11 0.11
query13 0.61 0.59 0.59
query14 2.98 2.94 3.08
query15 0.88 0.83 0.82
query16 0.37 0.37 0.39
query17 1.03 1.04 1.04
query18 0.22 0.21 0.20
query19 1.94 1.81 2.00
query20 0.01 0.01 0.02
query21 15.38 0.62 0.59
query22 2.61 2.57 1.72
query23 16.83 0.84 0.82
query24 3.02 1.39 1.47
query25 0.27 0.14 0.14
query26 0.38 0.13 0.13
query27 0.05 0.04 0.04
query28 10.07 1.10 1.08
query29 12.60 3.30 3.26
query30 0.25 0.06 0.06
query31 2.85 0.38 0.38
query32 3.29 0.47 0.46
query33 3.00 3.00 3.02
query34 16.97 4.38 4.36
query35 4.46 4.38 4.43
query36 0.67 0.49 0.51
query37 0.08 0.05 0.06
query38 0.04 0.04 0.03
query39 0.03 0.02 0.02
query40 0.16 0.12 0.13
query41 0.08 0.02 0.02
query42 0.04 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 106.3 s
Total hot run time: 33.09 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](catalog) should return error if try using a unknown database [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40479:
URL: https://github.com/apache/doris/pull/40479#issuecomment-2358186321
<details>
<summary>TPC-H: <b>Total hot run time: 41452 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 4e8e2788dfab34453c4a7fe20bf5b2736267ec99, data reload: false
------ Round 1 ----------------------------------
q1 17618 7297 7214 7214
q2 2061 160 158 158
q3 11394 1170 1205 1170
q4 10345 774 708 708
q5 7780 3121 3099 3099
q6 243 150 151 150
q7 1034 626 633 626
q8 9646 2002 2053 2002
q9 6930 6451 6390 6390
q10 6985 2281 2282 2281
q11 439 253 240 240
q12 409 218 214 214
q13 17780 2948 2973 2948
q14 247 212 234 212
q15 582 525 528 525
q16 672 632 615 615
q17 974 818 817 817
q18 7331 6772 6558 6558
q19 1389 1065 1074 1065
q20 607 302 273 273
q21 3993 3305 3186 3186
q22 1085 1006 1001 1001
Total cold run time: 109544 ms
Total hot run time: 41452 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7206 7196 7215 7196
q2 318 229 223 223
q3 2904 2783 2810 2783
q4 1925 1717 1743 1717
q5 5361 5394 5369 5369
q6 227 140 140 140
q7 2081 1718 1708 1708
q8 3159 3287 3276 3276
q9 8419 8326 8354 8326
q10 3350 3329 3362 3329
q11 568 474 474 474
q12 776 561 582 561
q13 6717 3003 3002 3002
q14 286 257 250 250
q15 560 516 508 508
q16 707 678 685 678
q17 1770 1548 1539 1539
q18 7622 7466 7288 7288
q19 1659 1553 1520 1520
q20 2029 1811 1796 1796
q21 5344 5121 5068 5068
q22 1096 1009 998 998
Total cold run time: 64084 ms
Total hot run time: 57749 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