You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "LiBinfeng-01 (via GitHub)" <gi...@apache.org> on 2024/09/26 03:47:19 UTC
[PR] [feat](Nereids) support set var in hint when parse sql [doris]
LiBinfeng-01 opened a new pull request, #41331:
URL: https://github.com/apache/doris/pull/41331
set var hint need to be enable to use before analyze, so it need to be set when parsing sql
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378329814
run cloud_p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2401697619
run p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2376033791
<details>
<summary>TPC-DS: <b>Total hot run time: 193121 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 a6aca99b5dcb38fe119328f3918aa3f59b629c38, data reload: false
query1 947 382 426 382
query2 6395 2107 2060 2060
query3 8673 199 204 199
query4 34096 23508 23495 23495
query5 3375 460 462 460
query6 273 179 182 179
query7 4206 312 332 312
query8 307 233 231 231
query9 9671 2667 2666 2666
query10 434 282 274 274
query11 17937 15205 15153 15153
query12 152 101 99 99
query13 1541 430 446 430
query14 9186 7455 7495 7455
query15 291 177 176 176
query16 8025 482 495 482
query17 1701 626 584 584
query18 2161 318 334 318
query19 371 169 155 155
query20 124 115 117 115
query21 209 113 113 113
query22 5102 4851 4745 4745
query23 35336 34545 34536 34536
query24 11174 2903 2787 2787
query25 617 415 411 411
query26 1130 168 160 160
query27 2402 302 295 295
query28 7748 2454 2471 2454
query29 815 436 427 427
query30 258 158 154 154
query31 1014 807 795 795
query32 97 54 53 53
query33 746 300 292 292
query34 923 503 494 494
query35 857 733 727 727
query36 1100 937 936 936
query37 149 84 85 84
query38 3993 3880 3912 3880
query39 1495 1437 1433 1433
query40 208 97 99 97
query41 52 49 51 49
query42 117 98 99 98
query43 544 492 485 485
query44 1248 808 796 796
query45 196 163 162 162
query46 1145 722 708 708
query47 1939 1808 1844 1808
query48 456 367 384 367
query49 911 399 380 380
query50 837 411 403 403
query51 7035 6826 6859 6826
query52 97 86 84 84
query53 257 181 180 180
query54 1091 469 457 457
query55 72 71 73 71
query56 315 270 260 260
query57 1249 1094 1133 1094
query58 233 237 240 237
query59 3218 3013 3262 3013
query60 296 268 266 266
query61 103 102 103 102
query62 833 653 674 653
query63 221 183 183 183
query64 3948 649 623 623
query65 3278 3220 3205 3205
query66 817 308 312 308
query67 16051 15591 15826 15591
query68 4884 581 554 554
query69 540 299 302 299
query70 1190 1151 1101 1101
query71 393 267 283 267
query72 7366 4020 3978 3978
query73 761 344 348 344
query74 10396 9035 8919 8919
query75 3478 2690 2677 2677
query76 3371 915 895 895
query77 553 294 292 292
query78 10864 10096 9720 9720
query79 2871 615 607 607
query80 1890 453 452 452
query81 592 240 236 236
query82 628 142 140 140
query83 301 137 134 134
query84 281 82 77 77
query85 1033 299 276 276
query86 489 296 314 296
query87 4460 4322 4414 4322
query88 3961 2425 2372 2372
query89 406 290 281 281
query90 2124 186 183 183
query91 201 163 150 150
query92 64 48 47 47
query93 1987 561 548 548
query94 1039 305 289 289
query95 360 249 251 249
query96 612 277 285 277
query97 3253 3199 3162 3162
query98 211 198 194 194
query99 1524 1286 1276 1276
Total cold run time: 303881 ms
Total hot run time: 193121 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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378718948
run cloud_p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2376274092
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378329738
run p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2376017761
<details>
<summary>TPC-H: <b>Total hot run time: 40966 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 a6aca99b5dcb38fe119328f3918aa3f59b629c38, data reload: false
------ Round 1 ----------------------------------
q1 17567 7545 7339 7339
q2 2014 298 272 272
q3 12256 1042 1202 1042
q4 10566 739 715 715
q5 7808 2986 2828 2828
q6 236 149 145 145
q7 993 605 615 605
q8 9579 1965 1961 1961
q9 8153 6532 6429 6429
q10 6973 2286 2315 2286
q11 438 246 242 242
q12 409 217 214 214
q13 17784 3011 2961 2961
q14 241 217 215 215
q15 586 545 531 531
q16 693 617 596 596
q17 1000 495 588 495
q18 7258 6647 6747 6647
q19 1400 1109 1158 1109
q20 465 210 195 195
q21 4159 3228 3153 3153
q22 1115 997 986 986
Total cold run time: 111693 ms
Total hot run time: 40966 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7283 7233 7301 7233
q2 339 237 232 232
q3 3041 3030 2932 2932
q4 2053 1794 1776 1776
q5 5735 5671 5761 5671
q6 236 141 139 139
q7 2246 1927 1848 1848
q8 3390 3582 3517 3517
q9 9035 9038 9006 9006
q10 3555 3590 3566 3566
q11 596 494 474 474
q12 800 630 621 621
q13 8164 3146 3167 3146
q14 299 282 270 270
q15 573 529 528 528
q16 713 698 656 656
q17 1875 1660 1601 1601
q18 8359 7827 7772 7772
q19 1747 1574 1555 1555
q20 2139 1900 1899 1899
q21 5582 5270 5503 5270
q22 1131 1049 1041 1041
Total cold run time: 68891 ms
Total hot run time: 60753 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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2376041277
<details>
<summary>ClickBench: <b>Total hot run time: 33.05 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 a6aca99b5dcb38fe119328f3918aa3f59b629c38, data reload: false
query1 0.05 0.05 0.04
query2 0.06 0.03 0.03
query3 0.23 0.07 0.06
query4 1.64 0.10 0.10
query5 0.51 0.51 0.51
query6 1.13 0.72 0.72
query7 0.03 0.01 0.02
query8 0.03 0.03 0.04
query9 0.57 0.50 0.51
query10 0.55 0.55 0.56
query11 0.13 0.10 0.11
query12 0.14 0.10 0.11
query13 0.60 0.59 0.61
query14 2.99 3.03 3.11
query15 0.90 0.81 0.82
query16 0.40 0.38 0.39
query17 1.07 1.05 1.06
query18 0.19 0.19 0.20
query19 1.88 1.85 2.03
query20 0.01 0.01 0.01
query21 15.38 0.61 0.60
query22 3.20 2.55 1.52
query23 17.37 0.92 0.86
query24 3.37 1.20 1.47
query25 0.20 0.18 0.18
query26 0.45 0.14 0.14
query27 0.04 0.06 0.03
query28 9.99 1.10 1.07
query29 12.51 3.22 3.19
query30 0.25 0.06 0.06
query31 2.87 0.38 0.37
query32 3.29 0.48 0.46
query33 2.94 3.02 3.09
query34 16.96 4.51 4.46
query35 4.50 4.46 4.48
query36 0.64 0.50 0.48
query37 0.08 0.07 0.06
query38 0.04 0.04 0.03
query39 0.02 0.02 0.02
query40 0.15 0.13 0.13
query41 0.07 0.02 0.02
query42 0.03 0.02 0.01
query43 0.04 0.02 0.02
Total cold run time: 107.5 s
Total hot run time: 33.05 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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378524918
run cloud_p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2403822282
run p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378908572
run cloud_p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2379076922
run cloud_p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 merged PR #41331:
URL: https://github.com/apache/doris/pull/41331
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2378524774
run p0
--
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2375807324
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2375881573
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2376274004
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] [feat](Nereids) support set var in hint when parse sql [doris]
Posted by "LiBinfeng-01 (via GitHub)" <gi...@apache.org>.
LiBinfeng-01 commented on PR #41331:
URL: https://github.com/apache/doris/pull/41331#issuecomment-2379231491
run cloud_p0
--
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