You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zzzxl1993 (via GitHub)" <gi...@apache.org> on 2024/02/20 06:47:47 UTC
[PR] [feature](invert index) match_phrase_edge feature added [doris]
zzzxl1993 opened a new pull request, #31142:
URL: https://github.com/apache/doris/pull/31142
## 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953581897
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953696394
<details>
<summary>ClickBench: <b>Total hot run time: 30.58 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 1350e8606ed015ddb2f0e08d58747a6b424a6fa5, data reload: false
query1 0.03 0.02 0.03
query2 0.06 0.02 0.02
query3 0.22 0.07 0.07
query4 1.65 0.08 0.08
query5 0.49 0.48 0.47
query6 1.42 0.61 0.62
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.54 0.46 0.45
query10 0.49 0.50 0.49
query11 0.13 0.10 0.10
query12 0.11 0.10 0.10
query13 0.59 0.59 0.58
query14 0.77 0.79 0.78
query15 0.82 0.81 0.80
query16 0.34 0.34 0.33
query17 0.90 0.89 0.90
query18 0.18 0.15 0.17
query19 1.69 1.67 1.63
query20 0.01 0.01 0.01
query21 15.40 0.62 0.57
query22 2.85 4.76 1.86
query23 17.41 1.13 0.98
query24 2.00 0.62 0.52
query25 0.59 0.07 0.06
query26 0.17 0.14 0.14
query27 0.06 0.05 0.05
query28 11.88 0.86 0.80
query29 12.56 3.27 3.43
query30 0.53 0.48 0.49
query31 2.78 0.37 0.36
query32 3.34 0.47 0.48
query33 3.15 3.17 3.16
query34 15.36 4.52 4.50
query35 4.51 4.52 4.53
query36 1.05 0.94 0.96
query37 0.07 0.05 0.06
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.15 0.14
query41 0.08 0.01 0.01
query42 0.02 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 104.56 s
Total hot run time: 30.58 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953675113
TeamCity be ut coverage result:
Function Coverage: 35.75% (8559/23940)
Line Coverage: 27.70% (69410/250534)
Region Coverage: 26.82% (36013/134278)
Branch Coverage: 23.63% (18419/77940)
Coverage Report: http://coverage.selectdb-in.cc/coverage/1350e8606ed015ddb2f0e08d58747a6b424a6fa5_1350e8606ed015ddb2f0e08d58747a6b424a6fa5/report/index.html
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968719148
<details>
<summary>ClickBench: <b>Total hot run time: 31.41 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 80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e, data reload: false
query1 0.04 0.04 0.02
query2 0.07 0.03 0.02
query3 0.23 0.06 0.05
query4 1.68 0.10 0.09
query5 0.52 0.52 0.52
query6 1.25 0.66 0.66
query7 0.02 0.02 0.02
query8 0.04 0.02 0.02
query9 0.56 0.50 0.51
query10 0.57 0.59 0.56
query11 0.13 0.10 0.09
query12 0.13 0.10 0.10
query13 0.63 0.62 0.62
query14 0.80 0.78 0.82
query15 0.83 0.82 0.81
query16 0.38 0.37 0.37
query17 0.99 0.94 0.96
query18 0.25 0.25 0.26
query19 1.76 1.73 1.68
query20 0.01 0.00 0.01
query21 15.42 0.62 0.56
query22 3.30 3.81 1.84
query23 17.61 1.03 1.00
query24 1.99 0.78 0.21
query25 0.42 0.14 0.07
query26 0.17 0.16 0.16
query27 0.04 0.05 0.04
query28 12.09 0.84 0.85
query29 12.52 3.37 3.32
query30 0.52 0.51 0.55
query31 2.78 0.35 0.36
query32 3.36 0.47 0.48
query33 3.20 3.22 3.20
query34 15.35 4.74 4.74
query35 4.75 4.73 4.70
query36 1.13 1.06 1.06
query37 0.07 0.05 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.18 0.13 0.13
query41 0.07 0.02 0.01
query42 0.03 0.01 0.02
query43 0.02 0.02 0.01
Total cold run time: 105.97 s
Total hot run time: 31.41 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1970964060
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968724572
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 18.9 seconds inserted 10000000 Rows, about 529K 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968573204
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953700936
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 1350e8606ed015ddb2f0e08d58747a6b424a6fa5 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.5 seconds inserted 10000000 Rows, about 740K 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on code in PR #31142:
URL: https://github.com/apache/doris/pull/31142#discussion_r1495324059
##########
be/src/vec/functions/match.h:
##########
@@ -159,6 +159,23 @@ class FunctionMatchRegexp : public FunctionMatchBase {
}
};
+class FunctionMatchPhraseEdge : public FunctionMatchBase {
+public:
+ static constexpr auto name = "match_phrase_edge";
+ static FunctionPtr create() { return std::make_shared<FunctionMatchPhraseEdge>(); }
+
+ String get_name() const override { return name; }
+
+ Status execute_match(const std::string& column_name, const std::string& match_query_str,
Review Comment:
warning: method 'execute_match' can be made static [readability-convert-member-functions-to-static]
```suggestion
static Status execute_match(const std::string& column_name, const std::string& match_query_str,
```
be/src/vec/functions/match.h:172:
```diff
- ColumnUInt8::Container& result) const override {
+ ColumnUInt8::Container& result) override {
```
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953672255
<details>
<summary>TPC-H: <b>Total hot run time: 41725 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 1350e8606ed015ddb2f0e08d58747a6b424a6fa5, data reload: false
------ Round 1 ----------------------------------
q1 17644 4998 4905 4905
q2 2041 147 134 134
q3 10569 1006 996 996
q4 4651 960 989 960
q5 7739 3263 3306 3263
q6 197 139 131 131
q7 1269 790 780 780
q8 9275 2118 2099 2099
q9 8121 6734 6739 6734
q10 8316 2650 2652 2650
q11 421 233 203 203
q12 815 337 328 328
q13 18008 3706 3635 3635
q14 293 257 264 257
q15 656 528 504 504
q16 482 425 420 420
q17 946 918 901 901
q18 7523 6700 6739 6700
q19 1558 1512 1495 1495
q20 631 367 367 367
q21 6643 3926 4011 3926
q22 885 348 337 337
Total cold run time: 108683 ms
Total hot run time: 41725 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4893 4865 4872 4865
q2 293 190 187 187
q3 3607 3601 3600 3600
q4 2524 2502 2491 2491
q5 5786 5756 5760 5756
q6 215 133 127 127
q7 2255 1678 1674 1674
q8 3051 3106 3099 3099
q9 8752 8769 8705 8705
q10 6784 4268 4238 4238
q11 520 365 379 365
q12 766 541 558 541
q13 4319 3394 3425 3394
q14 261 229 232 229
q15 600 515 506 506
q16 485 430 441 430
q17 1688 1626 1617 1617
q18 8404 7706 7669 7669
q19 1658 1664 1665 1664
q20 2138 1847 1840 1840
q21 6614 6244 6197 6197
q22 563 521 501 501
Total cold run time: 66176 ms
Total hot run time: 59695 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "qidaye (via GitHub)" <gi...@apache.org>.
qidaye merged PR #31142:
URL: https://github.com/apache/doris/pull/31142
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968709528
<details>
<summary>TPC-DS: <b>Total hot run time: 169264 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 80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e, data reload: false
query1 919 348 339 339
query2 6524 1789 1756 1756
query3 6708 203 207 203
query4 23587 20652 20612 20612
query5 4271 357 358 357
query6 253 177 166 166
query7 4605 290 298 290
query8 244 191 207 191
query9 8511 2276 2262 2262
query10 409 218 220 218
query11 14604 14306 14107 14107
query12 137 79 82 79
query13 1642 441 438 438
query14 8813 6595 6666 6595
query15 213 170 186 170
query16 7083 273 250 250
query17 1033 507 500 500
query18 1897 266 262 262
query19 190 145 150 145
query20 84 86 83 83
query21 193 121 123 121
query22 4796 4454 4558 4454
query23 30598 29919 29859 29859
query24 11758 3138 3000 3000
query25 650 353 347 347
query26 1764 157 162 157
query27 3022 310 316 310
query28 7010 1817 1811 1811
query29 1172 557 557 557
query30 281 133 137 133
query31 884 693 694 693
query32 91 57 55 55
query33 718 223 230 223
query34 1040 485 489 485
query35 869 739 751 739
query36 955 868 802 802
query37 127 64 62 62
query38 3118 3024 3004 3004
query39 1312 1255 1235 1235
query40 278 103 107 103
query41 37 36 35 35
query42 104 98 94 94
query43 450 431 424 424
query44 1077 702 713 702
query45 191 177 173 173
query46 1028 803 789 789
query47 1522 1409 1361 1361
query48 411 348 373 348
query49 1118 290 288 288
query50 773 375 382 375
query51 4358 4280 4318 4280
query52 98 85 93 85
query53 332 263 257 257
query54 300 217 233 217
query55 77 80 78 78
query56 216 202 192 192
query57 987 885 870 870
query58 207 194 196 194
query59 2266 2207 2205 2205
query60 240 218 224 218
query61 89 86 83 83
query62 595 371 362 362
query63 279 257 254 254
query64 6587 3007 3125 3007
query65 3244 3204 3220 3204
query66 1439 315 313 313
query67 14477 14107 13704 13704
query68 4025 557 563 557
query69 503 380 368 368
query70 1264 1249 1276 1249
query71 327 247 243 243
query72 6013 2787 2672 2672
query73 706 316 312 312
query74 6321 6020 6021 6020
query75 3076 2443 2419 2419
query76 2333 1078 1164 1078
query77 329 237 237 237
query78 8963 8517 8573 8517
query79 1087 515 505 505
query80 998 356 357 356
query81 470 196 202 196
query82 1229 86 86 86
query83 220 125 117 117
query84 277 83 75 75
query85 1328 351 350 350
query86 404 299 307 299
query87 3270 3073 3102 3073
query88 2738 2353 2319 2319
query89 387 346 326 326
query90 1870 167 164 164
query91 148 120 126 120
query92 52 49 47 47
query93 1048 534 536 534
query94 1252 180 180 180
query95 440 335 341 335
query96 571 264 266 264
query97 4255 4135 4120 4120
query98 204 201 204 201
query99 1045 640 709 640
Total cold run time: 262018 ms
Total hot run time: 169264 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968722453
TeamCity be ut coverage result:
Function Coverage: 35.67% (8548/23965)
Line Coverage: 27.47% (69379/252535)
Region Coverage: 26.64% (35979/135068)
Branch Coverage: 23.44% (18383/78436)
Coverage Report: http://coverage.selectdb-in.cc/coverage/80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e_80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e/report/index.html
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968718914
run feut
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1968690995
<details>
<summary>TPC-H: <b>Total hot run time: 38506 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 80dbe77cd3fbe2a1fd8c64c6595a555b1a24016e, data reload: false
------ Round 1 ----------------------------------
q1 18398 4330 4146 4146
q2 2434 147 138 138
q3 11950 975 976 975
q4 5791 968 969 968
q5 8091 2986 3060 2986
q6 186 121 121 121
q7 1246 783 775 775
q8 9375 2063 2040 2040
q9 7205 6353 6334 6334
q10 8172 2528 2480 2480
q11 412 207 219 207
q12 754 305 302 302
q13 17946 3258 3252 3252
q14 282 257 243 243
q15 531 500 498 498
q16 469 406 428 406
q17 965 880 854 854
q18 6320 6191 6136 6136
q19 1567 1520 1509 1509
q20 474 274 288 274
q21 5676 3576 3579 3576
q22 569 296 286 286
Total cold run time: 108813 ms
Total hot run time: 38506 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4048 3995 3988 3988
q2 302 217 215 215
q3 2977 2953 2964 2953
q4 1827 1826 1818 1818
q5 5130 5163 5179 5163
q6 199 114 113 113
q7 2170 1731 1745 1731
q8 3128 3202 3212 3202
q9 8283 8303 8243 8243
q10 4118 3644 3663 3644
q11 505 417 424 417
q12 694 534 530 530
q13 3706 3066 3066 3066
q14 276 253 256 253
q15 537 495 499 495
q16 521 448 486 448
q17 1704 1677 1688 1677
q18 7758 7494 7458 7458
q19 1662 1639 1640 1639
q20 2084 1899 1917 1899
q21 4830 4546 4583 4546
q22 502 446 454 446
Total cold run time: 56961 ms
Total hot run time: 53944 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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953581838
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)
--
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] [feature](invert index) match_phrase_edge feature added [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31142:
URL: https://github.com/apache/doris/pull/31142#issuecomment-1953688297
<details>
<summary>TPC-DS: <b>Total hot run time: 177958 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 1350e8606ed015ddb2f0e08d58747a6b424a6fa5, data reload: false
query1 907 354 345 345
query2 6510 1855 1846 1846
query3 6693 201 199 199
query4 23097 21387 21291 21291
query5 4811 466 468 466
query6 267 167 175 167
query7 4605 300 303 300
query8 250 189 201 189
query9 8406 2774 2775 2774
query10 419 226 215 215
query11 15007 14680 14584 14584
query12 144 83 86 83
query13 1695 403 404 403
query14 9121 7385 7461 7385
query15 210 181 196 181
query16 7476 257 258 257
query17 1400 554 544 544
query18 1949 285 258 258
query19 183 141 146 141
query20 87 83 82 82
query21 197 119 116 116
query22 5002 4876 4871 4871
query23 32421 31596 31501 31501
query24 12729 3356 3372 3356
query25 669 385 350 350
query26 1866 149 159 149
query27 3062 308 309 308
query28 6657 1840 1816 1816
query29 1110 615 614 614
query30 282 134 151 134
query31 931 742 768 742
query32 94 60 57 57
query33 728 227 230 227
query34 1119 492 492 492
query35 919 838 806 806
query36 993 894 923 894
query37 163 60 62 60
query38 3312 3238 3266 3238
query39 1375 1331 1329 1329
query40 282 107 103 103
query41 37 36 33 33
query42 103 98 96 96
query43 478 451 449 449
query44 1073 693 697 693
query45 197 183 174 174
query46 1045 770 763 763
query47 1666 1558 1554 1554
query48 422 347 346 346
query49 1213 298 296 296
query50 790 366 381 366
query51 5266 5159 5158 5158
query52 116 88 96 88
query53 395 299 288 288
query54 294 223 216 216
query55 83 79 80 79
query56 216 201 212 201
query57 1027 926 982 926
query58 215 203 193 193
query59 2300 2202 2327 2202
query60 244 227 216 216
query61 83 81 87 81
query62 584 393 383 383
query63 320 279 273 273
query64 6395 3086 3121 3086
query65 3294 3251 3252 3251
query66 1331 331 320 320
query67 14472 14319 14274 14274
query68 5043 543 565 543
query69 524 371 361 361
query70 1304 1201 1195 1195
query71 376 250 257 250
query72 6360 2816 2609 2609
query73 702 306 311 306
query74 6947 6559 6487 6487
query75 3201 2540 2535 2535
query76 3243 1138 1209 1138
query77 351 235 231 231
query78 9427 8837 8746 8746
query79 970 504 498 498
query80 512 359 344 344
query81 433 197 202 197
query82 162 86 84 84
query83 137 119 123 119
query84 224 79 78 78
query85 1032 338 327 327
query86 284 287 299 287
query87 3541 3269 3274 3269
query88 2657 2289 2272 2272
query89 421 353 341 341
query90 1903 162 163 162
query91 156 128 130 128
query92 54 46 47 46
query93 1000 488 494 488
query94 1095 179 176 176
query95 8579 370 8440 370
query96 582 274 265 265
query97 4427 4329 4310 4310
query98 220 203 195 195
query99 1040 747 723 723
Total cold run time: 277714 ms
Total hot run time: 177958 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