Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 merged PR #58721: URL: https://github.com/apache/doris/pull/58721 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
github-actions[bot] commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3654298235 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
github-actions[bot] commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3654298093 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3644827048 # FE Regression Coverage Report Increment line coverage ` 27.27% (3/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3644797315 # BE Regression && UT Coverage Report Increment line coverage `23.76% (24/101)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.35% (25000/34556) | | Line Coverage | 59.15% (262596/443970) | | Region Coverage | 54.17% (218485/403353) | | Branch Coverage | 55.65% (93356/167769) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3642710942 # FE Regression Coverage Report Increment line coverage ` 27.27% (3/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3642614997 # BE Regression && UT Coverage Report Increment line coverage `23.76% (24/101)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.35% (25000/34556) | | Line Coverage | 59.15% (262596/443970) | | Region Coverage | 54.17% (218485/403353) | | Branch Coverage | 55.65% (93356/167769) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641984695 # BE UT Coverage Report Increment line coverage `20.79% (21/101)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/43927990029064648a5e9a679e01de8f5695fb72_43927990029064648a5e9a679e01de8f5695fb72/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/43927990029064648a5e9a679e01de8f5695fb72_43927990029064648a5e9a679e01de8f5695fb72/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.41% (18831/35260) | | Line Coverage | 39.18% (174132/67) | | Region Coverage | 33.84% (134911/398641) | | Branch Coverage | 34.77% (58035/166898) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641636674 ClickBench: Total hot run time: 27.19 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 43927990029064648a5e9a679e01de8f5695fb72, data reload: false query1 0.060.050.05 query2 0.100.050.05 query3 0.260.090.09 query4 1.610.110.11 query5 0.270.260.25 query6 1.170.640.61 query7 0.020.020.02 query8 0.050.040.05 query9 0.570.510.50 query10 0.560.560.56 query11 0.150.100.10 query12 0.140.110.10 query13 0.620.600.59 query14 0.990.970.97 query15 0.810.800.79 query16 0.400.400.41 query17 1.061.021.06 query18 0.230.220.22 query19 1.921.781.80 query20 0.020.010.02 query21 15.46 0.310.15 query22 4.930.050.05 query23 16.05 0.290.10 query24 0.971.460.18 query25 0.110.110.06 query26 0.130.130.13 query27 0.050.060.05 query28 5.311.211.03 query29 12.60 4.023.23 query30 0.280.140.12 query31 2.820.630.40 query32 3.230.550.47 query33 3.003.033.03 query34 16.81 5.164.54 query35 4.564.564.55 query36 0.660.500.48 query37 0.110.070.08 query38 0.080.040.04 query39 0.040.030.03 query40 0.170.140.13 query41 0.090.030.04 query42 0.040.030.03 query43 0.050.030.04 Total cold run time: 98.56 s Total hot run time: 27.19 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641616851 TPC-DS: Total hot run time: 181229 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 43927990029064648a5e9a679e01de8f5695fb72, data reload: false query5 5194638 486 486 query6 344 250 232 232 query7 4227473 284 284 query8 327 267 257 257 query9 8790258126002581 query10 554 384 342 342 query11 15558 14770 14792 14770 query12 193 117 123 117 query13 1261529 389 389 query14 6470332930223022 query14_12920291729312917 query15 223 202 183 183 query16 902 488 499 488 query17 1151739 607 607 query18 2723465 360 360 query19 237 240 216 216 query20 132 117 118 117 query21 226 143 116 116 query22 3823391338183818 query23 16556 16034 15844 15844 query23_115940 15923 16046 15923 query24 7350168112501250 query24_11216123712291229 query25 566 470 437 437 query26 1259270 153 153 query27 2754470 311 311 query28 4393215721492149 query29 804 599 450 450 query30 328 247 218 218 query31 839 696 653 653 query32 76 72 71 71 query33 533 330 290 290 query34 904 935 554 554 query35 788 813 732 732 query36 859 916 826 826 query37 136 103 81 81 query38 3929381038243810 query39 751 732 722 722 query39_1703 703 694 694 query40 228 140 124 124 query41 73 63 63 63 query42 108 106 111 106 query43 457 441 405 405 query44 1376762 751 751 query45 196 189 185 185 query46 895 994 621 621 query47 1660171015861586 query48 316 335 262 262 query49 639 447 356 356 query50 693 307 225 225 query51 4111386338033803 query52 106 110 99 99 query53 324 351 305 305 query54 290 259 265 259 query55 80 75 73 73 query56 297 305 308 305 query57 1107114110511051 query58 267 259 262 259 query59 2359252223992399 query60 324 313 294 294 query61 163 181 174 174 query62 684 676 620 620 query63 331 299 304 299 query64 4932134110251025 query65 4051396139623961 query66 1400457 330 330 query67 15269 14984 14579 14579 query68 52071056748 748 query69 499 347 318 318 query70 10531008977 977 query71 390 318 292 292 query72 6122503453715034 query73 712 652 319 319 query74 8806883585948594 query75 3649356431733173 query76 38991150776 776 query77 529 400 296 296 query78 9652983588788878 query79 1069908 623 623 query80 1022673 567 567 query81 548 268 239 239 query82 426 134 111 111 query83 273 261 244 244 query84 267 117 116 116 query85 962 535 480 480 query86 338 299 274 274 query87 4085413739703970 query88 3264228422732273 query89 473 432 398 398 query90 2021173 161 161 query91 181 170 149 149 query92 78 70 68 68 query93 1079928 569 569 query94 541 310 287 287 query95 585 332 311 311 query96 608 479 212 212 query97 2545262825552555 query98 205 198 190 190 query99 1271132812021202 Total cold run time: 260856 ms Total hot run time: 181229 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641576978 TPC-H: Total hot run time: 36494 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 43927990029064648a5e9a679e01de8f5695fb72, data reload: false -- Round 1 -- q1 17619 419640554055 q2 2028355 245 245 q3 10171 1324734 734 q4 10270 781 310 310 q5 8758207220182018 q6 243 165 137 137 q7 1008857 719 719 q8 9380149311911191 q9 7015532352835283 q10 6905241519601960 q11 531 327 304 304 q12 708 730 582 582 q13 17786 366230053005 q14 289 316 278 278 q15 598 506 519 506 q16 942 931 872 872 q17 709 875 462 462 q18 8216820077157715 q19 11861020626 626 q20 420 374 255 255 q21 4564430442014201 q22 1137105610361036 Total cold run time: 110483 ms Total hot run time: 36494 ms - Round 2, with runtime_filter_mode=off - q1 4300431043534310 q2 342 427 318 318 q3 2389289025232523 q4 1450194514261426 q5 4595443943704370 q6 214 170 128 128 q7 2087199918021802 q8 2692255725082508 q9 7627700969446944 q10 2912310826542654 q11 574 495 488 488 q12 613 686 553 553 q13 3275362630203020 q14 276 281 272 272 q15 540 500 487 487 q16 859 896 864 864 q17 1128130413411304 q18 7356714969036903 q19 824 795 823 795 q20 1894195118171817 q21 4642437541154115 q22 10831042989 989 Total cold run time: 51672 ms Total hot run time: 48590 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641481283 # FE UT Coverage Report Increment line coverage ` 0.00% (0/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_43927990029064648a5e9a679e01de8f5695fb72/fe_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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3641198166 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3638636826 # FE Regression Coverage Report Increment line coverage ` 0.00% (0/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_1c67b7e7647e1c75543ff7d9e660b52f12b985e8_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_1c67b7e7647e1c75543ff7d9e660b52f12b985e8_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3637890294 ClickBench: Total hot run time: 27.28 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1c67b7e7647e1c75543ff7d9e660b52f12b985e8, data reload: false query1 0.040.050.05 query2 0.100.050.05 query3 0.250.090.08 query4 1.620.110.11 query5 0.290.260.26 query6 1.150.640.63 query7 0.040.030.02 query8 0.060.040.05 query9 0.570.510.51 query10 0.560.560.55 query11 0.170.110.11 query12 0.140.110.12 query13 0.610.610.61 query14 1.001.000.98 query15 0.810.800.79 query16 0.420.400.40 query17 1.061.041.03 query18 0.230.210.21 query19 1.901.881.77 query20 0.020.010.01 query21 15.44 0.290.13 query22 4.940.050.05 query23 16.12 0.290.10 query24 1.820.890.31 query25 0.100.060.08 query26 0.140.130.14 query27 0.080.050.04 query28 4.231.231.02 query29 12.60 4.143.26 query30 0.280.140.12 query31 2.820.630.41 query32 3.230.540.45 query33 2.983.062.99 query34 16.87 5.224.49 query35 4.604.584.56 query36 0.680.490.49 query37 0.110.070.07 query38 0.080.050.03 query39 0.040.030.02 query40 0.170.140.14 query41 0.090.030.03 query42 0.040.030.03 query43 0.040.030.04 Total cold run time: 98.54 s Total hot run time: 27.28 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3637865544 TPC-DS: Total hot run time: 181514 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 1c67b7e7647e1c75543ff7d9e660b52f12b985e8, data reload: false query5 4860618 469 469 query6 338 227 208 208 query7 4228471 278 278 query8 297 260 247 247 query9 8756257525892575 query10 534 405 321 321 query11 14903 14803 14557 14557 query12 177 113 111 111 query13 1253516 396 396 query14 5500324929892989 query14_12939290928732873 query15 205 204 180 180 query16 934 485 445 445 query17 1138688 587 587 query18 2427434 338 338 query19 226 241 207 207 query20 123 121 113 113 query21 217 144 117 117 query22 3815404439203920 query23 16436 16227 15943 15943 query23_116155 16099 16009 16009 query24 7315165912261226 query24_11261121912321219 query25 553 467 408 408 query26 1245267 155 155 query27 2792467 311 311 query28 4478217821652165 query29 811 562 435 435 query30 314 246 216 216 query31 793 718 645 645 query32 84 70 64 64 query33 543 337 283 283 query34 899 905 558 558 query35 781 833 732 732 query36 863 911 828 828 query37 128 96 83 83 query38 3789386037603760 query39 773 745 727 727 query39_1695 717 696 696 query40 227 136 126 126 query41 71 62 68 62 query42 113 108 112 108 query43 436 441 405 405 query44 1370798 771 771 query45 191 191 184 184 query46 883 986 610 610 query47 1636169416141614 query48 317 329 247 247 query49 630 447 363 363 query50 673 316 220 220 query51 3838391238283828 query52 108 115 101 101 query53 330 352 290 290 query54 285 260 252 252 query55 93 76 70 70 query56 297 298 305 298 query57 1149114010681068 query58 268 265 248 248 query59 2326241123172317 query60 319 316 297 297 query61 167 162 162 162 query62 704 671 624 624 query63 336 299 297 297 query64 5124144411341134 query65 4050395939753959 query66 1491472 347 347 query67 15260 15096 14949 14949 query68 31571072802 802 query69 515 364 329 329 query70 1035101510131013 query71 334 328 298 298 query72 6000519349764976 query73 487 557 306 306 query74 8755878487458745 query75 3536355131643164 query76 35101143757 757 query77 526 397 295 295 query78 9510981588698869 query79 1010872 626 626 query80 1166692 554 554 query81 560 267 236 236 query82 290 133 108 108 query83 393 263 242 242 query84 256 123 100 100 query85 1079521 496 496 query86 381 307 277 277 query87 3964413939913991 query88 3251229622972296 query89 475 415 397 397 query90 1911172 162 162 query91 182 169 147 147 query92 73 68 65 65 query93 981 942 575 575 query94 539 292 287 287 query95 585 386 309 309 query96 597 478 214 214 query97 2575267525832583 query98 210 209 198 198 query99 1269128311941194 Total cold run time: 255632 ms Total hot run time: 181514 ms ``` -- 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
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3637807606 TPC-H: Total hot run time: 36406 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1c67b7e7647e1c75543ff7d9e660b52f12b985e8, data reload: false -- Round 1 -- q1 17646 422640604060 q2 2025365 255 255 q3 10155 1331734 734 q4 10223 866 315 315 q5 7758215119241924 q6 219 165 136 136 q7 996 853 714 714 q8 93731420 q9 7298539153765376 q10 6864239919971997 q11 535 310 287 287 q12 687 735 556 556 q13 17796 365629772977 q14 286 292 277 277 q15 594 522 526 522 q16 930 1096871 871 q17 714 798 563 563 q18 8096798076587658 q19 16561048619 619 q20 396 357 266 266 q21 4525419841424142 q22 1124107510461046 Total cold run time: 109896 ms Total hot run time: 36406 ms - Round 2, with runtime_filter_mode=off - q1 4291423441754175 q2 327 410 363 363 q3 2360288424632463 q4 1442189514931493 q5 4611446744844467 q6 208 165 128 128 q7 2063199317331733 q8 2628257625142514 q9 7845719270157015 q10 2918309626612661 q11 565 493 474 474 q12 651 685 536 536 q13 3241361930113011 q14 262 294 256 256 q15 542 502 496 496 q16 861 886 849 849 q17 1120140613531353 q18 7435719870247024 q19 835 781 812 781 q20 1893196817991799 q21 4578423341854185 q22 10611054973 973 Total cold run time: 51737 ms Total hot run time: 48749 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3637629547 # FE UT Coverage Report Increment line coverage ` 0.00% (0/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_1c67b7e7647e1c75543ff7d9e660b52f12b985e8/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_1c67b7e7647e1c75543ff7d9e660b52f12b985e8/fe_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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3637253471 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3631300851 # BE UT Coverage Report Increment line coverage `20.79% (21/101)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/3799b81e1ee92822fcab8adeb51ede2e54f470c2_3799b81e1ee92822fcab8adeb51ede2e54f470c2/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/3799b81e1ee92822fcab8adeb51ede2e54f470c2_3799b81e1ee92822fcab8adeb51ede2e54f470c2/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.36% (18727/35094) | | Line Coverage | 39.07% (173075/442934) | | Region Coverage | 33.76% (134294/397782) | | Branch Coverage | 34.66% (57692/166435) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3630597752 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3630036087 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3628796703 # FE Regression Coverage Report Increment line coverage ` 27.27% (3/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_535436a962b59bc97b6ba52172c280e1837b24e5_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_535436a962b59bc97b6ba52172c280e1837b24e5_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3627582553 ClickBench: Total hot run time: 27.21 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 535436a962b59bc97b6ba52172c280e1837b24e5, data reload: false query1 0.050.050.04 query2 0.100.040.04 query3 0.260.090.09 query4 1.610.110.11 query5 0.270.260.25 query6 1.170.650.63 query7 0.030.020.03 query8 0.060.040.05 query9 0.570.500.51 query10 0.550.550.57 query11 0.160.110.11 query12 0.150.120.12 query13 0.630.620.61 query14 0.980.990.98 query15 0.800.800.81 query16 0.400.390.38 query17 0.961.071.04 query18 0.230.210.21 query19 1.911.851.88 query20 0.020.010.01 query21 15.46 0.290.14 query22 4.870.050.04 query23 16.06 0.290.10 query24 1.170.540.16 query25 0.080.110.09 query26 0.140.140.13 query27 0.100.080.05 query28 4.041.251.03 query29 12.62 3.963.18 query30 0.270.140.12 query31 2.820.630.38 query32 3.240.560.47 query33 3.053.113.04 query34 16.95 5.204.52 query35 4.544.524.55 query36 0.660.510.49 query37 0.110.060.07 query38 0.070.040.04 query39 0.040.030.03 query40 0.190.140.14 query41 0.090.030.03 query42 0.050.030.03 query43 0.040.040.04 Total cold run time: 97.57 s Total hot run time: 27.21 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3627546570 TPC-DS: Total hot run time: 179286 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 535436a962b59bc97b6ba52172c280e1837b24e5, data reload: false query5 4637655 501 501 query6 340 229 209 209 query7 4658480 285 285 query8 314 246 244 244 query9 8742263526452635 query10 523 324 282 282 query11 15444 15120 14688 14688 query12 186 118 113 113 query13 1689499 379 379 query14 6008320830323032 query14_12850291728432843 query15 207 194 183 183 query16 7350462 442 442 query17 1218697 580 580 query18 1996417 330 330 query19 216 192 158 158 query20 125 118 119 118 query21 219 136 117 117 query22 3885401238313831 query23 16510 16263 15966 15966 query23_116045 16095 16036 16036 query24 7199162512141214 query24_11200122512161216 query25 662 498 460 460 query26 1268279 176 176 query27 2910483 311 311 query28 4447216021562156 query29 869 596 480 480 query30 316 249 218 218 query31 808 711 634 634 query32 87 78 71 71 query33 672 358 315 315 query34 869 892 532 532 query35 805 860 732 732 query36 894 918 836 836 query37 124 95 79 79 query38 3828384337043704 query39 759 749 722 722 query39_1713 698 691 691 query40 226 132 122 122 query41 72 68 66 66 query42 132 101 97 97 query43 426 425 390 390 query44 1338775 775 775 query45 214 197 192 192 query46 920 966 594 594 query47 1684173816361636 query48 413 338 241 241 query49 794 447 371 371 query50 695 306 240 240 query51 3842389738403840 query52 119 94 88 88 query53 241 235 186 186 query54 333 270 257 257 query55 100 86 76 76 query56 347 301 321 301 query57 1201114611011101 query58 302 259 269 259 query59 2331249723572357 query60 370 364 296 296 query61 165 153 153 153 query62 816 666 649 649 query63 233 181 179 179 query64 45771177877 877 query65 4179396539813965 query66 1258448 347 347 query67 15203 15025 14651 14651 query68 8347939 665 665 query69 504 304 265 265 query70 1145102310221022 query71 446 295 270 270 query72 6047484448204820 query73 668 537 293 293 query74 8592874986538653 query75 3290305824892489 query76 34141151738 738 query77 739 407 286 286 query78 9427952089388938 query79 1734844 569 569 query80 644 553 462 462 query81 515 273 236 236 query82 548 124 103 103 query83 281 265 254 254 query84 259 113 101 101 query85 948 500 458 458 query86 390 302 282 282 query87 4056402039623962 query88 4220212621292126 query89 400 318 280 280 query90 2013161 158 158 query91 172 162 154 154 query92 86 64 66 64 query93 18261068678 678 query94 793 320 270 270 query95 568 384 326 326 query96 535 496 213 213 query97 2596268625942594 query98 246 203 197 197 query99 1380129512451245 Total cold run time: 270791 ms Total hot run time: 179286 ms ``` -- 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
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3627486507 TPC-H: Total hot run time: 36074 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 535436a962b59bc97b6ba52172c280e1837b24e5, data reload: false -- Round 1 -- q1 17611 501648954895 q2 2018317 204 204 q3 10253 1290713 713 q4 10216 853 311 311 q5 7535243022402240 q6 185 165 134 134 q7 954 781 634 634 q8 9349139411021102 q9 7275532653895326 q10 6862216417591759 q11 542 305 292 292 q12 391 371 223 223 q13 1 366830563056 q14 229 241 212 212 q15 610 519 526 519 q16 887 865 819 819 q17 679 820 504 504 q18 7671790778357835 q19 11541022653 653 q20 400 374 219 219 q21 4325406733603360 q22 1173109210641064 Total cold run time: 108096 ms Total hot run time: 36074 ms - Round 2, with runtime_filter_mode=off - q1 5108518650965096 q2 359 401 317 317 q3 2497283725062506 q4 1718185913701370 q5 4558452945004500 q6 211 165 123 123 q7 2006192718311831 q8 2598248725782487 q9 7597758175847581 q10 2974320626542654 q11 568 498 473 473 q12 666 704 555 555 q13 3272361630283028 q14 265 291 261 261 q15 541 494 493 493 q16 843 886 838 838 q17 1116134714151347 q18 7311717769746974 q19 796 787 810 787 q20 1871196618071807 q21 4721420041454145 q22 10771002958 958 Total cold run time: 52673 ms Total hot run time: 50131 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3627000967 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3617538143 # FE Regression Coverage Report Increment line coverage ` 27.27% (3/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_3ea3027aeb52950f741aec353ce3edac3c917d2e_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_3ea3027aeb52950f741aec353ce3edac3c917d2e_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3617486694 # BE Regression && UT Coverage Report Increment line coverage `23.47% (23/98)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_3ea3027aeb52950f741aec353ce3edac3c917d2e_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_3ea3027aeb52950f741aec353ce3edac3c917d2e_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.13% (24761/34326) | | Line Coverage | 58.84% (259552/441122) | | Region Coverage | 53.64% (215239/401251) | | Branch Coverage | 55.19% (92049/166789) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3617230582 # BE UT Coverage Report Increment line coverage `21.43% (21/98)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/3ea3027aeb52950f741aec353ce3edac3c917d2e_3ea3027aeb52950f741aec353ce3edac3c917d2e/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/3ea3027aeb52950f741aec353ce3edac3c917d2e_3ea3027aeb52950f741aec353ce3edac3c917d2e/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.22% (18629/35005) | | Line Coverage | 38.92% (171808/441480) | | Region Coverage | 33.55% (132994/396441) | | Branch Coverage | 34.48% (57207/165892) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616940544 ClickBench: Total hot run time: 27.37 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3ea3027aeb52950f741aec353ce3edac3c917d2e, data reload: false query1 0.060.050.05 query2 0.100.050.05 query3 0.260.090.09 query4 1.600.110.11 query5 0.300.260.26 query6 1.170.660.63 query7 0.040.030.03 query8 0.060.040.04 query9 0.580.520.50 query10 0.550.550.56 query11 0.160.100.10 query12 0.150.120.12 query13 0.620.600.61 query14 1.020.991.01 query15 0.810.800.80 query16 0.390.400.43 query17 0.991.041.02 query18 0.230.210.22 query19 1.891.861.74 query20 0.010.010.01 query21 15.44 0.300.14 query22 4.580.050.05 query23 15.82 0.260.10 query24 1.630.600.50 query25 0.100.060.05 query26 0.140.140.13 query27 0.050.040.04 query28 5.001.171.01 query29 12.60 3.893.20 query30 0.280.160.12 query31 2.820.610.39 query32 3.230.550.46 query33 3.003.023.10 query34 16.75 5.144.50 query35 4.604.534.51 query36 0.680.500.49 query37 0.100.060.07 query38 0.070.040.04 query39 0.050.030.03 query40 0.170.150.14 query41 0.080.030.03 query42 0.040.030.03 query43 0.040.040.03 Total cold run time: 98.26 s Total hot run time: 27.37 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616924107 TPC-DS: Total hot run time: 179623 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 3ea3027aeb52950f741aec353ce3edac3c917d2e, data reload: false query5 5101646 483 483 query6 339 218 199 199 query7 4675467 273 273 query8 332 260 247 247 query9 8723264626342634 query10 542 309 265 265 query11 15495 14907 14587 14587 query12 185 121 117 117 query13 1683485 387 387 query14 6230327329632963 query14_12915289529172895 query15 203 195 180 180 query16 7707493 463 463 query17 1212718 613 613 query18 2043433 338 338 query19 216 194 165 165 query20 133 121 119 119 query21 219 135 116 116 query22 3924401438713871 query23 16519 16220 15936 15936 query23_116076 15935 15990 15935 query24 7280160412161216 query24_11230120812251208 query25 638 502 441 441 query26 1262303 177 177 query27 2870492 317 317 query28 4367220421832183 query29 824 596 523 523 query30 317 242 208 208 query31 824 715 614 614 query32 84 67 65 65 query33 653 338 283 283 query34 874 868 519 519 query35 805 824 724 724 query36 879 926 824 824 query37 123 92 76 76 query38 3908389238183818 query39 751 735 698 698 query39_1705 695 692 692 query40 223 130 118 118 query41 66 62 63 62 query42 124 105 99 99 query43 430 424 399 399 query44 1298782 765 765 query45 193 194 189 189 query46 905 966 597 597 query47 1710167416301630 query48 409 320 231 231 query49 753 434 348 348 query50 681 308 238 238 query51 3974388338623862 query52 113 95 83 83 query53 239 230 173 173 query54 312 254 234 234 query55 95 80 79 79 query56 326 284 294 284 query57 1138113210871087 query58 282 255 256 255 query59 2364243923802380 query60 370 320 291 291 query61 197 158 156 156 query62 786 651 648 648 query63 229 172 173 172 query64 45531205899 899 query65 4051393639913936 query66 1190438 336 336 query67 15148 14951 14921 14921 query68 8463944 668 668 query69 513 295 264 264 query70 11011003954 954 query71 470 290 272 272 query72 6063494449534944 query73 701 576 301 301 query74 8952886585858585 query75 3355302824962496 query76 33861125743 743 query77 580 438 318 318 query78 9527950988028802 query79 1586913 575 575 query80 764 548 452 452 query81 515 273 232 232 query82 405 134 103 103 query83 278 270 255 255 query84 264 112 94 94 query85 898 492 451 451 query86 405 310 301 301 query87 3960409039443944 query88 3383211021162110 query89 391 326 278 278 query90 2068164 155 155 query91 177 166 139 139 query92 87 67 65 65 query93 2496993 685 685 query94 776 300 289 289 query95 571 386 330 330 query96 535 501 210 210 query97 2599264725562556 query98 252 204 206 204 query99 1362131912371237 Total cold run time: 271567 ms Total hot run time: 179623 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616887454 TPC-H: Total hot run time: 34282 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3ea3027aeb52950f741aec353ce3edac3c917d2e, data reload: false -- Round 1 -- q1 17652 505048884888 q2 2035303 192 192 q3 10280 1314715 715 q4 10208 846 310 310 q5 7512249221762176 q6 181 169 136 136 q7 974 810 656 656 q8 9349147711651165 q9 7145528853125288 q10 6855218217631763 q11 500 321 289 289 q12 394 364 225 225 q13 17820 367530173017 q14 238 234 226 226 q15 590 517 513 513 q16 903 873 818 818 q17 698 859 461 461 q18 8145709870487048 q19 1112974 629 629 q20 385 340 224 224 q21 3961330925812581 q22 11001025962 962 Total cold run time: 108037 ms Total hot run time: 34282 ms - Round 2, with runtime_filter_mode=off - q1 4943492748924892 q2 334 401 323 323 q3 2180266322982298 q4 1310176713051305 q5 4245462346724623 q6 228 178 132 132 q7 2110198818271827 q8 2760257326322573 q9 7448755975267526 q10 3069326229302930 q11 604 518 522 518 q12 709 750 627 627 q13 3465394433353335 q14 313 351 378 351 q15 615 533 523 523 q16 886 903 893 893 q17 1154147614351435 q18 7765770075607560 q19 883 858 846 846 q20 2032211718901890 q21 4961439441254125 q22 11261035992 992 Total cold run time: 53140 ms Total hot run time: 51524 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616597433 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616090335 ClickBench: Total hot run time: 27.13 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 69c327e6af4da00f8cc66aa38b41b6a8a638c28b, data reload: false query1 0.050.050.05 query2 0.090.050.05 query3 0.250.090.09 query4 1.610.110.11 query5 0.290.260.26 query6 1.190.630.63 query7 0.030.020.02 query8 0.060.040.04 query9 0.580.500.50 query10 0.550.550.56 query11 0.160.100.11 query12 0.140.110.12 query13 0.620.590.61 query14 0.990.990.98 query15 0.820.790.81 query16 0.410.390.41 query17 1.101.001.05 query18 0.230.220.22 query19 1.871.861.85 query20 0.020.010.02 query21 15.45 0.290.14 query22 4.820.050.05 query23 16.07 0.280.10 query24 1.590.250.18 query25 0.090.050.06 query26 0.160.140.13 query27 0.060.050.04 query28 4.061.211.02 query29 12.62 3.973.17 query30 0.280.140.14 query31 2.820.630.40 query32 3.230.550.46 query33 2.993.003.10 query34 16.81 5.184.50 query35 4.574.564.60 query36 0.650.510.49 query37 0.110.070.06 query38 0.080.040.05 query39 0.050.040.03 query40 0.180.160.14 query41 0.100.040.03 query42 0.040.030.03 query43 0.040.030.04 Total cold run time: 97.93 s Total hot run time: 27.13 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616072639 TPC-DS: Total hot run time: 180087 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 69c327e6af4da00f8cc66aa38b41b6a8a638c28b, data reload: false query5 5001650 490 490 query6 359 250 209 209 query7 4663479 288 288 query8 302 257 261 257 query9 8732266426712664 query10 569 340 278 278 query11 15619 15174 14796 14796 query12 202 126 124 124 query13 1723508 369 369 query14 7710323830833083 query14_12888288328732873 query15 204 203 184 184 query16 7698487 457 457 query17 1612740 630 630 query18 2054451 347 347 query19 226 196 173 173 query20 129 127 121 121 query21 225 141 117 117 query22 4037409440724072 query23 16803 16189 15887 15887 query23_116209 16001 15998 15998 query24 6823164412051205 query24_11225119312221193 query25 638 504 458 458 query26 1267287 177 177 query27 2882474 313 313 query28 4380221922022202 query29 836 596 479 479 query30 323 247 222 222 query31 812 702 652 652 query32 93 71 118 71 query33 675 350 299 299 query34 869 901 528 528 query35 812 834 747 747 query36 874 920 830 830 query37 121 104 75 75 query38 3797384937743774 query39 762 747 704 704 query39_1714 708 700 700 query40 235 131 116 116 query41 66 63 63 63 query42 123 96 95 95 query43 427 419 400 400 query44 1301755 759 755 query45 200 197 186 186 query46 911 957 602 602 query47 1676174516211621 query48 405 327 230 230 query49 782 433 356 356 query50 694 297 236 236 query51 3853386739003867 query52 118 104 84 84 query53 239 233 178 178 query54 313 280 237 237 query55 98 80 75 75 query56 342 293 308 293 query57 1208115610991099 query58 322 257 253 253 query59 2328241823602360 query60 379 318 296 296 query61 165 167 202 167 query62 781 703 646 646 query63 227 179 177 177 query64 45231193917 917 query65 4034392739893927 query66 1190454 345 345 query67 15579 15227 14858 14858 query68 8430934 668 668 query69 528 307 270 270 query70 1125982 997 982 query71 486 289 276 276 query72 5940494749054905 query73 696 554 298 298 query74 8881873885278527 query75 3394299825442544 query76 35081167740 740 query77 792 408 301 301 query78 9456962089048904 query79 1687844 585 585 query80 659 601 473 473 query81 497 271 244 244 query82 689 131 104 104 query83 287 278 254 254 query84 258 122 98 98 query85 959 503 451 451 query86 345 294 275 275 query87 4063395139673951 query88 3835212321152115 query89 395 324 282 282 query90 2083166 156 156 query91 182 169 146 146 query92 87 74 63 63 query93 12461045680 680 query94 822 306 284 284 query95 563 382 325 325 query96 541 509 208 208 query97 2600268525822582 query98 240 204 201 201 query99 1357131412651265 Total cold run time: 273801 ms Total hot run time: 180087 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3616029378 TPC-H: Total hot run time: 34401 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 69c327e6af4da00f8cc66aa38b41b6a8a638c28b, data reload: false -- Round 1 -- q1 17669 518949474947 q2 2067316 194 194 q3 10274 1348777 777 q4 10198 803 315 315 q5 7539241021802180 q6 185 176 138 138 q7 948 809 650 650 q8 9370145111551155 q9 7076531053785310 q10 6849219417691769 q11 542 318 300 300 q12 357 363 226 226 q13 17802 372530413041 q14 229 238 225 225 q15 597 511 509 509 q16 899 864 798 798 q17 699 860 443 443 q18 7538716470577057 q19 925 956 604 604 q20 375 354 236 236 q21 4027371525762576 q22 1055976 951 951 Total cold run time: 107220 ms Total hot run time: 34401 ms - Round 2, with runtime_filter_mode=off - q1 4984496849724968 q2 333 406 315 315 q3 2144268623292329 q4 1323176513231323 q5 4223454846604548 q6 221 178 131 131 q7 2122196318251825 q8 2704257925392539 q9 7488746275887462 q10 3091321828552855 q11 624 507 486 486 q12 686 750 639 639 q13 3545401733843384 q14 291 319 278 278 q15 530 568 507 507 q16 906 943 884 884 q17 1229154714901490 q18 7962776476837683 q19 913 882 909 882 q20 1961207219851985 q21 4935432443164316 q22 10801032974 974 Total cold run time: 53295 ms Total hot run time: 51803 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615691882 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615584138 # BE UT Coverage Report Increment line coverage `12.79% (11/86)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/f5d350fcd0380a0459e54f533659e2c0011dfb8e_f5d350fcd0380a0459e54f533659e2c0011dfb8e/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/f5d350fcd0380a0459e54f533659e2c0011dfb8e_f5d350fcd0380a0459e54f533659e2c0011dfb8e/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.27% (18643/34999) | | Line Coverage | 39.00% (172267/441732) | | Region Coverage | 33.62% (133323/396578) | | Branch Coverage | 34.58% (57372/165933) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615382067 ClickBench: Total hot run time: 27.36 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f5d350fcd0380a0459e54f533659e2c0011dfb8e, data reload: false query1 0.050.050.05 query2 0.100.050.04 query3 0.250.090.09 query4 1.610.110.11 query5 0.290.280.27 query6 1.180.650.63 query7 0.040.030.02 query8 0.060.040.05 query9 0.570.520.51 query10 0.570.560.55 query11 0.160.110.10 query12 0.150.110.11 query13 0.620.600.61 query14 0.980.990.97 query15 0.810.810.80 query16 0.400.410.40 query17 1.001.001.03 query18 0.260.210.21 query19 1.891.731.78 query20 0.020.010.01 query21 15.45 0.280.14 query22 4.980.050.05 query23 16.07 0.270.10 query24 1.471.080.21 query25 0.080.100.05 query26 0.140.120.13 query27 0.080.040.04 query28 4.851.221.01 query29 12.56 3.933.36 query30 0.310.130.12 query31 2.820.620.42 query32 3.230.550.46 query33 3.003.093.14 query34 17.01 5.124.56 query35 4.604.554.60 query36 0.650.490.49 query37 0.110.070.06 query38 0.070.050.04 query39 0.040.030.03 query40 0.160.130.15 query41 0.080.030.03 query42 0.040.030.03 query43 0.040.030.04 Total cold run time: 98.85 s Total hot run time: 27.36 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615372509 TPC-DS: Total hot run time: 180033 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit f5d350fcd0380a0459e54f533659e2c0011dfb8e, data reload: false query5 5872651 491 491 query6 421 235 210 210 query7 4911476 276 276 query8 342 242 260 242 query9 8723263926312631 query10 589 334 284 284 query11 15263 14750 14590 14590 query12 190 118 115 115 query13 1676482 387 387 query14 7759330230843084 query14_12919297629732973 query15 262 206 198 198 query16 7743488 488 488 query17 1531770 613 613 query18 2048447 354 354 query19 318 191 173 173 query20 133 124 117 117 query21 220 138 117 117 query22 3962401037863786 query23 16556 16137 15988 15988 query23_115955 15949 16304 15949 query24 6554163612471247 query24_11248120112231201 query25 640 515 441 441 query26 1251285 174 174 query27 2871470 312 312 query28 4472218221622162 query29 822 594 475 475 query30 323 247 213 213 query31 828 711 662 662 query32 86 71 71 71 query33 661 357 310 310 query34 852 934 541 541 query35 791 823 735 735 query36 898 906 861 861 query37 133 105 81 81 query38 3830396737603760 query39 770 732 730 730 query39_1787 706 686 686 query40 226 135 119 119 query41 65 62 59 59 query42 126 95 95 95 query43 438 420 384 384 query44 1314759 759 759 query45 200 197 185 185 query46 904 971 586 586 query47 1657169616281628 query48 405 325 231 231 query49 754 427 360 360 query50 704 320 234 234 query51 3777387738653865 query52 118 100 85 85 query53 225 227 181 181 query54 318 257 243 243 query55 97 79 81 79 query56 337 303 299 299 query57 1157113910831083 query58 311 268 259 259 query59 2359236024112360 query60 364 318 302 302 query61 160 160 168 160 query62 770 687 613 613 query63 238 184 182 182 query64 44971164904 904 query65 4063393339383933 query66 1113449 345 345 query67 15191 14869 14793 14793 query68 8410964 662 662 query69 563 311 272 272 query70 11361043969 969 query71 474 293 267 267 query72 5983507549164916 query73 692 561 301 301 query74 8804871786148614 query75 3519304225712571 query76 35491143732 732 query77 781 400 312 312 query78 9418960088418841 query79 1714860 590 590 query80 653 546 459 459 query81 535 271 240 240 query82 335 133 114 114 query83 283 275 258 258 query84 260 113 93 93 query85 886 492 452 452 query86 335 267 297 267 query87 4046401739513951 query88 4229213721522137 query89 410 342 285 285 query90 2002172 166 166 query91 174 168 140 140 query92 91 67 64 64 query93 18771019686 686 query94 732 309 282 282 query95 573 384 335 335 query96 543 509 216 216 query97 2643265726122612 query98 250 206 195 195 query99 1342131012351235 Total cold run time: 274096 ms Total hot run time: 180033 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615351264 TPC-H: Total hot run time: 34293 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f5d350fcd0380a0459e54f533659e2c0011dfb8e, data reload: false -- Round 1 -- q1 6090491149254911 q2 687 308 195 195 q3 905 1293724 724 q4 9058815 320 320 q5 7575233722622262 q6 198 178 137 137 q7 946 785 644 644 q8 9378144711051105 q9 7147533851995199 q10 6855220817961796 q11 531 327 293 293 q12 353 370 222 222 q13 17815 367530053005 q14 231 229 211 211 q15 577 530 523 523 q16 908 869 819 819 q17 684 808 488 488 q18 7922718371127112 q19 1021969 591 591 q20 382 359 224 224 q21 3923326725372537 q22 10271027975 975 Total cold run time: 84213 ms Total hot run time: 34293 ms - Round 2, with runtime_filter_mode=off - q1 4939488348844883 q2 329 418 312 312 q3 2155264322812281 q4 1341178012811281 q5 4217415241224122 q6 203 164 125 125 q7 1874182316701670 q8 2521241123842384 q9 7026691669986916 q10 2909307926562656 q11 582 504 484 484 q12 628 695 549 549 q13 3245363330243024 q14 278 283 266 266 q15 550 505 489 489 q16 860 901 843 843 q17 1118137513501350 q18 7315708171227081 q19 845 804 812 804 q20 1891196518401840 q21 4645425040574057 q22 1077104310031003 Total cold run time: 50548 ms Total hot run time: 48420 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615308712 # FE UT Coverage Report Increment line coverage ` 0.00% (0/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_f5d350fcd0380a0459e54f533659e2c0011dfb8e/fe_increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_f5d350fcd0380a0459e54f533659e2c0011dfb8e/fe_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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615196957 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
morningman commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615159181 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615149193 TPC-H: Total hot run time: 34394 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 03d900d320e54160d50198193b6238e2ab16a16f, data reload: false -- Round 1 -- q1 17643 504348664866 q2 1997314 190 190 q3 10303 1345718 718 q4 10231 949 321 321 q5 7579242921832183 q6 185 171 136 136 q7 951 785 637 637 q8 9352146111311131 q9 7138540953755375 q10 6837221318091809 q11 511 316 287 287 q12 351 360 223 223 q13 17782 367130273027 q14 237 254 211 211 q15 605 518 525 518 q16 912 859 819 819 q17 673 745 556 556 q18 7811708071137080 q19 1102955 607 607 q20 395 343 221 221 q21 4043333225382538 q22 10601019941 941 Total cold run time: 107698 ms Total hot run time: 34394 ms - Round 2, with runtime_filter_mode=off - q1 4942498948994899 q2 336 402 325 325 q3 2158263723322332 q4 1334174213051305 q5 4231454445304530 q6 227 183 134 134 q7 2013194317741774 q8 2773261024832483 q9 7558760175207520 q10 3084325528252825 q11 592 519 509 509 q12 683 742 600 600 q13 3505396632703270 q14 281 309 279 279 q15 547 506 550 506 q16 874 944 919 919 q17 1171136914101369 q18 7938784276057605 q19 867 793 839 793 q20 1915196617981798 q21 4583431240954095 q22 1096104310041004 Total cold run time: 52708 ms Total hot run time: 50874 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3615050892 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3614105161 # FE Regression Coverage Report Increment line coverage ` 27.27% (3/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_1fc92d856f8a3304e11f18c747bea564a32b60d3_merge_fe/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_1fc92d856f8a3304e11f18c747bea564a32b60d3_merge_fe/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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3614090753 # BE Regression && UT Coverage Report Increment line coverage `15.12% (13/86)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/58721_1fc92d856f8a3304e11f18c747bea564a32b60d3_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/58721_1fc92d856f8a3304e11f18c747bea564a32b60d3_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 72.15% (24730/34276) | | Line Coverage | 58.88% (259605/440890) | | Region Coverage | 53.91% (216339/401279) | | Branch Coverage | 55.36% (92332/166793) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3613586216 # BE UT Coverage Report Increment line coverage `12.79% (11/86)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/1fc92d856f8a3304e11f18c747bea564a32b60d3_1fc92d856f8a3304e11f18c747bea564a32b60d3/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/1fc92d856f8a3304e11f18c747bea564a32b60d3_1fc92d856f8a3304e11f18c747bea564a32b60d3/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.32% (18639/34956) | | Line Coverage | 39.01% (172137/441276) | | Region Coverage | 33.62% (133304/396467) | | Branch Coverage | 34.58% (57365/165898) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3613131612 ClickBench: Total hot run time: 27.5 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1fc92d856f8a3304e11f18c747bea564a32b60d3, data reload: false query1 0.050.050.05 query2 0.110.060.05 query3 0.260.090.09 query4 1.610.110.11 query5 0.280.250.25 query6 1.160.640.65 query7 0.030.030.03 query8 0.060.050.04 query9 0.600.500.51 query10 0.560.550.56 query11 0.160.100.10 query12 0.150.120.12 query13 0.620.620.61 query14 0.990.981.00 query15 0.830.810.80 query16 0.420.410.43 query17 1.031.071.08 query18 0.230.210.20 query19 1.951.901.88 query20 0.020.010.01 query21 15.45 0.300.14 query22 4.700.060.05 query23 15.84 0.290.11 query24 1.180.640.19 query25 0.100.080.07 query26 0.140.130.13 query27 0.050.040.08 query28 4.471.261.03 query29 12.61 4.033.25 query30 0.280.140.12 query31 2.830.620.39 query32 3.240.560.48 query33 3.043.103.06 query34 16.91 5.254.53 query35 4.594.574.61 query36 0.670.510.48 query37 0.110.070.07 query38 0.070.050.04 query39 0.050.030.03 query40 0.160.140.13 query41 0.100.030.03 query42 0.040.030.03 query43 0.040.040.04 Total cold run time: 97.79 s Total hot run time: 27.5 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3613105314 TPC-DS: Total hot run time: 180612 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 1fc92d856f8a3304e11f18c747bea564a32b60d3, data reload: false query5 4621632 497 497 query6 339 227 208 208 query7 4651481 279 279 query8 325 260 236 236 query9 8755266926632663 query10 544 331 285 285 query11 15141 14790 14970 14790 query12 177 123 116 116 query13 1701498 388 388 query14 5905332630443044 query14_12962298429412941 query15 214 203 187 187 query16 7413483 468 468 query17 1262733 618 618 query18 2019448 348 348 query19 224 192 167 167 query20 133 122 120 120 query21 217 139 116 116 query22 3908399838503850 query23 16628 16198 15933 15933 query23_116073 16043 16285 16043 query24 7217167212711271 query24_11218121212381212 query25 661 513 461 461 query26 1272283 184 184 query27 2876470 317 317 query28 4404219721812181 query29 888 603 508 508 query30 316 246 214 214 query31 800 728 633 633 query32 84 75 74 74 query33 664 340 301 301 query34 862 895 542 542 query35 797 828 747 747 query36 889 914 826 826 query37 124 98 77 77 query38 3871391138353835 query39 754 744 719 719 query39_1696 710 690 690 query40 221 133 119 119 query41 67 64 61 61 query42 124 99 100 99 query43 453 426 392 392 query44 1356765 752 752 query45 197 194 184 184 query46 923 976 604 604 query47 1701173516321632 query48 408 320 239 239 query49 783 423 354 354 query50 703 312 231 231 query51 3928385438023802 query52 118 97 86 86 query53 243 237 182 182 query54 316 247 238 238 query55 98 88 78 78 query56 340 293 310 293 query57 1140113911201120 query58 298 270 253 253 query59 2329243723182318 query60 377 323 304 304 query61 163 159 195 159 query62 789 691 643 643 query63 236 180 182 180 query64 45721188899 899 query65 4098399539863986 query66 1254456 337 337 query67 15422 14868 14910 14868 query68 8280962 694 694 query69 523 303 268 268 query70 1115999 1025999 query71 462 295 283 283 query72 5996491948914891 query73 691 560 308 308 query74 8874889286738673 query75 3212305125452545 query76 34051144771 771 query77 645 418 297 297 query78 9500964789268926 query79 1815854 592 592 query80 705 552 490 490 query81 531 272 244 244 query82 202 133 105 105 query83 277 273 255 255 query84 266 128 95 95 query85 922 490 441 441 query86 377 307 288 288 query87 4096406039043904 query88 3413217621552155 query89 395 325 292 292 query90 2118163 158 158 query91 172 169 147 147 query92 87 69 75 69 query93 21411032680 680 query94 768 325 283 283 query95 565 344 331 331 query96 555 507 217 217 query97 2623266125732573 query98 255 211 199 199 query99 1355134512591259 Total cold run time: 270571 ms Total hot run time: 180612 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3613049318 TPC-H: Total hot run time: 34323 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1fc92d856f8a3304e11f18c747bea564a32b60d3, data reload: false -- Round 1 -- q1 17669 511749264926 q2 2076323 197 197 q3 10215 1329748 748 q4 10224 840 327 327 q5 7521247921192119 q6 183 175 143 143 q7 979 790 634 634 q8 9354141711101110 q9 7330536253585358 q10 687618251825 q11 523 311 295 295 q12 392 377 227 227 q13 17814 369630503050 q14 237 241 211 211 q15 597 518 514 514 q16 880 861 814 814 q17 697 789 555 555 q18 7730726869776977 q19 1118988 599 599 q20 375 353 223 223 q21 4033339725252525 q22 10591001946 946 Total cold run time: 107882 ms Total hot run time: 34323 ms - Round 2, with runtime_filter_mode=off - q1 5030498449744974 q2 319 414 330 330 q3 2176269922672267 q4 1349176013081308 q5 4252453245594532 q6 230 184 133 133 q7 2120199118201820 q8 2742256225312531 q9 7597760475207520 q10 3092334228242824 q11 603 522 508 508 q12 672 731 616 616 q13 3611397732753275 q14 308 307 310 307 q15 573 521 507 507 q16 930 947 884 884 q17 1213151414621462 q18 8054763077607630 q19 932 881 907 881 q20 2005209418021802 q21 4615438941054105 q22 1119106210041004 Total cold run time: 53542 ms Total hot run time: 51220 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3612552480 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3612351439 # BE UT Coverage Report Increment line coverage `12.79% (11/86)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897_1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897_1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.32% (18637/34955) | | Line Coverage | 39.00% (172081/441270) | | Region Coverage | 33.63% (133326/396466) | | Branch Coverage | 34.57% (57344/165898) | -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3612047456 ClickBench: Total hot run time: 27.26 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897, data reload: false query1 0.040.050.04 query2 0.100.050.04 query3 0.250.080.08 query4 1.610.110.11 query5 0.270.250.26 query6 1.140.640.64 query7 0.030.030.02 query8 0.050.040.04 query9 0.580.490.50 query10 0.560.570.55 query11 0.160.110.11 query12 0.140.120.12 query13 0.630.600.60 query14 1.030.980.99 query15 0.820.810.82 query16 0.380.400.41 query17 1.051.061.00 query18 0.240.220.22 query19 1.931.831.77 query20 0.010.020.01 query21 15.43 0.290.14 query22 4.780.050.05 query23 15.95 0.270.11 query24 1.360.470.20 query25 0.090.080.05 query26 0.150.130.14 query27 0.050.060.08 query28 3.961.211.02 query29 12.64 4.033.23 query30 0.280.140.11 query31 2.820.630.41 query32 3.240.560.47 query33 2.993.103.07 query34 16.76 5.164.56 query35 4.584.564.52 query36 0.680.490.49 query37 0.100.070.07 query38 0.070.040.04 query39 0.050.030.03 query40 0.160.140.13 query41 0.090.030.03 query42 0.040.030.03 query43 0.040.030.03 Total cold run time: 97.33 s Total hot run time: 27.26 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3612024272 TPC-DS: Total hot run time: 180224 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools TPC-DS sf100 test result on commit 1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897, data reload: false query5 4609645 506 506 query6 359 235 209 209 query7 4664480 273 273 query8 301 257 246 246 query9 8748266126912661 query10 546 331 289 289 query11 15307 15048 14533 14533 query12 196 119 118 118 query13 1697491 378 378 query14 6495330130983098 query14_12904294428882888 query15 211 194 188 188 query16 7624499 474 474 query17 1250738 622 622 query18 2090440 352 352 query19 235 194 170 170 query20 135 120 125 120 query21 220 140 117 117 query22 3946412339163916 query23 16714 16214 16102 16102 query23_116260 16020 16069 16020 query24 7184165312171217 query24_11220121112571211 query25 661 514 451 451 query26 1256284 178 178 query27 2894479 316 316 query28 4377220621822182 query29 839 594 477 477 query30 314 243 215 215 query31 839 688 622 622 query32 88 71 72 71 query33 721 360 311 311 query34 924 901 550 550 query35 796 829 724 724 query36 897 920 846 846 query37 122 90 80 80 query38 3858387238353835 query39 771 729 733 729 query39_1710 705 697 697 query40 222 129 117 117 query41 65 63 63 63 query42 123 100 98 98 query43 443 421 403 403 query44 1340774 763 763 query45 198 197 184 184 query46 909 989 612 612 query47 1691175216351635 query48 396 329 232 232 query49 787 444 354 354 query50 698 319 239 239 query51 3859385639813856 query52 119 97 84 84 query53 225 228 181 181 query54 318 258 253 253 query55 98 78 76 76 query56 329 298 287 287 query57 1176115311251125 query58 298 265 253 253 query59 2412246223362336 query60 364 315 306 306 query61 158 157 159 157 query62 796 676 636 636 query63 234 182 183 182 query64 45351164905 905 query65 4021397839393939 query66 1203476 339 339 query67 15372 15190 14956 14956 query68 8247942 666 666 query69 520 311 270 270 query70 1121993 978 978 query71 456 296 272 272 query72 6164494649904946 query73 693 588 300 300 query74 8819897386078607 query75 3576302325552555 query76 35431150753 753 query77 816 408 302 302 query78 9450964988628862 query79 1935813 594 594 query80 659 554 461 461 query81 517 274 243 243 query82 497 135 105 105 query83 277 273 251 251 query84 265 108 98 98 query85 994 501 463 463 query86 387 325 297 297 query87 4010404239793979 query88 4219215821522152 query89 413 332 283 283 query90 2010162 157 157 query91 172 164 144 144 query92 87 66 67 66 query93 18971056675 675 query94 771 304 275 275 query95 582 372 334 334 query96 559 496 219 219 query97 2633268925962596 query98 250 198 200 198 query99 1340131711961196 Total cold run time: 273069 ms Total hot run time: 180224 ms ``` -- 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 t
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
doris-robot commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3611973879 TPC-H: Total hot run time: 34631 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1b2141b616ee6202ca5e8f0c64f3cffc6b5d3897, data reload: false -- Round 1 -- q1 17621 513949364936 q2 2054306 193 193 q3 10306 1337737 737 q4 10195 788 318 318 q5 7524250421582158 q6 196 177 139 139 q7 1008785 651 651 q8 9357145211041104 q9 7163532953815329 q10 6877220717641764 q11 527 326 293 293 q12 404 371 234 234 q13 17797 368131073107 q14 238 262 212 212 q15 598 521 522 521 q16 899 888 825 825 q17 710 793 557 557 q18 7852714471767144 q19 1103972 620 620 q20 380 356 225 225 q21 4081337925992599 q22 10431001965 965 Total cold run time: 107933 ms Total hot run time: 34631 ms - Round 2, with runtime_filter_mode=off - q1 4973501349354935 q2 332 405 333 333 q3 2145270423292329 q4 1395180013201320 q5 4255454545874545 q6 230 191 139 139 q7 2139203218231823 q8 2663252726982527 q9 7682745575747455 q10 3061328628452845 q11 596 525 494 494 q12 704 764 614 614 q13 3596400932053205 q14 291 320 285 285 q15 547 506 526 506 q16 883 922 891 891 q17 1229150914971497 q18 7977767675737573 q19 945 905 922 905 q20 1980198018231823 q21 4641427941624162 q22 11191050998 998 Total cold run time: 53383 ms Total hot run time: 51204 ms ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
zhangstar333 commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3611395177 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [improve](varbinary) support varbinary type with topn runtime filter [doris]
hello-stephen commented on PR #58721: URL: https://github.com/apache/doris/pull/58721#issuecomment-3611317275 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). Please clearly describe your PR: 1. What problem was fixed (it's best to include specific error reporting information). How it was fixed. 2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be. 3. What features were added. Why was this function added? 4. Which code was refactored and why was this part of the code refactored? 5. Which functions were optimized and what is the difference before and after the optimization? -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
