Re: [PR] [fix](Nereids) variant push down not work on slot without table [doris]
morrySnow commented on PR #33356: URL: https://github.com/apache/doris/pull/33356#issuecomment-2041923044 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[PR] [fix](Nereids) variant push down not work on slot without table [doris]
morrySnow opened a new pull request, #33356: URL: https://github.com/apache/doris/pull/33356 ## Proposed changes Issue Number: close #xxx ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](Nereids) variant push down not work on slot without table [doris]
doris-robot commented on PR #33356: URL: https://github.com/apache/doris/pull/33356#issuecomment-2041923019 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [opt](Nereids) auto fallback when insert unsupport catalog [doris]
doris-robot commented on PR #33353: URL: https://github.com/apache/doris/pull/33353#issuecomment-2041922470 TPC-H: Total hot run time: 38934 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 6c3f9609de85ee2d489a86aaea9231549b219dd3, data reload: false -- Round 1 -- q1 17626 440042254225 q2 2010191 183 183 q3 10888 116712551167 q4 10718 826 812 812 q5 8126276827372737 q6 220 138 134 134 q7 984 569 538 538 q8 9733208820702070 q9 8524716371047104 q10 8614355535153515 q11 460 233 227 227 q12 435 223 205 205 q13 18910 291529292915 q14 268 235 224 224 q15 518 471 478 471 q16 515 402 377 377 q17 951 594 613 594 q18 7291676466416641 q19 1602149515001495 q20 686 323 296 296 q21 3244286227032703 q22 361 304 301 301 Total cold run time: 112684 ms Total hot run time: 38934 ms - Round 2, with runtime_filter_mode=off - q1 4236424241854185 q2 386 269 261 261 q3 2977270127172701 q4 1841158415951584 q5 5307529252955292 q6 205 121 121 121 q7 1756140914311409 q8 3166332933023302 q9 9266926991739173 q10 3892373737573737 q11 588 476 479 476 q12 733 594 583 583 q13 16125 292629512926 q14 302 266 270 266 q15 513 462 469 462 q16 472 430 413 413 q17 1765147114541454 q18 7478748274387438 q19 1798154715381538 q20 1938175517421742 q21 4911475146774677 q22 544 449 485 449 Total cold run time: 70199 ms Total hot run time: 54189 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](cloud) Only update table version when drop a non-empty partition [doris]
doris-robot commented on PR #32989: URL: https://github.com/apache/doris/pull/32989#issuecomment-2041919023 TPC-H: Total hot run time: 38442 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 41adcae268db8ccb38287be1dbbda8d52e405d15, data reload: false -- Round 1 -- q1 17631 428942414241 q2 2004186 180 180 q3 10473 113112201131 q4 10189 826 781 781 q5 7493268526762676 q6 219 131 134 131 q7 1008598 585 585 q8 9222206220242024 q9 7923653365176517 q10 8616356235183518 q11 472 231 234 231 q12 420 221 217 217 q13 17790 294629072907 q14 280 232 236 232 q15 520 465 479 465 q16 507 386 387 386 q17 960 640 651 640 q18 7322669767426697 q19 7730151715101510 q20 691 315 306 306 q21 3354276328252763 q22 357 304 312 304 Total cold run time: 115181 ms Total hot run time: 38442 ms - Round 2, with runtime_filter_mode=off - q1 4441420442134204 q2 360 270 251 251 q3 2966272626922692 q4 1852159115431543 q5 5280528752915287 q6 231 126 123 123 q7 2264185618701856 q8 3181332233343322 q9 8581866586628662 q10 4050389438973894 q11 615 508 491 491 q12 777 614 638 614 q13 16386 326032033203 q14 320 294 280 280 q15 510 463 503 463 q16 488 428 424 424 q17 1825154015331533 q18 8044799777347734 q19 1711154015821540 q20 1961183818671838 q21 5163488249754882 q22 566 486 467 467 Total cold run time: 71572 ms Total hot run time: 55303 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](Nereids) Support plan cache when enable_sql_cache=true [doris]
doris-robot commented on PR #33262: URL: https://github.com/apache/doris/pull/33262#issuecomment-2041917571 TPC-DS: Total hot run time: 181425 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 058f3aeba5e47b3ccb9dba9f9e57ad2d914bd40f, data reload: false query1 1219112011271120 query2 7236191019471910 query3 6656205 210 205 query4 37612 21518 21486 21486 query5 4135403 389 389 query6 221 174 174 174 query7 4044302 297 297 query8 224 174 179 174 query9 5703227622732273 query10 511 252 248 248 query11 14641 14219 14136 14136 query12 140 92 91 91 query13 1024350 346 346 query14 9045671666736673 query15 205 183 169 169 query16 7130251 248 248 query17 1524564 572 564 query18 1504282 278 278 query19 195 148 148 148 query20 91 85 85 85 query21 198 127 127 127 query22 4959480648294806 query23 33723 32872 33266 32872 query24 12884 296729492949 query25 551 356 370 356 query26 1871148 150 148 query27 3126304 309 304 query28 7669190318721872 query29 846 581 574 574 query30 313 167 161 161 query31 928 711 729 711 query32 58 51 53 51 query33 582 246 245 245 query34 865 472 478 472 query35 823 688 683 683 query36 1012920 911 911 query37 277 72 74 72 query38 3500346934073407 query39 1627153615371536 query40 301 124 125 124 query41 50 45 48 45 query42 110 99 94 94 query43 500 460 443 443 query44 1292701 694 694 query45 270 252 268 252 query46 1062706 722 706 query47 1935186918411841 query48 353 283 290 283 query49 1139360 354 354 query50 748 375 374 374 query51 6782661165616561 query52 101 89 98 89 query53 353 279 269 269 query54 255 224 232 224 query55 78 70 70 70 query56 241 219 214 214 query57 1214111511351115 query58 221 197 198 197 query59 2777268825802580 query60 256 246 242 242 query61 95 96 89 89 query62 620 446 444 444 query63 302 271 273 271 query64 4804402938683868 query65 3089301430323014 query66 1317334 319 319 query67 15433 15146 14904 14904 query68 5048533 526 526 query69 498 307 294 294 query70 1239117511741174 query71 455 275 262 262 query72 6671260124332433 query73 718 312 315 312 query74 6775648464756475 query75 3132235621922192 query76 3400111511551115 query77 623 242 242 242 query78 10922 10323 10178 10178 query79 3243516 503 503 query80 1979420 408 408 query81 560 239 231 231 query82 875 110 93 93 query83 350 168 163 163 query84 267 84 83 83 query85 1634266 290 266 query86 505 302 305 302 query87 3792351735533517 query88 5325225422532253 query89 467 372 364 364 query90 1937176 175 175 query91 120 98 92 92 query92 58 48 47 47 query93 4133501 486 486 query94 1262173 172 172 query95 401 307 303 303 query96 611 256 261 256 query97 2724248924942489 query98 235 221 214 214 query99 1227867 854 854 Total cold run time: 295756 ms Total hot run time: 181425 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] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
doris-robot commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041915347 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 1429131647a68e9f9165630b812b34f042e4ed4c with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.7 seconds inserted 1000 Rows, about 729K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. (#33220) [doris]
Jibing-Li commented on PR #33354: URL: https://github.com/apache/doris/pull/33354#issuecomment-2041912134 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
doris-robot commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041912499 ClickBench: Total hot run time: 30.89 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1429131647a68e9f9165630b812b34f042e4ed4c, data reload: false query1 0.040.040.04 query2 0.080.040.04 query3 0.220.050.05 query4 1.670.080.08 query5 0.500.480.49 query6 1.120.650.64 query7 0.020.020.01 query8 0.050.040.04 query9 0.550.500.50 query10 0.550.550.55 query11 0.160.110.12 query12 0.150.120.11 query13 0.600.590.58 query14 0.760.760.79 query15 0.830.800.80 query16 0.360.360.36 query17 1.021.011.02 query18 0.220.260.23 query19 1.801.691.67 query20 0.020.010.01 query21 15.45 0.630.63 query22 3.666.642.72 query23 18.16 1.301.20 query24 1.750.280.21 query25 0.130.080.08 query26 0.260.160.16 query27 0.080.090.08 query28 13.32 1.000.97 query29 12.55 3.333.24 query30 0.250.070.06 query31 2.850.380.37 query32 3.300.480.46 query33 2.792.862.80 query34 17.17 4.374.45 query35 4.474.444.47 query36 0.650.460.46 query37 0.200.160.14 query38 0.140.140.14 query39 0.060.030.03 query40 0.180.150.14 query41 0.100.050.05 query42 0.050.040.04 query43 0.040.030.04 Total cold run time: 108.33 s Total hot run time: 30.89 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. (#33220) [doris]
doris-robot commented on PR #33354: URL: https://github.com/apache/doris/pull/33354#issuecomment-2041911837 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[PR] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. (#33220) [doris]
Jibing-Li opened a new pull request, #33354: URL: https://github.com/apache/doris/pull/33354 backport: https://github.com/apache/doris/pull/33220 ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
doris-robot commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041907241 TPC-DS: Total hot run time: 181620 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 1429131647a68e9f9165630b812b34f042e4ed4c, data reload: false query1 884 112511341125 query2 7170193818301830 query3 6651204 208 204 query4 37580 21618 21214 21214 query5 4150401 410 401 query6 229 177 171 171 query7 4056295 294 294 query8 224 174 173 173 query9 5829229822962296 query10 516 247 250 247 query11 14706 14227 14282 14227 query12 141 93 85 85 query13 983 356 356 356 query14 9281690568026802 query15 206 176 180 176 query16 7109267 250 250 query17 1667589 542 542 query18 1484281 270 270 query19 193 148 150 148 query20 93 86 86 86 query21 202 128 126 126 query22 4963483848114811 query23 33680 33386 32961 32961 query24 12841 291128922892 query25 541 377 388 377 query26 1869157 154 154 query27 3067316 311 311 query28 7613189418721872 query29 885 622 618 618 query30 298 160 162 160 query31 927 713 734 713 query32 62 55 56 55 query33 591 252 250 250 query34 896 488 499 488 query35 820 705 693 693 query36 1055897 892 892 query37 276 74 78 74 query38 3574347234053405 query39 1595152815271527 query40 282 125 129 125 query41 50 46 46 46 query42 107 100 96 96 query43 503 462 458 458 query44 1368710 714 710 query45 272 252 268 252 query46 1070693 742 693 query47 1914183818561838 query48 361 287 290 287 query49 1148375 370 370 query50 752 383 395 383 query51 6717669366376637 query52 97 97 88 88 query53 356 280 280 280 query54 270 235 236 235 query55 82 75 76 75 query56 244 226 224 224 query57 1223112611261126 query58 231 204 209 204 query59 2909269625322532 query60 257 244 250 244 query61 111 108 109 108 query62 656 464 447 447 query63 313 281 283 281 query64 5050383139983831 query65 3127302330333023 query66 1340338 330 330 query67 15565 14755 14715 14715 query68 9087559 559 559 query69 619 310 309 309 query70 1317121911301130 query71 540 285 288 285 query72 6834263824152415 query73 957 317 316 316 query74 7091642365066423 query75 3643229422932293 query76 6003115710861086 query77 661 252 246 246 query78 11066 10408 10231 10231 query79 7676526 526 526 query80 1214427 430 427 query81 548 229 233 229 query82 703 96 97 96 query83 203 170 168 168 query84 261 85 81 81 query85 1094270 282 270 query86 466 303 295 295 query87 3725356735363536 query88 5800227822852278 query89 516 377 367 367 query90 1935182 182 182 query91 121 100 97 97 query92 60 49 48 48 query93 6414511 493 493 query94 1120179 182 179 query95 411 316 309 309 query96 593 262 258 258 query97 2661248525002485 query98 231 215 214 214 query99 1202887 875 875 Total cold run time: 310054 ms Total hot run time: 181620 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] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. [doris]
Jibing-Li merged PR #33220: URL: https://github.com/apache/doris/pull/33220 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
(doris) branch master updated (a4a42bf35b2 -> 86ba42d56ee)
This is an automated email from the ASF dual-hosted git repository. lijibing pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/doris.git from a4a42bf35b2 [improve](cloud) Optimize meta service proxy retry strategy (#32902) add 86ba42d56ee Set enable_unique_key_partial_update to false in statistics session variable. (#33220) No new revisions were added by this update. Summary of changes: .../doris/statistics/util/StatisticsUtil.java | 2 +- .../test_statistic_partial_update.groovy | 56 ++ 2 files changed, 57 insertions(+), 1 deletion(-) create mode 100644 regression-test/suites/statistics/test_statistic_partial_update.groovy - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](Nereids) Support plan cache when enable_sql_cache=true [doris]
doris-robot commented on PR #33262: URL: https://github.com/apache/doris/pull/33262#issuecomment-2041906506 TPC-H: Total hot run time: 39533 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 058f3aeba5e47b3ccb9dba9f9e57ad2d914bd40f, data reload: false -- Round 1 -- q1 17639 453544934493 q2 2728193 193 193 q3 10986 117612111176 q4 10765 781 826 781 q5 7828280827372737 q6 228 140 135 135 q7 1046616 584 584 q8 9202209920592059 q9 8473718971417141 q10 8575361335323532 q11 466 233 222 222 q12 389 215 207 207 q13 18978 295129422942 q14 270 236 238 236 q15 528 490 493 490 q16 528 382 401 382 q17 979 636 695 636 q18 7342676668576766 q19 5018153615421536 q20 686 327 306 306 q21 3396285826712671 q22 365 309 308 308 Total cold run time: 116415 ms Total hot run time: 39533 ms - Round 2, with runtime_filter_mode=off - q1 4375427442824274 q2 371 260 268 260 q3 2986281527872787 q4 1927160215731573 q5 5299532253345322 q6 212 125 124 124 q7 2251188018471847 q8 3212338933673367 q9 9327931593289315 q10 3879379537063706 q11 606 472 513 472 q12 777 574 579 574 q13 16371 294229302930 q14 299 270 280 270 q15 503 467 461 461 q16 477 420 434 420 q17 1782148714681468 q18 7550760173637363 q19 1665161115451545 q20 1977174017691740 q21 5048481349754813 q22 543 477 468 468 Total cold run time: 71437 ms Total hot run time: 55099 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
doris-robot commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041904903 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 0d11ce67968de437e15d2f50098ad441ec2cfa2f with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.8 seconds inserted 1000 Rows, about 724K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [opt](Nereids) auto fallback when insert unsupport catalog [doris]
morrySnow commented on PR #33353: URL: https://github.com/apache/doris/pull/33353#issuecomment-2041902797 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [opt](Nereids) auto fallback when insert unsupport catalog [doris]
doris-robot commented on PR #33353: URL: https://github.com/apache/doris/pull/33353#issuecomment-2041902780 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[PR] [opt](Nereids) auto fallback when insert unsupport catalog [doris]
morrySnow opened a new pull request, #33353: URL: https://github.com/apache/doris/pull/33353 ## Proposed changes Issue Number: close #xxx ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
doris-robot commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041902011 ClickBench: Total hot run time: 29.79 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 0d11ce67968de437e15d2f50098ad441ec2cfa2f, data reload: false query1 0.040.040.03 query2 0.080.040.03 query3 0.230.060.05 query4 1.680.070.06 query5 0.520.500.48 query6 1.120.660.64 query7 0.020.010.02 query8 0.050.040.04 query9 0.540.500.49 query10 0.550.560.55 query11 0.170.120.11 query12 0.150.120.12 query13 0.610.590.59 query14 0.760.770.77 query15 0.820.800.81 query16 0.360.370.37 query17 0.991.041.00 query18 0.230.230.24 query19 1.771.731.71 query20 0.020.010.01 query21 15.42 0.660.64 query22 4.326.711.51 query23 18.17 1.301.21 query24 1.650.290.20 query25 0.130.080.08 query26 0.260.160.16 query27 0.080.080.08 query28 13.45 0.980.97 query29 12.63 3.343.28 query30 0.260.060.06 query31 2.870.380.37 query32 3.300.450.46 query33 2.792.802.83 query34 17.18 4.354.37 query35 4.534.504.50 query36 0.650.480.46 query37 0.180.150.15 query38 0.140.130.14 query39 0.050.040.03 query40 0.170.140.15 query41 0.100.050.06 query42 0.050.040.05 query43 0.040.040.04 Total cold run time: 109.13 s Total hot run time: 29.79 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [test](mtmv)Add predicate filter case for various join methods [doris]
zfr9527 commented on PR #32888: URL: https://github.com/apache/doris/pull/32888#issuecomment-2041900272 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
doris-robot commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041896536 TPC-DS: Total hot run time: 182657 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 0d11ce67968de437e15d2f50098ad441ec2cfa2f, data reload: false query1 899 113011181118 query2 7003208918961896 query3 6645206 214 206 query4 37019 21659 21509 21509 query5 4147394 405 394 query6 239 186 183 183 query7 4050299 286 286 query8 225 180 185 180 query9 5781231723022302 query10 521 247 256 247 query11 14652 14244 14213 14213 query12 138 93 94 93 query13 1009359 353 353 query14 9247704767756775 query15 205 190 175 175 query16 7191263 266 263 query17 1672592 569 569 query18 1512283 283 283 query19 210 157 156 156 query20 94 88 88 88 query21 197 130 129 129 query22 5000480748374807 query23 33934 33308 33225 33225 query24 12355 293329142914 query25 604 404 407 404 query26 1879170 154 154 query27 3145311 319 311 query28 7704190518881888 query29 873 620 613 613 query30 304 166 164 164 query31 929 741 709 709 query32 62 56 56 56 query33 602 265 254 254 query34 892 466 496 466 query35 867 705 686 686 query36 970 899 895 895 query37 289 76 69 69 query38 3531341033973397 query39 1585154715411541 query40 276 135 130 130 query41 48 47 48 47 query42 112 103 98 98 query43 504 470 466 466 query44 1269708 697 697 query45 294 267 239 239 query46 1085730 708 708 query47 1916185518401840 query48 355 286 292 286 query49 1148366 370 366 query50 751 378 380 378 query51 6705667066346634 query52 109 94 99 94 query53 354 281 277 277 query54 272 242 245 242 query55 83 75 74 74 query56 251 230 232 230 query57 1217112711161116 query58 227 215 212 212 query59 2917266426102610 query60 272 257 263 257 query61 115 113 121 113 query62 620 449 436 436 query63 311 281 282 281 query64 4913408739933993 query65 3113302530643025 query66 1320325 320 320 query67 15710 14996 15130 14996 query68 10683 544 552 544 query69 604 305 294 294 query70 1289118311561156 query71 556 270 270 270 query72 6537262224602460 query73 1341318 317 317 query74 6815643764936437 query75 3665233922702270 query76 6738115011631150 query77 617 249 243 243 query78 4 10111 10185 10111 query79 10229 516 519 516 query80 1680450 416 416 query81 529 244 228 228 query82 628 99 94 94 query83 213 162 169 162 query84 263 81 84 81 query85 1074267 279 267 query86 381 298 298 298 query87 3749348135363481 query88 5337226922772269 query89 520 373 373 373 query90 2017181 183 181 query91 121 93 93 93 query92 56 47 49 47 query93 5993516 496 496 query94 1243178 177 177 query95 398 313 306 306 query96 610 259 267 259 query97 2691245924852459 query98 238 217 213 213 query99 1120856 853 853 Total cold run time: 313497 ms Total hot run time: 182657 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] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
doris-robot commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041895479 TPC-H: Total hot run time: 39401 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1429131647a68e9f9165630b812b34f042e4ed4c, data reload: false -- Round 1 -- q1 17606 430042724272 q2 2008185 176 176 q3 10805 120612831206 q4 10423 771 779 771 q5 7652272427282724 q6 233 137 139 137 q7 1082627 605 605 q8 9238213320562056 q9 8922727671997199 q10 9009357934783478 q11 475 233 238 233 q12 495 214 213 213 q13 18791 291829652918 q14 274 221 239 221 q15 524 485 478 478 q16 521 378 386 378 q17 965 684 656 656 q18 7223674268036742 q19 1599154214961496 q20 708 317 313 313 q21 3500286328282828 q22 363 309 301 301 Total cold run time: 112416 ms Total hot run time: 39401 ms - Round 2, with runtime_filter_mode=off - q1 4325419942114199 q2 360 261 266 261 q3 3003281028132810 q4 1833158116071581 q5 5276529053055290 q6 211 126 124 124 q7 2243188219061882 q8 3212333533173317 q9 9263922592979225 q10 3905373637433736 q11 598 495 509 495 q12 760 587 579 579 q13 12589 299529802980 q14 298 278 272 272 q15 500 458 471 458 q16 481 438 440 438 q17 1777147415481474 q18 7552757174067406 q19 1747150914871487 q20 1932176817531753 q21 5036479146274627 q22 530 443 459 443 Total cold run time: 67431 ms Total hot run time: 54837 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](cloud) Only update table version when drop a non-empty partition [doris]
xy720 commented on PR #32989: URL: https://github.com/apache/doris/pull/32989#issuecomment-2041895280 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
doris-robot commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041894449 TeamCity be ut coverage result: Function Coverage: 35.62% (/24953) Line Coverage: 27.35% (72988/266872) Region Coverage: 26.51% (37720/142284) Branch Coverage: 23.34% (19229/82400) Coverage Report: http://coverage.selectdb-in.cc/coverage/1429131647a68e9f9165630b812b34f042e4ed4c_1429131647a68e9f9165630b812b34f042e4ed4c/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [test](mtmv)add join infer and derive test case [doris]
zfr9527 commented on PR #32860: URL: https://github.com/apache/doris/pull/32860#issuecomment-2041893460 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](Nereids) Support plan cache when enable_sql_cache=true [doris]
924060929 commented on PR #33262: URL: https://github.com/apache/doris/pull/33262#issuecomment-2041888767 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [refactor](profile) refactor profile report on BE [doris]
doris-robot commented on PR #1: URL: https://github.com/apache/doris/pull/1#issuecomment-2041887135 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 2032562408705fe8e388b506f3306c571226002d with default session variables Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s Insert into select: 13.6 seconds inserted 1000 Rows, about 735K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
doris-robot commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041884578 TPC-H: Total hot run time: 39313 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 0d11ce67968de437e15d2f50098ad441ec2cfa2f, data reload: false -- Round 1 -- q1 17842 450944074407 q2 2334200 187 187 q3 11085 121712531217 q4 10494 833 758 758 q5 7493272926902690 q6 220 135 131 131 q7 949 539 528 528 q8 9223204820302030 q9 8510721372207213 q10 8603354935293529 q11 461 231 227 227 q12 465 229 212 212 q13 18733 297129302930 q14 275 242 234 234 q15 524 490 464 464 q16 513 404 377 377 q17 957 625 703 625 q18 7321685167756775 q19 1586150914701470 q20 688 306 315 306 q21 3438290327052705 q22 357 298 321 298 Total cold run time: 112071 ms Total hot run time: 39313 ms - Round 2, with runtime_filter_mode=off - q1 4266419842324198 q2 373 265 268 265 q3 3000277027632763 q4 1862159816181598 q5 5279530052985298 q6 209 123 122 122 q7 1781143014471430 q8 3254337833483348 q9 9382925293589252 q10 3872371637703716 q11 596 471 485 471 q12 774 606 591 591 q13 15462 296129312931 q14 281 280 286 280 q15 504 481 460 460 q16 470 414 421 414 q17 1793147414851474 q18 7553750974307430 q19 7904157815381538 q20 1940173617461736 q21 5015481747284728 q22 553 468 473 468 Total cold run time: 76123 ms Total hot run time: 54511 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [refactor](profile) refactor profile report on BE [doris]
doris-robot commented on PR #1: URL: https://github.com/apache/doris/pull/1#issuecomment-2041884062 ClickBench: Total hot run time: 30.27 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2032562408705fe8e388b506f3306c571226002d, data reload: false query1 0.040.030.03 query2 0.080.040.05 query3 0.230.040.04 query4 1.690.060.07 query5 0.480.480.49 query6 1.130.650.66 query7 0.020.010.01 query8 0.050.050.04 query9 0.550.490.50 query10 0.560.560.55 query11 0.170.110.11 query12 0.150.120.12 query13 0.600.580.57 query14 0.770.770.78 query15 0.830.800.80 query16 0.360.370.36 query17 0.970.990.96 query18 0.210.210.25 query19 1.781.711.73 query20 0.020.010.01 query21 15.42 0.650.65 query22 4.036.382.14 query23 18.22 1.271.16 query24 1.650.240.25 query25 0.140.070.08 query26 0.260.150.15 query27 0.080.080.08 query28 13.33 0.990.98 query29 12.61 3.253.24 query30 0.260.060.05 query31 2.870.380.37 query32 3.290.450.45 query33 2.802.842.78 query34 17.00 4.504.38 query35 4.444.494.47 query36 0.650.460.45 query37 0.200.160.16 query38 0.150.140.14 query39 0.050.040.04 query40 0.180.140.14 query41 0.090.040.04 query42 0.060.050.04 query43 0.040.040.04 Total cold run time: 108.51 s Total hot run time: 30.27 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](debug point) Add handler to debug point [doris]
yujun777 commented on PR #33350: URL: https://github.com/apache/doris/pull/33350#issuecomment-2041883143 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](debug point) Add handler to debug point [doris]
github-actions[bot] commented on code in PR #33350: URL: https://github.com/apache/doris/pull/33350#discussion_r1555234362 ## be/src/util/debug_points.h: ## @@ -17,6 +17,7 @@ #pragma once +#include #include #include Review Comment: warning: 'boost/lexical_cast.hpp' file not found [clang-diagnostic-error] ```cpp #include ^ ``` -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [refactor](profile) refactor profile report on BE [doris]
doris-robot commented on PR #1: URL: https://github.com/apache/doris/pull/1#issuecomment-2041881155 TeamCity be ut coverage result: Function Coverage: 35.58% (/24979) Line Coverage: 27.30% (72999/267433) Region Coverage: 26.46% (37730/142578) Branch Coverage: 23.30% (19233/82554) Coverage Report: http://coverage.selectdb-in.cc/coverage/2032562408705fe8e388b506f3306c571226002d_2032562408705fe8e388b506f3306c571226002d/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [chore](test) let some case suitable for legacy planner and nereids [doris]
doris-robot commented on PR #33352: URL: https://github.com/apache/doris/pull/33352#issuecomment-2041880079 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Improvement](materialized-view) adjust priority of materialized view… [doris]
github-actions[bot] commented on PR #33348: URL: https://github.com/apache/doris/pull/33348#issuecomment-2041879892 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Improvement](materialized-view) adjust priority of materialized view… [doris]
yiguolei merged PR #33348: URL: https://github.com/apache/doris/pull/33348 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[I] [Bug] (nereids) Close PREAGGREGATION in simple aggregation [doris]
liutang123 opened a new issue, #33351:
URL: https://github.com/apache/doris/issues/33351
### Search before asking
- [X] I had searched in the
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no
similar issues.
### Version
2.1.1
### What's Wrong?
1. Create a olap table:
```
CREATE TABLE `llj_test` (
`timeSec` BIGINT NULL COMMENT '',
`ruleId` BIGINT NULL COMMENT '',
`decisionId` BIGINT NULL COMMENT '',
`isEffect` TINYINT NULL COMMENT '',
`isMarked` TINYINT NULL COMMENT '',
`userid` BIGINT NULL COMMENT '',
`orderid` BIGINT NULL COMMENT '',
`uuid` VARCHAR(128) NULL COMMENT '',
`businessCode` INT NULL COMMENT '',
`sceneId` BIGINT NULL COMMENT '',
`action` INT NULL COMMENT '',
`mobile` VARCHAR(32) NULL COMMENT '',
`mobile_operatorname` VARCHAR(64) NULL COMMENT '',
`dealid` BIGINT NULL COMMENT '',
`requestId` VARCHAR(64) NULL COMMENT '',
`timeMin` INT NULL COMMENT '',
`hitRules` VARCHAR(2048) NULL COMMENT '',
`dt` INT NULL COMMENT '',
`requestNum` INT SUM NULL COMMENT '',
`expandNum` DOUBLE SUM NULL COMMENT ''
) ENGINE=OLAP
AGGREGATE KEY(`timeSec`, `ruleId`, `decisionId`, `isEffect`, `isMarked`,
`userid`, `orderid`, `uuid`, `businessCode`, `sceneId`,
`action`, `mobile`, `mobile_operatorname`, `dealid`,
`requestId`, `timeMin`, `hitRules`, `dt`)
COMMENT '测试'
PARTITION BY RANGE(`dt`)
(PARTITION p20240304 VALUES [("19700101"), ("20240409")),
PARTITION p20240410 VALUES [("20240409"), ("20240410")))
DISTRIBUTED BY HASH(`timeSec`) BUCKETS 6
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"bloom_filter_columns" = "orderid, sceneId",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "1",
"group_commit_data_bytes" = "134217728"
);
```
2. Insert som data.
```
insert into llj_test values(123,444,555,1,1,,,'uuid',
1,8,9,'mobile', 'mobile_operatorname',10,'requestId',1234,'111',20240409,-1,-2)
```
3. explain a simple aggregation sql:
```
set global experimental_enable_nereids_planner = true;
select requestid,
sceneid,
max(timeSec) maxTime
from llj_test
where dt between 20240403 AND 20240410
AND ruleId = 2279
and timeSec between UNIX_TIMESTAMP('2024-04-03 00:03:46') AND
UNIX_TIMESTAMP('2024-04-10 23:59:49')
group by requestId,
sceneid
order by maxTime desc
limit 100;
The OlapScanNode's PREAGGREGATION is OFF and reaseon is No aggregate on
scan.
```
### What You Expected?
The `PREAGGREGATION` should be `ON`
### How to Reproduce?
See bug description.
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://www.apache.org/foundation/policies/conduct)
--
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-unsubscr...@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Improvement](materialized-view) adjust priority of materialized view… [doris]
github-actions[bot] commented on PR #33348: URL: https://github.com/apache/doris/pull/33348#issuecomment-2041879943 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[PR] [chore](test) let some case suitable for legacy planner and nereids [doris]
morrySnow opened a new pull request, #33352: URL: https://github.com/apache/doris/pull/33352 ## Proposed changes Issue Number: close #xxx ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
(doris) branch branch-2.0 updated: [Improvement](materialized-view) adjust priority of materialized view match rule (#33305) (#33348)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new bf2d5280480 [Improvement](materialized-view) adjust priority of
materialized view match rule (#33305) (#33348)
bf2d5280480 is described below
commit bf2d5280480c5ce91933479b7d7dcab4cd8a2226
Author: Pxl
AuthorDate: Mon Apr 8 13:15:20 2024 +0800
[Improvement](materialized-view) adjust priority of materialized view match
rule (#33305) (#33348)
adjust priority of materialized view match rule
---
.../java/org/apache/doris/catalog/OlapTable.java | 8 +++
.../mv/AbstractSelectMaterializedIndexRule.java| 25 +-
regression-test/data/mv_p0/test_base/test_base.out | 9
.../suites/mv_p0/test_base/test_base.groovy| 57 ++
.../suites/nereids_p0/test_prune_tablet_mv.groovy | 2 +-
5 files changed, 98 insertions(+), 3 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/OlapTable.java
b/fe/fe-core/src/main/java/org/apache/doris/catalog/OlapTable.java
index 8bb31d32efc..536b8032a99 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/OlapTable.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/OlapTable.java
@@ -462,6 +462,14 @@ public class OlapTable extends Table {
: Collections.emptyList();
}
+public MaterializedIndex getBaseIndex() {
+Optional partition =
idToPartition.values().stream().findFirst();
+if (!partition.isPresent()) {
+partition = tempPartitions.getAllPartitions().stream().findFirst();
+}
+return partition.isPresent() ? partition.get().getBaseIndex() : null;
+}
+
public Column getVisibleColumn(String columnName) {
for (MaterializedIndexMeta meta : getVisibleIndexIdToMeta().values()) {
Column target = meta.getColumnByDefineName(columnName);
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/mv/AbstractSelectMaterializedIndexRule.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/mv/AbstractSelectMaterializedIndexRule.java
index da73094e5a5..17eadbd319b 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/mv/AbstractSelectMaterializedIndexRule.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/rules/rewrite/mv/AbstractSelectMaterializedIndexRule.java
@@ -19,6 +19,7 @@ package org.apache.doris.nereids.rules.rewrite.mv;
import org.apache.doris.analysis.CreateMaterializedViewStmt;
import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.KeysType;
import org.apache.doris.catalog.MaterializedIndex;
import org.apache.doris.catalog.MaterializedIndexMeta;
import org.apache.doris.catalog.OlapTable;
@@ -59,7 +60,6 @@ import com.google.common.collect.ImmutableMap;
import com.google.common.collect.ImmutableSet;
import com.google.common.collect.ImmutableSortedMap;
import com.google.common.collect.Lists;
-import org.apache.commons.collections.CollectionUtils;
import java.util.Comparator;
import java.util.HashMap;
@@ -185,6 +185,9 @@ public abstract class AbstractSelectMaterializedIndexRule {
return scan.getTable().getBaseIndexId();
}
+MaterializedIndex baseIndex = scan.getTable().getBaseIndex();
+candidates.add(baseIndex);
+
OlapTable table = scan.getTable();
// Scan slot exprId -> slot name
Map exprIdToName = scan.getOutput()
@@ -205,11 +208,13 @@ public abstract class AbstractSelectMaterializedIndexRule
{
.sum())
// compare by column count
.thenComparing(rid -> table.getSchemaByIndexId((Long)
rid).size())
+// prioritize using non-base index
+.thenComparing(rid -> (Long) rid == baseIndex.getId())
// compare by index id
.thenComparing(rid -> (Long) rid))
.collect(Collectors.toList());
-return CollectionUtils.isEmpty(sortedIndexIds) ?
scan.getTable().getBaseIndexId() : sortedIndexIds.get(0);
+return sortedIndexIds.get(0);
}
protected List matchPrefixMost(
@@ -223,6 +228,22 @@ public abstract class AbstractSelectMaterializedIndexRule {
Set nonEqualColNames = split.getOrDefault(false,
ImmutableSet.of()).stream()
.map(String::toLowerCase).collect(Collectors.toSet());
+// prioritize using index with where clause
+if (candidate.stream()
+.anyMatch(index ->
scan.getTable().getIndexMetaByIndexId(index.getId()).getWhereClause() != null))
{
+candidate = candidate.stream()
+.filter(index ->
scan.getTable().getIndexMetaByIndexId(index.getId()).getWhereClause() !=
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
doris-robot commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041879826 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 2c50c7d708b8975b5298881bc746c7f682501290 with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.5 seconds inserted 1000 Rows, about 740K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [refactor](profile) refactor profile report on BE [doris]
doris-robot commented on PR #1: URL: https://github.com/apache/doris/pull/1#issuecomment-2041878487 TPC-DS: Total hot run time: 182839 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 2032562408705fe8e388b506f3306c571226002d, data reload: false query1 893 113011121112 query2 6201209119551955 query3 6663207 202 202 query4 37148 21591 21298 21298 query5 4146391 390 390 query6 228 175 174 174 query7 4044288 283 283 query8 222 172 173 172 query9 5732226522682265 query10 367 241 234 234 query11 14860 14301 14112 14112 query12 134 98 89 89 query13 1005363 348 348 query14 9009691667946794 query15 207 176 178 176 query16 7251261 259 259 query17 1603587 561 561 query18 1520281 285 281 query19 200 160 156 156 query20 97 88 92 88 query21 199 130 123 123 query22 4992479047884788 query23 33572 33154 33147 33147 query24 11238 310230523052 query25 548 412 400 400 query26 838 165 153 153 query27 3081367 384 367 query28 6426196419671964 query29 869 641 641 641 query30 297 173 179 173 query31 912 781 739 739 query32 60 54 55 54 query33 507 267 256 256 query34 887 480 485 480 query35 841 720 715 715 query36 1035924 944 924 query37 126 69 71 69 query38 3779358335973583 query39 1643156215751562 query40 178 133 126 126 query41 44 43 44 43 query42 102 101 100 100 query43 509 460 443 443 query44 1251719 734 719 query45 286 258 280 258 query46 1080723 718 718 query47 2017195719361936 query48 367 293 292 292 query49 813 377 363 363 query50 789 388 402 388 query51 7002672166706670 query52 105 83 93 83 query53 337 271 270 270 query54 246 226 229 226 query55 73 72 70 70 query56 237 223 241 223 query57 1215113611221122 query58 214 197 210 197 query59 2869259025202520 query60 244 225 235 225 query61 91 91 91 91 query62 600 424 426 424 query63 301 268 277 268 query64 4160387139173871 query65 3022301330373013 query66 742 332 317 317 query67 15749 15350 15331 15331 query68 7289523 515 515 query69 572 291 295 291 query70 1274109411491094 query71 454 266 270 266 query72 6637273725722572 query73 830 314 310 310 query74 7016636765326367 query75 3178233022732273 query76 4095113210721072 query77 614 237 239 237 query78 11003 10184 10299 10184 query79 10758 511 513 511 query80 2170417 413 413 query81 533 243 223 223 query82 798 96 92 92 query83 202 163 161 161 query84 260 80 80 80 query85 1005274 255 255 query86 465 311 307 307 query87 3733351335023502 query88 6309233622672267 query89 535 367 367 367 query90 1954170 171 170 query91 119 108 95 95 query92 66 50 50 50 query93 7356497 484 484 query94 1153175 173 173 query95 398 305 298 298 query96 608 263 254 254 query97 2671248124662466 query98 238 220 214 214 query99 1189830 863 830 Total cold run time: 303505 ms Total hot run time: 182839 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] [Feature](function) Add function strcmp [doris]
doris-robot commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041878374 TeamCity be ut coverage result: Function Coverage: 35.63% (8893/24961) Line Coverage: 27.36% (73022/266917) Region Coverage: 26.52% (37740/142311) Branch Coverage: 23.34% (19233/82414) Coverage Report: http://coverage.selectdb-in.cc/coverage/0d11ce67968de437e15d2f50098ad441ec2cfa2f_0d11ce67968de437e15d2f50098ad441ec2cfa2f/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feat](nereids) support create view in nereids [doris]
doris-robot commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041878333 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit ab8ade15b3ddcf441f651f60e22eec4c963510d0 with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.6 seconds inserted 1000 Rows, about 735K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [pipelineX](runtime filter) Fix task timeout caused by runtime filter [doris]
github-actions[bot] commented on PR #2: URL: https://github.com/apache/doris/pull/2#issuecomment-2041878271 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [pipelineX](runtime filter) Fix task timeout caused by runtime filter [doris]
github-actions[bot] commented on PR #2: URL: https://github.com/apache/doris/pull/2#issuecomment-2041878252 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](debug point) Add handler to debug point [doris]
github-actions[bot] commented on PR #33350: URL: https://github.com/apache/doris/pull/33350#issuecomment-2041878073 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
doris-robot commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041876772 ClickBench: Total hot run time: 31.12 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2c50c7d708b8975b5298881bc746c7f682501290, data reload: false query1 0.040.040.03 query2 0.080.030.04 query3 0.220.050.04 query4 1.700.070.07 query5 0.500.500.49 query6 1.120.660.66 query7 0.020.010.01 query8 0.050.030.04 query9 0.540.490.51 query10 0.540.560.55 query11 0.170.100.11 query12 0.150.120.12 query13 0.590.590.58 query14 0.770.780.77 query15 0.830.790.81 query16 0.370.350.36 query17 0.920.990.98 query18 0.220.240.23 query19 1.741.671.78 query20 0.010.010.02 query21 15.44 0.650.64 query22 4.125.953.09 query23 18.24 1.221.09 query24 1.590.320.20 query25 0.120.080.08 query26 0.250.170.15 query27 0.080.070.07 query28 13.43 1.000.98 query29 12.62 3.293.26 query30 0.260.060.06 query31 2.890.370.38 query32 3.290.460.46 query33 2.862.802.85 query34 17.11 4.424.40 query35 4.534.444.45 query36 0.660.460.46 query37 0.180.140.14 query38 0.140.140.14 query39 0.060.040.03 query40 0.180.140.14 query41 0.100.050.04 query42 0.050.040.05 query43 0.040.040.04 Total cold run time: 108.82 s Total hot run time: 31.12 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](debug point) Add handler to debug point [doris]
yujun777 commented on PR #33350: URL: https://github.com/apache/doris/pull/33350#issuecomment-2041876202 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](debug point) Add handler to debug point [doris]
doris-robot commented on PR #33350: URL: https://github.com/apache/doris/pull/33350#issuecomment-2041876151 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
[PR] [feature](debug point) Add handler to debug point [doris]
yujun777 opened a new pull request, #33350: URL: https://github.com/apache/doris/pull/33350 Can use handler to exchange local variable between the base code and inject code. ## Proposed changes Issue Number: close #xxx ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feat](nereids) support create view in nereids [doris]
doris-robot commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041875517 ClickBench: Total hot run time: 30.96 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ab8ade15b3ddcf441f651f60e22eec4c963510d0, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.220.050.05 query4 1.670.070.10 query5 0.500.490.49 query6 1.120.650.65 query7 0.020.010.01 query8 0.040.040.04 query9 0.540.490.48 query10 0.550.540.53 query11 0.170.120.11 query12 0.150.120.12 query13 0.610.580.58 query14 0.760.760.77 query15 0.840.810.80 query16 0.370.370.35 query17 0.980.940.92 query18 0.230.210.24 query19 1.851.691.71 query20 0.010.000.00 query21 15.42 0.650.64 query22 5.165.072.71 query23 18.23 1.331.33 query24 1.790.260.21 query25 0.120.080.08 query26 0.250.160.15 query27 0.080.080.08 query28 13.43 0.990.99 query29 12.56 3.273.29 query30 0.260.060.06 query31 2.860.380.38 query32 3.300.450.46 query33 2.852.872.82 query34 17.20 4.394.45 query35 4.474.464.46 query36 0.650.450.46 query37 0.190.150.14 query38 0.140.140.14 query39 0.060.040.04 query40 0.170.140.13 query41 0.090.040.05 query42 0.060.040.05 query43 0.040.030.03 Total cold run time: 110.13 s Total hot run time: 30.96 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
github-actions[bot] commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041874022 clang-tidy review says "All clean, LGTM! :+1:" -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [bug](mem_tracker) fix mem_tracker dcheck failed as not used correctly [doris]
zhangstar333 commented on PR #33349: URL: https://github.com/apache/doris/pull/33349#issuecomment-2041872243 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
doris-robot commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041871837 TPC-DS: Total hot run time: 181765 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 2c50c7d708b8975b5298881bc746c7f682501290, data reload: false query1 874 1124341 341 query2 6428202819531953 query3 6656206 201 201 query4 36802 21607 21244 21244 query5 4142395 397 395 query6 241 179 170 170 query7 4053295 284 284 query8 227 178 179 178 query9 5753228622592259 query10 360 234 245 234 query11 14591 14274 14223 14223 query12 131 91 85 85 query13 979 371 357 357 query14 8421693069146914 query15 210 177 183 177 query16 7192262 263 262 query17 1660576 549 549 query18 1506278 274 274 query19 201 161 161 161 query20 96 87 89 87 query21 200 128 126 126 query22 5035486948454845 query23 33560 33034 33057 33034 query24 11875 296730162967 query25 549 405 399 399 query26 1312165 159 159 query27 3040361 367 361 query28 7330198119551955 query29 872 641 635 635 query30 318 176 173 173 query31 962 769 774 769 query32 64 55 56 55 query33 583 269 266 266 query34 882 496 495 495 query35 859 711 709 709 query36 1063943 942 942 query37 115 72 76 72 query38 3829361935043504 query39 1669159515631563 query40 178 137 132 132 query41 50 46 48 46 query42 108 98 96 96 query43 504 472 458 458 query44 1467753 761 753 query45 289 269 249 249 query46 1068740 731 731 query47 2008193519661935 query48 372 292 313 292 query49 860 388 380 380 query50 790 397 412 397 query51 6932684366336633 query52 97 88 87 87 query53 340 287 281 281 query54 248 234 226 226 query55 75 71 69 69 query56 237 225 226 225 query57 1183111511451115 query58 219 194 207 194 query59 2755248026132480 query60 252 231 232 231 query61 97 98 93 93 query62 585 429 450 429 query63 305 278 282 278 query64 4298395940633959 query65 3082304630293029 query66 722 312 314 312 query67 15814 15322 14837 14837 query68 10654 552 569 552 query69 610 294 301 294 query70 1276114511801145 query71 509 272 280 272 query72 6509261624272427 query73 1590319 323 319 query74 7127635562996299 query75 3638232223002300 query76 6485111211281112 query77 625 246 250 246 query78 10755 10190 10203 10190 query79 11761 514 513 513 query80 1816431 421 421 query81 532 232 225 225 query82 333 94 94 94 query83 209 168 166 166 query84 267 83 85 83 query85 921 266 263 263 query86 337 293 312 293 query87 3748347735623477 query88 5777228223072282 query89 512 390 372 372 query90 2013181 179 179 query91 135 93 97 93 query92 73 46 49 46 query93 5954501 512 501 query94 1295180 179 179 query95 399 308 320 308 query96 589 268 262 262 query97 2684249724752475 query98 233 210 217 210 query99 1069843 847 843 Total cold run time: 310010 ms Total hot run time: 181765 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] [feat](nereids) support create view in nereids [doris]
doris-robot commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041870595 TPC-DS: Total hot run time: 180006 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 ab8ade15b3ddcf441f651f60e22eec4c963510d0, data reload: false query1 879 1115352 352 query2 7263187919531879 query3 6648205 209 205 query4 37534 21697 21275 21275 query5 4132394 418 394 query6 225 175 172 172 query7 4043284 282 282 query8 225 167 176 167 query9 5741228122762276 query10 512 243 255 243 query11 14652 14140 14199 14140 query12 138 92 87 87 query13 1002355 346 346 query14 9155686067426742 query15 204 180 169 169 query16 7216267 253 253 query17 1663588 556 556 query18 1516291 271 271 query19 204 150 150 150 query20 93 90 87 87 query21 203 126 123 123 query22 4935487047964796 query23 33876 33101 33131 33101 query24 12761 287328772873 query25 541 369 372 369 query26 1869151 151 151 query27 3074308 308 308 query28 7592190318841884 query29 865 589 582 582 query30 313 172 164 164 query31 907 693 720 693 query32 58 51 52 51 query33 578 240 236 236 query34 877 470 475 470 query35 821 688 679 679 query36 1040886 855 855 query37 285 68 68 68 query38 3524342434053405 query39 1576151415391514 query40 283 124 129 124 query41 48 44 47 44 query42 103 95 94 94 query43 482 460 461 460 query44 1224698 698 698 query45 269 268 271 268 query46 1077727 710 710 query47 1936187918491849 query48 357 290 284 284 query49 1141365 363 363 query50 749 374 381 374 query51 6805655365566553 query52 102 98 93 93 query53 352 282 279 279 query54 261 238 236 236 query55 79 73 74 73 query56 247 223 221 221 query57 12321137 query58 231 204 206 204 query59 2799284526922692 query60 250 232 241 232 query61 112 107 108 107 query62 639 458 448 448 query63 307 279 276 276 query64 4876309541123095 query65 3123301430493014 query66 1333352 329 329 query67 15674 15016 15050 15016 query68 8813537 540 537 query69 612 311 301 301 query70 1213117111351135 query71 528 275 269 269 query72 6641275024792479 query73 933 314 313 313 query74 7171647663476347 query75 3630231823202318 query76 5434116511311131 query77 625 238 247 238 query78 10952 10077 10199 10077 query79 11801 515 514 514 query80 2534416 419 416 query81 582 235 229 229 query82 619 94 92 92 query83 217 160 169 160 query84 265 84 81 81 query85 1225261 261 261 query86 368 307 288 288 query87 3819355534873487 query88 5987227923782279 query89 537 374 372 372 query90 2426182 178 178 query91 119 90 91 90 query92 64 46 45 45 query93 7028516 494 494 query94 1545177 179 177 query95 421 308 310 308 query96 589 264 270 264 query97 2662247724602460 query98 232 217 212 212 query99 1172842 839 839 Total cold run time: 315595 ms Total hot run time: 180006 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] [refactor](profile) refactor profile report on BE [doris]
doris-robot commented on PR #1: URL: https://github.com/apache/doris/pull/1#issuecomment-2041867180 TPC-H: Total hot run time: 38698 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2032562408705fe8e388b506f3306c571226002d, data reload: false -- Round 1 -- q1 17613 437042704270 q2 2017191 188 188 q3 10457 119211771177 q4 10197 742 833 742 q5 7492277227142714 q6 219 136 134 134 q7 1034645 601 601 q8 9212208820442044 q9 7925658465666566 q10 8517357235573557 q11 457 241 240 240 q12 448 217 217 217 q13 18837 293529152915 q14 276 228 224 224 q15 515 482 468 468 q16 507 380 364 364 q17 961 729 731 729 q18 7382673068486730 q19 4806153114991499 q20 717 326 317 317 q21 3482269328892693 q22 362 309 310 309 Total cold run time: 113433 ms Total hot run time: 38698 ms - Round 2, with runtime_filter_mode=off - q1 4380427042144214 q2 363 255 261 255 q3 2992276527492749 q4 1838157615251525 q5 5275532552975297 q6 213 125 127 125 q7 2280184518771845 q8 3206337233623362 q9 8561857386658573 q10 4143389039643890 q11 645 489 514 489 q12 793 628 625 625 q13 17778 317731593159 q14 327 300 282 282 q15 538 480 487 480 q16 503 447 454 447 q17 1829149715031497 q18 7999822778937893 q19 1675151915241519 q20 2070185418341834 q21 5455494649594946 q22 548 442 462 442 Total cold run time: 73411 ms Total hot run time: 55448 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](Cloud) Add one config to control FE's startup with or without built in vault [doris]
doris-robot commented on PR #33308: URL: https://github.com/apache/doris/pull/33308#issuecomment-2041864893 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit cf30609cfd24aeccb2a176b259040c3d975ceaff with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.4 seconds inserted 1000 Rows, about 746K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](inverted index) add slop functionality to match_phrase [doris]
doris-robot commented on PR #33225: URL: https://github.com/apache/doris/pull/33225#issuecomment-2041863032 TeamCity be ut coverage result: Function Coverage: 35.61% (/24959) Line Coverage: 27.34% (72982/266930) Region Coverage: 26.51% (37726/142316) Branch Coverage: 23.32% (19224/82420) Coverage Report: http://coverage.selectdb-in.cc/coverage/72812e4978b8e5189dd206b678d77735f1614579_72812e4978b8e5189dd206b678d77735f1614579/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](partial-update) remove unnecessary DECHEK on IndexChannel::num_rows_filtered [doris]
doris-robot commented on PR #33160: URL: https://github.com/apache/doris/pull/33160#issuecomment-2041862633 TeamCity be ut coverage result: Function Coverage: 35.61% (8887/24953) Line Coverage: 27.35% (72989/266871) Region Coverage: 26.51% (37726/142284) Branch Coverage: 23.33% (19225/82400) Coverage Report: http://coverage.selectdb-in.cc/coverage/928284a22bd7dfe658608cb64d295759baffd32a_928284a22bd7dfe658608cb64d295759baffd32a/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
doris-robot commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041862706 TeamCity be ut coverage result: Function Coverage: 35.62% (/24953) Line Coverage: 27.35% (72982/266872) Region Coverage: 26.51% (37723/142284) Branch Coverage: 23.33% (19223/82400) Coverage Report: http://coverage.selectdb-in.cc/coverage/2c50c7d708b8975b5298881bc746c7f682501290_2c50c7d708b8975b5298881bc746c7f682501290/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](Cloud) Add one config to control FE's startup with or without built in vault [doris]
doris-robot commented on PR #33308: URL: https://github.com/apache/doris/pull/33308#issuecomment-2041862385 ClickBench: Total hot run time: 31.35 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit cf30609cfd24aeccb2a176b259040c3d975ceaff, data reload: false query1 0.040.040.03 query2 0.080.030.04 query3 0.240.060.05 query4 1.680.080.08 query5 0.500.490.50 query6 1.120.660.65 query7 0.020.020.01 query8 0.040.040.04 query9 0.560.490.51 query10 0.530.570.54 query11 0.170.110.11 query12 0.150.120.12 query13 0.580.580.58 query14 0.780.780.78 query15 0.820.790.80 query16 0.350.360.35 query17 0.961.001.02 query18 0.210.240.26 query19 1.871.721.70 query20 0.020.010.01 query21 15.44 0.640.64 query22 3.625.823.02 query23 18.25 1.291.25 query24 1.910.230.21 query25 0.140.080.08 query26 0.270.160.16 query27 0.080.080.07 query28 13.40 0.980.98 query29 12.61 3.273.30 query30 0.260.070.06 query31 2.840.370.37 query32 3.320.460.45 query33 2.872.812.84 query34 17.04 4.414.41 query35 4.474.474.46 query36 0.660.450.46 query37 0.200.150.15 query38 0.140.130.13 query39 0.050.030.03 query40 0.160.140.14 query41 0.100.050.04 query42 0.060.050.05 query43 0.040.040.03 Total cold run time: 108.65 s Total hot run time: 31.35 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
doris-robot commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041861025 TPC-H: Total hot run time: 38350 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2c50c7d708b8975b5298881bc746c7f682501290, data reload: false -- Round 1 -- q1 17593 428542224222 q2 2002189 188 188 q3 10459 113413431134 q4 10189 741 695 695 q5 7487270726612661 q6 218 132 130 130 q7 990 609 614 609 q8 9232207220322032 q9 7918654365336533 q10 8517352135223521 q11 458 232 229 229 q12 551 210 215 210 q13 18602 290929132909 q14 263 226 222 222 q15 518 480 467 467 q16 513 404 372 372 q17 946 630 663 630 q18 7249666767286667 q19 6898151715181517 q20 710 318 313 313 q21 3814278229632782 q22 369 308 307 307 Total cold run time: 115496 ms Total hot run time: 38350 ms - Round 2, with runtime_filter_mode=off - q1 4313420342174203 q2 356 270 271 270 q3 2971280827422742 q4 1870158115821581 q5 5313533652975297 q6 207 125 126 125 q7 2258181518861815 q8 3237333133353331 q9 8570862087218620 q10 4063387039153870 q11 648 504 486 486 q12 766 646 665 646 q13 16254 326631443144 q14 323 282 299 282 q15 524 470 476 470 q16 521 450 438 438 q17 1809154615011501 q18 8196791578437843 q19 1664155915001500 q20 2013183518391835 q21 6917493948674867 q22 566 479 463 463 Total cold run time: 73359 ms Total hot run time: 55329 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feat](nereids) support create view in nereids [doris]
doris-robot commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041859857 TPC-H: Total hot run time: 39361 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ab8ade15b3ddcf441f651f60e22eec4c963510d0, data reload: false -- Round 1 -- q1 17596 431842774277 q2 2008186 182 182 q3 10544 127412481248 q4 10912 924 806 806 q5 7542279327392739 q6 221 134 136 134 q7 1051625 618 618 q8 9248208020672067 q9 8791725070857085 q10 8649354635093509 q11 453 241 226 226 q12 418 212 205 205 q13 18689 292429562924 q14 267 230 238 230 q15 509 476 479 476 q16 510 406 373 373 q17 952 657 678 657 q18 7228675366806680 q19 2078150114851485 q20 685 315 298 298 q21 3346283929142839 q22 364 303 306 303 Total cold run time: 112061 ms Total hot run time: 39361 ms - Round 2, with runtime_filter_mode=off - q1 4317422242614222 q2 376 263 260 260 q3 2997273427062706 q4 1886160715801580 q5 5280531752925292 q6 206 121 124 121 q7 2230186018741860 q8 3190332033453320 q9 9276936093299329 q10 3847369637033696 q11 566 471 481 471 q12 757 612 621 612 q13 17447 292129502921 q14 298 270 258 258 q15 503 484 462 462 q16 472 412 428 412 q17 1762147514871475 q18 7458735272517251 q19 1632155315591553 q20 1928173917471739 q21 4899488647404740 q22 538 457 467 457 Total cold run time: 71865 ms Total hot run time: 54737 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
xiedeyantu commented on PR #33272: URL: https://github.com/apache/doris/pull/33272#issuecomment-2041858600 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](Cloud) Add one config to control FE's startup with or without built in vault [doris]
doris-robot commented on PR #33308: URL: https://github.com/apache/doris/pull/33308#issuecomment-2041857939 TPC-DS: Total hot run time: 181954 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 cf30609cfd24aeccb2a176b259040c3d975ceaff, data reload: false query1 907 113411181118 query2 7322203219461946 query3 6649205 213 205 query4 37827 21579 21313 21313 query5 4167423 420 420 query6 222 180 179 179 query7 4037291 287 287 query8 219 169 178 169 query9 5720230722822282 query10 514 249 254 249 query11 14707 14160 14188 14160 query12 146 95 92 92 query13 998 360 364 360 query14 9110684768926847 query15 218 179 179 179 query16 6690268 256 256 query17 1492578 546 546 query18 1360299 271 271 query19 197 152 154 152 query20 102 87 88 87 query21 201 132 122 122 query22 4976482148404821 query23 33756 33137 33024 33024 query24 12974 289229932892 query25 543 360 365 360 query26 1931154 154 154 query27 3044314 313 313 query28 7582189018951890 query29 879 625 610 610 query30 309 172 166 166 query31 921 708 713 708 query32 61 56 59 56 query33 604 257 252 252 query34 883 486 487 486 query35 828 701 686 686 query36 1025893 935 893 query37 233 74 81 74 query38 3513340334523403 query39 1705152515351525 query40 279 133 141 133 query41 50 47 50 47 query42 121 98 96 96 query43 482 468 469 468 query44 1381716 716 716 query45 290 265 270 265 query46 1089725 714 714 query47 1911183918301830 query48 377 283 283 283 query49 1160375 365 365 query50 753 381 396 381 query51 6692664865626562 query52 109 95 102 95 query53 356 288 285 285 query54 277 238 246 238 query55 78 72 73 72 query56 255 229 238 229 query57 1197111711271117 query58 238 215 210 210 query59 2699265026922650 query60 260 252 267 252 query61 110 106 106 106 query62 652 450 443 443 query63 310 283 286 283 query64 5240401740004000 query65 3120305230343034 query66 1373359 319 319 query67 15573 15178 14877 14877 query68 8466543 543 543 query69 599 317 327 317 query70 1253115411131113 query71 502 294 280 280 query72 6622268624082408 query73 823 315 317 315 query74 7169650664026402 query75 3586226123182261 query76 4732107110351035 query77 608 247 252 247 query78 10972 10389 10173 10173 query79 9276524 508 508 query80 1948434 422 422 query81 522 239 234 234 query82 138396 95 95 query83 230 164 167 164 query84 266 81 84 81 query85 1166277 260 260 query86 464 327 310 310 query87 3772351135553511 query88 6097227622722272 query89 546 381 379 379 query90 1943184 179 179 query91 121 93 92 92 query92 67 47 49 47 query93 7080513 494 494 query94 1159183 180 180 query95 406 312 303 303 query96 602 263 262 262 query97 2656243824942438 query98 233 224 203 203 query99 1135835 803 803 Total cold run time: 311408 ms Total hot run time: 181954 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] [Feature](function) Add function strcmp [doris]
xiedeyantu commented on code in PR #33272:
URL: https://github.com/apache/doris/pull/33272#discussion_r1555216075
##
be/src/vec/functions/function_string.h:
##
@@ -294,6 +294,72 @@ struct SubstringUtil {
}
};
+class FunctionStrcmp : public IFunction {
+public:
+static constexpr auto name = "strcmp";
+
+static FunctionPtr create() { return std::make_shared(); }
+
+String get_name() const override { return name; }
+
+size_t get_number_of_arguments() const override { return 2; }
+
+DataTypePtr get_return_type_impl(const DataTypes& arguments) const
override {
+if (arguments[0]->is_nullable() || arguments[1]->is_nullable()) {
+return make_nullable(std::make_shared());
+}
+return std::make_shared();
Review Comment:
@HappenLee fixed, please review
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Feature](function) Add function strcmp [doris]
xiedeyantu commented on code in PR #33272:
URL: https://github.com/apache/doris/pull/33272#discussion_r1555215833
##
be/src/vec/functions/function_string.h:
##
@@ -294,6 +294,72 @@ struct SubstringUtil {
}
};
+class FunctionStrcmp : public IFunction {
+public:
+static constexpr auto name = "strcmp";
+
+static FunctionPtr create() { return std::make_shared(); }
+
+String get_name() const override { return name; }
+
+size_t get_number_of_arguments() const override { return 2; }
+
+DataTypePtr get_return_type_impl(const DataTypes& arguments) const
override {
+if (arguments[0]->is_nullable() || arguments[1]->is_nullable()) {
Review Comment:
fixed
--
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-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](Cloud) Add one config to control FE's startup with or without built in vault [doris]
doris-robot commented on PR #33308: URL: https://github.com/apache/doris/pull/33308#issuecomment-2041848786 TPC-H: Total hot run time: 39446 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit cf30609cfd24aeccb2a176b259040c3d975ceaff, data reload: false -- Round 1 -- q1 17627 445742264226 q2 2007189 186 186 q3 10605 127012631263 q4 11077 799 804 799 q5 7570278927222722 q6 223 139 138 138 q7 974 546 550 546 q8 9253209020522052 q9 8793727872557255 q10 8650355235543552 q11 464 245 230 230 q12 433 208 212 208 q13 18799 298729942987 q14 273 235 238 235 q15 514 475 482 475 q16 519 390 381 381 q17 983 569 647 569 q18 7354678067656765 q19 1619150515271505 q20 674 317 301 301 q21 3363275027922750 q22 376 316 301 301 Total cold run time: 112150 ms Total hot run time: 39446 ms - Round 2, with runtime_filter_mode=off - q1 4359417943324179 q2 373 275 264 264 q3 2994274327132713 q4 1885160815891589 q5 5322530352905290 q6 208 122 126 122 q7 1790143414351434 q8 3177338332983298 q9 9329926393349263 q10 3892371637583716 q11 588 478 493 478 q12 754 597 612 597 q13 13808 302429412941 q14 294 260 265 260 q15 521 484 461 461 q16 468 426 430 426 q17 1780147614761476 q18 7447742473167316 q19 1631152015271520 q20 1946175317551753 q21 4846479748764797 q22 541 466 463 463 Total cold run time: 67953 ms Total hot run time: 54356 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feat](nereids) support create view in nereids [doris]
feiniaofeiafei commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041846340 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [chore](Nereids) turn off fallback [doris]
doris-robot commented on PR #32882: URL: https://github.com/apache/doris/pull/32882#issuecomment-2041845644 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s Insert into select: 13.7 seconds inserted 1000 Rows, about 729K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](partial-update) remove unnecessary DECHEK on IndexChannel::num_rows_filtered [doris]
doris-robot commented on PR #33160: URL: https://github.com/apache/doris/pull/33160#issuecomment-2041845263 TPC-H: Total hot run time: 38590 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 928284a22bd7dfe658608cb64d295759baffd32a, data reload: false -- Round 1 -- q1 17605 434043364336 q2 2009192 189 189 q3 10450 119911821182 q4 10198 806 777 777 q5 7519269826632663 q6 220 135 135 135 q7 1039638 593 593 q8 9200207120512051 q9 7955655265406540 q10 8660352435253524 q11 473 234 237 234 q12 422 220 217 217 q13 18774 295429792954 q14 267 230 239 230 q15 512 478 473 473 q16 518 394 383 383 q17 952 615 687 615 q18 7489680266836683 q19 6715151714731473 q20 694 330 304 304 q21 3595273029292730 q22 363 304 304 304 Total cold run time: 115629 ms Total hot run time: 38590 ms - Round 2, with runtime_filter_mode=off - q1 4278417841924178 q2 371 266 267 266 q3 2997274427912744 q4 1858161515851585 q5 5293531953265319 q6 214 125 128 125 q7 2225188318861883 q8 3193333533423335 q9 8553861185978597 q10 3995390437943794 q11 636 473 498 473 q12 776 646 613 613 q13 16461 315431013101 q14 314 289 285 285 q15 507 490 479 479 q16 498 455 431 431 q17 1790149814881488 q18 8276801978947894 q19 1703158816001588 q20 2051186918431843 q21 7765492348794879 q22 536 466 471 466 Total cold run time: 74290 ms Total hot run time: 55366 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feat](nereids) support create view in nereids [doris]
feiniaofeiafei commented on PR #32743: URL: https://github.com/apache/doris/pull/32743#issuecomment-2041844380 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [chore](Nereids) turn off fallback [doris]
doris-robot commented on PR #32882: URL: https://github.com/apache/doris/pull/32882#issuecomment-2041843191 ClickBench: Total hot run time: 31.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944, data reload: false query1 0.030.030.03 query2 0.080.040.04 query3 0.220.050.05 query4 1.670.080.07 query5 0.500.500.50 query6 1.120.640.66 query7 0.020.010.01 query8 0.050.050.04 query9 0.550.490.50 query10 0.540.550.56 query11 0.160.110.12 query12 0.150.110.12 query13 0.600.590.60 query14 0.740.780.79 query15 0.830.810.80 query16 0.340.360.36 query17 1.021.001.02 query18 0.200.240.24 query19 1.901.651.68 query20 0.010.020.01 query21 15.41 0.650.64 query22 4.296.532.86 query23 18.24 1.281.20 query24 1.690.280.21 query25 0.130.070.09 query26 0.270.160.15 query27 0.080.080.08 query28 13.39 0.980.97 query29 12.57 3.333.29 query30 0.260.060.06 query31 2.840.370.38 query32 3.310.460.46 query33 2.792.832.84 query34 17.46 4.374.48 query35 4.474.414.48 query36 0.650.470.46 query37 0.200.150.15 query38 0.140.140.14 query39 0.050.040.04 query40 0.180.130.15 query41 0.100.050.04 query42 0.060.040.04 query43 0.040.030.03 Total cold run time: 109.35 s Total hot run time: 31.07 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](serde) support complex type in write/read pb serde [doris]
doris-robot commented on PR #33124: URL: https://github.com/apache/doris/pull/33124#issuecomment-2041841886 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit bc1fdb95f7a18f03b81c904ead8ed3bb3a585b64 with default session variables Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s Insert into select: 17.6 seconds inserted 1000 Rows, about 568K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](nereids) fix a visitor bug in CommonSubExpressionOpt [doris]
doris-robot commented on PR #33154: URL: https://github.com/apache/doris/pull/33154#issuecomment-2041841210 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit f5e31f927786d50ada998f7ec2f744b5d6ef8781 with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.8 seconds inserted 1000 Rows, about 724K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](txn insert) txn insert support write to one table many times [doris]
doris-robot commented on PR #32980: URL: https://github.com/apache/doris/pull/32980#issuecomment-2041839874 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 8ed7e2d1f979eda02f060b4ccb98d95d39336544 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 57 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.5 seconds inserted 1000 Rows, about 740K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. [doris]
doris-robot commented on PR #33220: URL: https://github.com/apache/doris/pull/33220#issuecomment-2041839805 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 1de35e71ed9ebc0f0456d9d3b47ab767cdb64ed5 with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.6 seconds inserted 1000 Rows, about 735K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](serde) support complex type in write/read pb serde [doris]
doris-robot commented on PR #33124: URL: https://github.com/apache/doris/pull/33124#issuecomment-2041839625 ClickBench: Total hot run time: 29.56 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit bc1fdb95f7a18f03b81c904ead8ed3bb3a585b64, data reload: false query1 0.040.040.03 query2 0.070.040.04 query3 0.230.060.05 query4 1.670.080.07 query5 0.490.480.48 query6 1.150.660.66 query7 0.020.020.01 query8 0.050.040.04 query9 0.560.510.51 query10 0.560.570.56 query11 0.160.120.11 query12 0.140.120.13 query13 0.610.600.60 query14 0.770.790.78 query15 0.860.850.84 query16 0.350.350.36 query17 0.990.981.01 query18 0.240.250.25 query19 1.801.721.71 query20 0.020.010.01 query21 15.40 0.660.65 query22 3.847.721.16 query23 18.08 1.281.29 query24 1.510.210.19 query25 0.160.080.08 query26 0.260.160.16 query27 0.080.080.07 query28 13.83 0.980.95 query29 12.54 3.263.26 query30 0.280.080.06 query31 2.840.390.39 query32 3.300.470.47 query33 2.842.942.86 query34 15.52 4.334.33 query35 4.354.384.39 query36 0.680.470.47 query37 0.180.160.15 query38 0.150.150.14 query39 0.040.030.04 query40 0.180.180.14 query41 0.100.050.05 query42 0.060.050.05 query43 0.040.040.04 Total cold run time: 107.04 s Total hot run time: 29.56 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
(doris-website) branch master updated: [doc] function truncate update (#516)
This is an automated email from the ASF dual-hosted git repository.
luzhijing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 49a1660dd5b7 [doc] function truncate update (#516)
49a1660dd5b7 is described below
commit 49a1660dd5b7134597d47f967e9928847a6b3c70
Author: zhiqiang
AuthorDate: Mon Apr 8 12:27:59 2024 +0800
[doc] function truncate update (#516)
---
.../sql-functions/numeric-functions/truncate.md| 27 +-
.../sql-functions/numeric-functions/truncate.md| 27 +-
.../sql-functions/numeric-functions/truncate.md| 27 +-
.../sql-functions/numeric-functions/truncate.md| 27 +-
4 files changed, 84 insertions(+), 24 deletions(-)
diff --git a/docs/sql-manual/sql-functions/numeric-functions/truncate.md
b/docs/sql-manual/sql-functions/numeric-functions/truncate.md
index ca0e3ccc4a46..79e8de2886ad 100644
--- a/docs/sql-manual/sql-functions/numeric-functions/truncate.md
+++ b/docs/sql-manual/sql-functions/numeric-functions/truncate.md
@@ -26,14 +26,18 @@ under the License.
### description
Syntax
+`DOUBLE truncate(DOUBLE x, INT d)`
-`DOUBLE truncate(DOUBLE x, INT d)`
-Numerically truncate `x` according to the number of decimal places `d`.
+Numerically truncate `x` according to the number of decimal places `d`.
-The rules are as follows:
-When `d > 0`: keep `d` decimal places of `x`
-When `d = 0`: remove the fractional part of `x` and keep only the integer part
-When `d < 0`: Remove the fractional part of `x`, and replace the integer part
with the number `0` according to the number of digits specified by `d`
+The rules are as follows:
+
+If `d` is literal:
+When `d > 0`: keep `d` decimal places of `x`
+When `d = 0`: remove the fractional part of `x` and keep only the integer part
+When `d < 0`: Remove the fractional part of `x`, and replace the integer part
with the number `0` according to the number of digits specified by `d`
+
+Else if `d` is a column, and `x` has Decimal type, scale of result Decimal
will always be same with input Decimal.
### example
@@ -56,6 +60,17 @@ mysql> select truncate(-124.3867, -2);
+-+
|-100 |
+-+
+mysql> select cast("123.123456" as Decimal(9,6)), number, truncate(cast
("123.123456" as Decimal(9,6)), number) from numbers("number"="5");
+--
++---++--+
+| cast('123.123456' as DECIMALV3(9, 6)) | number | truncate(cast('123.123456'
as DECIMALV3(9, 6)), cast(number as INT)) |
++---++--+
+|123.123456 | 0 |
123.00 |
+|123.123456 | 1 |
123.10 |
+|123.123456 | 2 |
123.12 |
+|123.123456 | 3 |
123.123000 |
+|123.123456 | 4 |
123.123400 |
++---++--+
```
### keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/numeric-functions/truncate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/numeric-functions/truncate.md
index e13d291772fb..41e656fc55c2 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/numeric-functions/truncate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/numeric-functions/truncate.md
@@ -27,13 +27,17 @@ under the License.
### description
Syntax
-`DOUBLE truncate(DOUBLE x, INT d)`
-按照保留小数的位数`d`对`x`进行数值截取。
+`DOUBLE truncate(DOUBLE x, INT d)`
+按照保留小数的位数`d`对`x`进行数值截取。
-规则如下：
-当`d > 0`时：保留`x`的`d`位小数
-当`d = 0`时：将`x`的小数部分去除，只保留整数部分
-当`d < 0`时：将`x`的小数部分去除，整数部分按照 `d`所指定的位数，采用数字`0`进行替换
+规则如下：
+
+如果 `d` 为字面量：
+当`d > 0`时：保留`x`的`d`位小数
+当`d = 0`时：将`x`的小数部分去除，只保留整数部分
+当`d < 0`时：将`x`的小数部分去除，整数部分按照 `d`所指定的位数，采用数字`0`进行替换
+
+如果 `d` 为一个列，并且第一个参数为 Decimal 类型，那么结果 Decimal 会跟入参 Decimal 具有相同的小数部分长度。
### example
@@ -56,6 +60,17 @@ mysql> select truncate(-124.3867, -2);
+-+
|-100 |
+-+
+mysql> select cast("123.123456" as Decimal(9,6)), number, truncate(cast
("123.123456" as Decimal(9,6)), number) from
Re: [PR] [doc] function truncate update [doris-website]
luzhijing merged PR #516: URL: https://github.com/apache/doris-website/pull/516 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](cloud) Only update table version when drop a non-empty partition [doris]
doris-robot commented on PR #32989: URL: https://github.com/apache/doris/pull/32989#issuecomment-2041839453 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit a20c9b1b2f26d815351a658c1d8a9bb959cd08d6 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s Insert into select: 15.5 seconds inserted 1000 Rows, about 645K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [chore](Nereids) turn off fallback [doris]
doris-robot commented on PR #32882: URL: https://github.com/apache/doris/pull/32882#issuecomment-2041839197 TPC-DS: Total hot run time: 181769 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 09ef7fc5ac5a0fc7658b6a432504e4296cf2f944, data reload: false query1 1243113211091109 query2 6480201019501950 query3 6645205 209 205 query4 37710 21516 21355 21355 query5 4143409 400 400 query6 236 181 175 175 query7 4049304 283 283 query8 223 174 188 174 query9 5725230822932293 query10 528 246 246 246 query11 14749 14207 14177 14177 query12 146 88 88 88 query13 1003366 355 355 query14 10202 696767476747 query15 200 184 180 180 query16 6734274 263 263 query17 1557577 560 560 query18 1375283 275 275 query19 196 153 153 153 query20 97 86 87 86 query21 201 127 125 125 query22 4949479247844784 query23 33683 33030 32952 32952 query24 12378 298228752875 query25 579 378 385 378 query26 1677159 156 156 query27 3098306 316 306 query28 7400189218921892 query29 868 622 604 604 query30 302 161 164 161 query31 948 721 714 714 query32 63 58 54 54 query33 590 252 246 246 query34 876 465 493 465 query35 838 686 675 675 query36 1008874 899 874 query37 232 73 71 71 query38 3555345633913391 query39 1579153115231523 query40 277 130 137 130 query41 52 52 45 45 query42 106 95 93 93 query43 485 459 485 459 query44 1417710 706 706 query45 263 284 264 264 query46 1062718 714 714 query47 1896184118671841 query48 364 296 275 275 query49 1133364 356 356 query50 748 373 366 366 query51 6709668365366536 query52 102 90 93 90 query53 359 278 285 278 query54 262 236 236 236 query55 77 70 71 70 query56 240 225 211 211 query57 1182116011051105 query58 222 199 200 199 query59 2926270328082703 query60 252 234 244 234 query61 93 93 90 90 query62 633 434 456 434 query63 309 274 276 274 query64 4889394239293929 query65 3111307030373037 query66 1371330 315 315 query67 15233 14763 14804 14763 query68 7218536 546 536 query69 527 312 312 312 query70 1275115311121112 query71 487 279 268 268 query72 6463267825502550 query73 826 316 318 316 query74 6895636764016367 query75 3217238923682368 query76 4217108411011084 query77 674 253 251 251 query78 10975 10137 10213 10137 query79 7397538 518 518 query80 2015429 426 426 query81 538 238 242 238 query82 1437101 95 95 query83 326 164 172 164 query84 276 86 90 86 query85 1622309 306 306 query86 472 305 318 305 query87 3789356735333533 query88 6045229322972293 query89 492 364 377 364 query90 1939180 180 180 query91 121 95 98 95 query92 64 48 47 47 query93 6121500 488 488 query94 1264176 176 176 query95 391 321 309 309 query96 593 265 259 259 query97 2667246724662466 query98 235 223 211 211 query99 1211836 844 836 Total cold run time: 305627 ms Total hot run time: 181769 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] [Improvement](materialized-view) adjust priority of materialized view… [doris]
doris-robot commented on PR #33348: URL: https://github.com/apache/doris/pull/33348#issuecomment-2041839131 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit a890c204963a8da515d38010b664c32939b516dd with default session variables Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 20.9 seconds inserted 1000 Rows, about 478K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](nereids) fix a visitor bug in CommonSubExpressionOpt [doris]
doris-robot commented on PR #33154: URL: https://github.com/apache/doris/pull/33154#issuecomment-2041838982 ClickBench: Total hot run time: 30.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f5e31f927786d50ada998f7ec2f744b5d6ef8781, data reload: false query1 0.040.030.03 query2 0.080.040.04 query3 0.220.050.05 query4 1.680.070.07 query5 0.500.470.48 query6 1.120.650.65 query7 0.020.010.02 query8 0.050.040.04 query9 0.540.480.49 query10 0.540.560.55 query11 0.160.120.11 query12 0.150.120.11 query13 0.600.590.58 query14 0.770.760.78 query15 0.830.820.81 query16 0.370.350.35 query17 1.010.960.95 query18 0.220.240.25 query19 1.771.731.78 query20 0.010.010.01 query21 15.40 0.650.64 query22 4.486.202.24 query23 18.25 1.281.07 query24 1.620.240.24 query25 0.120.090.08 query26 0.270.160.16 query27 0.070.070.08 query28 13.40 0.990.98 query29 12.61 3.283.29 query30 0.250.060.06 query31 2.850.370.37 query32 3.310.460.45 query33 2.782.822.82 query34 17.22 4.414.41 query35 4.504.484.57 query36 0.640.470.46 query37 0.190.150.14 query38 0.150.140.15 query39 0.050.040.03 query40 0.170.150.13 query41 0.100.050.05 query42 0.050.040.05 query43 0.050.030.03 Total cold run time: 109.21 s Total hot run time: 30.41 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](serde) support complex type in write/read pb serde [doris]
doris-robot commented on PR #33124: URL: https://github.com/apache/doris/pull/33124#issuecomment-2041838650 TeamCity be ut coverage result: Function Coverage: 35.66% (8899/24955) Line Coverage: 27.39% (73101/266864) Region Coverage: 26.56% (37773/142226) Branch Coverage: 23.37% (19250/82380) Coverage Report: http://coverage.selectdb-in.cc/coverage/bc1fdb95f7a18f03b81c904ead8ed3bb3a585b64_bc1fdb95f7a18f03b81c904ead8ed3bb3a585b64/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](txn insert) txn insert support write to one table many times [doris]
doris-robot commented on PR #32980: URL: https://github.com/apache/doris/pull/32980#issuecomment-2041837530 ClickBench: Total hot run time: 31.14 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 8ed7e2d1f979eda02f060b4ccb98d95d39336544, data reload: false query1 0.040.040.03 query2 0.080.030.04 query3 0.220.050.05 query4 1.680.080.08 query5 0.500.490.50 query6 1.110.660.66 query7 0.020.010.01 query8 0.050.040.04 query9 0.560.510.50 query10 0.550.550.54 query11 0.160.110.12 query12 0.150.120.12 query13 0.610.590.59 query14 0.770.780.81 query15 0.850.830.83 query16 0.380.380.37 query17 1.010.940.94 query18 0.200.260.23 query19 1.851.711.87 query20 0.020.010.01 query21 15.42 0.650.65 query22 4.526.332.66 query23 18.27 1.231.15 query24 1.660.310.21 query25 0.120.080.08 query26 0.260.150.15 query27 0.080.080.07 query28 13.32 1.021.00 query29 12.62 3.323.33 query30 0.250.060.06 query31 2.850.400.38 query32 3.300.470.47 query33 2.932.862.85 query34 17.07 4.504.44 query35 4.554.484.55 query36 0.650.470.48 query37 0.200.160.14 query38 0.150.150.14 query39 0.060.040.03 query40 0.190.140.14 query41 0.090.050.04 query42 0.060.050.05 query43 0.040.040.04 Total cold run time: 109.47 s Total hot run time: 31.14 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. [doris]
doris-robot commented on PR #33220: URL: https://github.com/apache/doris/pull/33220#issuecomment-2041837483 ClickBench: Total hot run time: 30.44 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1de35e71ed9ebc0f0456d9d3b47ab767cdb64ed5, data reload: false query1 0.040.030.03 query2 0.080.040.04 query3 0.230.050.06 query4 1.680.080.09 query5 0.520.500.48 query6 1.120.650.65 query7 0.020.010.02 query8 0.050.040.05 query9 0.540.500.49 query10 0.540.570.56 query11 0.170.120.12 query12 0.150.120.12 query13 0.610.590.58 query14 0.750.780.77 query15 0.830.810.80 query16 0.360.390.36 query17 1.030.940.98 query18 0.240.220.23 query19 1.771.711.74 query20 0.020.010.01 query21 15.40 0.640.64 query22 3.856.732.21 query23 18.28 1.251.18 query24 1.740.290.21 query25 0.130.080.08 query26 0.250.160.15 query27 0.080.080.07 query28 13.46 1.000.99 query29 12.60 3.293.29 query30 0.260.070.06 query31 2.860.380.37 query32 3.320.460.46 query33 2.842.812.78 query34 17.18 4.404.43 query35 4.504.484.45 query36 0.640.460.46 query37 0.180.140.14 query38 0.150.140.14 query39 0.050.040.04 query40 0.170.140.14 query41 0.090.050.04 query42 0.050.040.04 query43 0.040.040.04 Total cold run time: 108.87 s Total hot run time: 30.44 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [enhancement](cloud) Only update table version when drop a non-empty partition [doris]
doris-robot commented on PR #32989: URL: https://github.com/apache/doris/pull/32989#issuecomment-2041837117 ClickBench: Total hot run time: 29.5 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a20c9b1b2f26d815351a658c1d8a9bb959cd08d6, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.230.050.05 query4 1.680.060.07 query5 0.480.470.48 query6 1.140.660.65 query7 0.010.010.01 query8 0.050.040.04 query9 0.570.530.52 query10 0.570.570.57 query11 0.160.120.12 query12 0.150.120.12 query13 0.610.600.61 query14 0.780.800.81 query15 0.850.850.83 query16 0.350.360.35 query17 0.990.980.96 query18 0.260.250.25 query19 1.841.701.79 query20 0.010.000.00 query21 15.43 0.640.66 query22 3.808.241.20 query23 17.88 1.311.23 query24 1.590.190.20 query25 0.150.080.08 query26 0.270.160.16 query27 0.070.080.08 query28 13.87 0.970.94 query29 12.57 3.303.25 query30 0.260.060.06 query31 2.910.400.39 query32 3.270.480.48 query33 2.822.912.87 query34 15.52 4.334.34 query35 4.394.374.35 query36 0.690.470.48 query37 0.180.170.16 query38 0.160.140.14 query39 0.050.030.03 query40 0.200.150.15 query41 0.100.050.05 query42 0.060.050.04 query43 0.040.040.04 Total cold run time: 107.13 s Total hot run time: 29.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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [feature](Cloud) Add one config to control FE's startup with or without built in vault [doris]
github-actions[bot] commented on PR #33308: URL: https://github.com/apache/doris/pull/33308#issuecomment-2041836120 clang-tidy review says "All clean, LGTM! :+1:" -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Improvement](materialized-view) adjust priority of materialized view… [doris]
doris-robot commented on PR #33348: URL: https://github.com/apache/doris/pull/33348#issuecomment-2041836626 ClickBench: Total hot run time: 31.05 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a890c204963a8da515d38010b664c32939b516dd, data reload: false query1 0.030.020.02 query2 0.060.030.02 query3 0.250.050.04 query4 1.810.060.07 query5 0.530.530.51 query6 1.240.610.61 query7 0.020.010.01 query8 0.040.020.02 query9 0.520.490.48 query10 0.540.530.54 query11 0.120.090.09 query12 0.120.100.10 query13 0.620.610.61 query14 0.790.770.78 query15 0.790.750.76 query16 0.390.360.36 query17 1.011.010.99 query18 0.230.260.24 query19 1.961.871.84 query20 0.010.010.01 query21 15.46 0.560.54 query22 2.052.351.86 query23 16.93 1.140.96 query24 7.270.961.79 query25 0.360.130.04 query26 0.880.170.16 query27 0.050.040.04 query28 5.180.720.71 query29 12.71 2.302.32 query30 0.610.610.54 query31 2.810.390.38 query32 3.380.500.49 query33 3.083.083.13 query34 15.24 4.824.80 query35 4.884.884.87 query36 1.061.021.01 query37 0.060.050.05 query38 0.030.030.02 query39 0.020.010.01 query40 0.170.140.14 query41 0.070.010.01 query42 0.020.010.02 query43 0.020.020.01 Total cold run time: 103.42 s Total hot run time: 31.05 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [auth](enhance)remove some method in AccessControllerManager [doris]
doris-robot commented on PR #33320: URL: https://github.com/apache/doris/pull/33320#issuecomment-2041835600 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 4bb66df43d6a3d7b70dadc67cb94cab3c7e2c2c2 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.4 seconds inserted 1000 Rows, about 746K ops/s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](serde) support complex type in write/read pb serde [doris]
doris-robot commented on PR #33124: URL: https://github.com/apache/doris/pull/33124#issuecomment-2041835478 TPC-DS: Total hot run time: 181576 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 bc1fdb95f7a18f03b81c904ead8ed3bb3a585b64, data reload: false query1 1211112511151115 query2 6486196517331733 query3 6644214 219 214 query4 23735 21397 21535 21397 query5 4199431 434 431 query6 285 197 192 192 query7 4602305 300 300 query8 245 185 181 181 query9 8451226122642261 query10 577 251 254 251 query11 15001 14810 14522 14522 query12 138 95 90 90 query13 1622376 369 369 query14 8730685268906852 query15 215 191 188 188 query16 7147271 268 268 query17 1010616 587 587 query18 1916295 280 280 query19 207 161 160 160 query20 102 91 91 91 query21 200 140 137 137 query22 4928485047664766 query23 33395 32712 32547 32547 query24 1 326932073207 query25 716 401 406 401 query26 1917162 162 162 query27 3012316 329 316 query28 6688185018311831 query29 1392605 591 591 query30 297 176 166 166 query31 964 734 732 732 query32 102 57 55 55 query33 660 263 262 262 query34 929 495 515 495 query35 862 692 708 692 query36 998 872 862 862 query37 279 78 74 74 query38 3481337733813377 query39 1574154215191519 query40 297 134 139 134 query41 50 49 51 49 query42 105 101 101 101 query43 465 424 403 403 query44 1214707 709 707 query45 290 270 259 259 query46 1127854 823 823 query47 1879177417671767 query48 382 301 296 296 query49 1164389 387 387 query50 890 404 399 399 query51 6698664766306630 query52 108 95 95 95 query53 389 298 291 291 query54 293 260 235 235 query55 85 75 75 75 query56 254 241 232 232 query57 1236113610951095 query58 247 215 223 215 query59 2684235923202320 query60 274 252 254 252 query61 109 106 106 106 query62 707 459 458 458 query63 317 284 288 284 query64 6398339934103399 query65 3087301329972997 query66 1438331 315 315 query67 15753 14834 14906 14834 query68 8464564 583 564 query69 549 304 309 304 query70 1354108811341088 query71 507 284 274 274 query72 6348256824202420 query73 839 319 318 318 query74 6583637263806372 query75 3749238923492349 query76 6142123113361231 query77 680 251 247 247 query78 10843 10198 10156 10156 query79 8530539 558 539 query80 1252434 431 431 query81 498 238 240 238 query82 703 96 99 96 query83 203 173 164 164 query84 272 95 88 88 query85 1457283 275 275 query86 428 301 293 293 query87 3677350735033503 query88 3725226522762265 query89 569 392 383 383 query90 2066180 178 178 query91 136 108 104 104 query92 59 49 54 49 query93 6578537 528 528 query94 1099184 178 178 query95 430 321 323 321 query96 656 270 270 270 query97 2683257124832483 query98 230 215 206 206 query99 1371829 877 829 Total cold run time: 296648 ms Total hot run time: 181576 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] [fix](nereids) fix a visitor bug in CommonSubExpressionOpt [doris]
doris-robot commented on PR #33154: URL: https://github.com/apache/doris/pull/33154#issuecomment-2041834730 TPC-DS: Total hot run time: 181613 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 f5e31f927786d50ada998f7ec2f744b5d6ef8781, data reload: false query1 12201131345 345 query2 6998203418851885 query3 6683203 200 200 query4 36792 21548 21253 21253 query5 4163392 396 392 query6 241 187 176 176 query7 4055287 285 285 query8 223 176 187 176 query9 5753229422992294 query10 381 233 231 231 query11 14775 14207 14237 14207 query12 135 86 85 85 query13 969 357 366 357 query14 9001686670806866 query15 226 176 172 172 query16 7557250 251 250 query17 1865570 541 541 query18 1835290 264 264 query19 186 145 148 145 query20 90 85 84 84 query21 202 123 126 123 query22 4991484748454845 query23 33621 33035 33343 33035 query24 11360 303029962996 query25 498 365 423 365 query26 811 165 173 165 query27 2929366 375 366 query28 7552195119371937 query29 862 655 635 635 query30 321 180 178 178 query31 947 750 752 750 query32 61 56 59 56 query33 572 249 251 249 query34 1134495 498 495 query35 874 726 737 726 query36 1054928 927 927 query37 123 74 78 74 query38 3672370736203620 query39 1679159615851585 query40 188 135 136 135 query41 50 48 46 46 query42 114 101 104 101 query43 499 470 452 452 query44 1392729 761 729 query45 296 293 261 261 query46 1096752 702 702 query47 2018193419191919 query48 367 293 300 293 query49 877 373 385 373 query50 787 387 414 387 query51 6863679868256798 query52 102 92 93 92 query53 381 276 291 276 query54 277 245 230 230 query55 86 74 78 74 query56 253 230 240 230 query57 1282116211881162 query58 230 207 209 207 query59 3023272026012601 query60 254 235 239 235 query61 101 89 88 88 query62 582 445 431 431 query63 304 281 274 274 query64 4149370438343704 query65 3096306130353035 query66 710 330 314 314 query67 15571 15030 14834 14834 query68 10650 551 544 544 query69 615 306 299 299 query70 1400111211781112 query71 499 264 273 264 query72 6627259224132413 query73 1948315 318 315 query74 7602638963176317 query75 3596229522762276 query76 6539114411321132 query77 635 249 244 244 query78 10905 10155 10166 10155 query79 11521 517 516 516 query80 2451410 423 410 query81 565 226 228 226 query82 252 93 89 89 query83 207 167 159 159 query84 261 79 83 79 query85 1095271 258 258 query86 346 298 269 269 query87 3707357334783478 query88 5875228722982287 query89 496 374 367 367 query90 2383185 186 185 query91 120 92 91 91 query92 59 45 46 45 query93 6680496 501 496 query94 1565182 176 176 query95 407 303 296 296 query96 625 268 263 263 query97 2643249725052497 query98 232 218 214 214 query99 1123868 823 823 Total cold run time: 314988 ms Total hot run time: 181613 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] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
github-actions[bot] commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041834583 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
github-actions[bot] commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041834541 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improvement](storage) support glibc <2.21 for system call eventfd [doris]
adonis0147 commented on PR #33218: URL: https://github.com/apache/doris/pull/33218#issuecomment-2041834099 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [improve](txn insert) txn insert support write to one table many times [doris]
doris-robot commented on PR #32980: URL: https://github.com/apache/doris/pull/32980#issuecomment-2041833272 TPC-DS: Total hot run time: 181749 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 8ed7e2d1f979eda02f060b4ccb98d95d39336544, data reload: false query1 888 11091109 query2 6464188318681868 query3 6654202 212 202 query4 37546 21732 21454 21454 query5 4137395 391 391 query6 223 176 175 175 query7 4044286 283 283 query8 218 165 167 165 query9 5751228322732273 query10 510 236 242 236 query11 14572 14211 14151 14151 query12 138 91 88 88 query13 979 354 353 353 query14 10275 675468096754 query15 207 184 177 177 query16 6749261 263 261 query17 1673595 557 557 query18 1397291 271 271 query19 194 153 148 148 query20 91 88 82 82 query21 199 131 132 131 query22 4985489948494849 query23 33569 33017 32992 32992 query24 12254 299929302930 query25 541 358 377 358 query26 1849150 158 150 query27 3085301 318 301 query28 7419191218781878 query29 855 590 584 584 query30 306 162 163 162 query31 887 677 711 677 query32 59 52 51 51 query33 584 247 245 245 query34 888 468 476 468 query35 816 685 700 685 query36 1038924 898 898 query37 230 69 71 69 query38 3551338834173388 query39 1579153315531533 query40 276 131 138 131 query41 50 47 46 46 query42 106 98 98 98 query43 503 436 456 436 query44 1445717 720 717 query45 280 264 275 264 query46 1083716 733 716 query47 1903187118331833 query48 375 290 289 289 query49 1150372 364 364 query50 761 383 393 383 query51 6824657666966576 query52 106 93 96 93 query53 356 280 282 280 query54 265 234 230 230 query55 78 73 74 73 query56 241 222 227 222 query57 1216113111511131 query58 230 204 208 204 query59 2845271025592559 query60 259 241 252 241 query61 107 111 109 109 query62 624 434 422 422 query63 313 284 286 284 query64 4996414539643964 query65 3153306330293029 query66 1345340 328 328 query67 15431 14963 15219 14963 query68 8461537 532 532 query69 607 311 313 311 query70 1254115011271127 query71 548 272 267 267 query72 6621274124382438 query73 833 317 316 316 query74 7109638363476347 query75 3686228323542283 query76 5007110011001100 query77 647 238 238 238 query78 10869 10260 10187 10187 query79 9961535 510 510 query80 2055413 418 413 query81 502 230 234 230 query82 131393 98 93 query83 216 170 167 167 query84 263 79 82 79 query85 256 258 256 query86 500 291 280 280 query87 3729355635373537 query88 6119228722922287 query89 533 366 376 366 query90 1981182 181 181 query91 120 96 95 95 query92 61 46 49 46 query93 7212507 497 497 query94 1214176 177 176 query95 397 304 310 304 query96 600 265 261 261 query97 2678247424982474 query98 241 219 210 210 query99 1167863 809 809 Total cold run time: 311340 ms Total hot run time: 181749 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] [fix](statistics)Set enable_unique_key_partial_update to false in statistics session variable. [doris]
doris-robot commented on PR #33220: URL: https://github.com/apache/doris/pull/33220#issuecomment-2041833138 TPC-DS: Total hot run time: 183300 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 1de35e71ed9ebc0f0456d9d3b47ab767cdb64ed5, data reload: false query1 914 111311161113 query2 6805211519251925 query3 6660202 202 202 query4 36776 21530 21629 21530 query5 4134401 401 401 query6 241 189 176 176 query7 4041288 283 283 query8 225 172 170 170 query9 5704225322532253 query10 362 232 240 232 query11 14728 14165 14236 14165 query12 130 91 86 86 query13 992 350 350 350 query14 9315689368256825 query15 209 195 182 182 query16 7270282 253 253 query17 1641591 546 546 query18 1534282 277 277 query19 195 156 154 154 query20 96 87 86 86 query21 208 135 124 124 query22 4930484047964796 query23 33889 32940 33340 32940 query24 11358 302630633026 query25 563 417 388 388 query26 1467165 159 159 query27 3042380 365 365 query28 7450195120131951 query29 888 634 642 634 query30 287 176 176 176 query31 972 758 735 735 query32 61 56 56 56 query33 568 263 260 260 query34 911 488 500 488 query35 855 682 701 682 query36 1077945 955 945 query37 122 75 72 72 query38 3723362436543624 query39 1617157315881573 query40 173 133 130 130 query41 48 44 46 44 query42 100 108 97 97 query43 504 472 456 456 query44 1331724 745 724 query45 294 265 263 263 query46 1094756 733 733 query47 2038196519921965 query48 371 290 297 290 query49 862 373 381 373 query50 769 396 399 396 query51 6897675867726758 query52 97 102 93 93 query53 343 273 278 273 query54 249 222 220 220 query55 73 71 73 71 query56 237 220 218 218 query57 1194112711281127 query58 218 205 208 205 query59 2942259125152515 query60 255 232 225 225 query61 93 89 93 89 query62 581 433 423 423 query63 301 275 274 274 query64 4021390638333833 query65 3079300530393005 query66 729 314 306 306 query67 15525 15205 14889 14889 query68 10845 554 552 552 query69 622 305 302 302 query70 1246115211041104 query71 519 267 286 267 query72 6561261524402440 query73 1762318 319 318 query74 7278647163996399 query75 3657235623172317 query76 6615110210931093 query77 631 255 250 250 query78 10973 10266 10012 10012 query79 11529 518 515 515 query80 2170416 411 411 query81 563 228 229 228 query82 247 88 93 88 query83 218 166 164 164 query84 269 82 80 80 query85 1098269 263 263 query86 340 306 278 278 query87 3764355035003500 query88 5948227423792274 query89 503 373 378 373 query90 2376178 176 176 query91 121 95 93 93 query92 57 48 54 48 query93 6498511 506 506 query94 1567182 179 179 query95 1118110110951095 query96 602 261 258 258 query97 2672247724812477 query98 221 214 212 212 query99 1082838 830 830 Total cold run time: 314050 ms Total hot run time: 183300 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] [auth](enhance)remove some method in AccessControllerManager [doris]
doris-robot commented on PR #33320: URL: https://github.com/apache/doris/pull/33320#issuecomment-2041833097 ClickBench: Total hot run time: 31.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4bb66df43d6a3d7b70dadc67cb94cab3c7e2c2c2, data reload: false query1 0.040.040.03 query2 0.080.040.04 query3 0.220.060.05 query4 1.670.080.08 query5 0.500.490.49 query6 1.130.660.66 query7 0.020.010.01 query8 0.050.040.04 query9 0.540.500.51 query10 0.550.560.56 query11 0.170.120.11 query12 0.150.120.13 query13 0.600.590.58 query14 0.750.790.77 query15 0.820.800.79 query16 0.350.360.37 query17 0.951.001.02 query18 0.220.240.23 query19 1.921.741.76 query20 0.010.010.01 query21 15.43 0.650.64 query22 3.866.522.74 query23 18.21 1.311.20 query24 1.650.280.22 query25 0.130.070.08 query26 0.260.160.16 query27 0.080.080.08 query28 13.46 0.990.97 query29 12.58 3.323.26 query30 0.240.060.06 query31 2.850.370.37 query32 3.320.450.46 query33 2.802.782.91 query34 17.22 4.404.40 query35 4.484.464.52 query36 0.660.470.47 query37 0.190.150.14 query38 0.160.130.13 query39 0.050.040.04 query40 0.170.140.14 query41 0.100.040.04 query42 0.060.040.05 query43 0.040.040.04 Total cold run time: 108.74 s Total hot run time: 31.07 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
