Re: [PR] [feature](index) remove OR predicate support for bitmap index [doris]
doris-robot commented on PR #30951: URL: https://github.com/apache/doris/pull/30951#issuecomment-1931478250 TeamCity be ut coverage result: Function Coverage: 36.17% (8638/23880) Line Coverage: 28.20% (70625/250461) Region Coverage: 27.18% (36435/134031) Branch Coverage: 23.97% (18662/77844) Coverage Report: http://coverage.selectdb-in.cc/coverage/d28afd1b3c8e80f75a0120d50812084bb90a5d84_d28afd1b3c8e80f75a0120d50812084bb90a5d84/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](index) Replace BITMAP INDEX with INVERTED INDEX [doris]
doris-robot commented on PR #30950: URL: https://github.com/apache/doris/pull/30950#issuecomment-1931482872 TPC-DS: Total hot run time: 174010 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 7fa8984fbb22769043697ff03e2e4492d5e40ba4, data reload: false query1 933 342 337 337 query2 6532190619041904 query3 6697209 204 204 query4 31916 22146 22000 22000 query5 4225360 403 360 query6 256 163 160 160 query7 4606291 281 281 query8 268 173 176 173 query9 9106226322382238 query10 415 213 230 213 query11 18787 15387 15323 15323 query12 129 76 75 75 query13 1617422 408 408 query14 9200717566846684 query15 237 184 184 184 query16 8165261 248 248 query17 2007537 499 499 query18 2101274 263 263 query19 358 139 135 135 query20 79 77 81 77 query21 195 123 129 123 query22 4953463245944594 query23 31046 30104 30013 30013 query24 10970 279527292729 query25 586 342 338 338 query26 1366152 155 152 query27 2864309 306 306 query28 7432183318301830 query29 869 625 606 606 query30 290 129 144 129 query31 931 709 706 706 query32 87 57 51 51 query33 726 219 225 219 query34 1065458 457 457 query35 878 757 741 741 query36 1082932 938 932 query37 115 58 56 56 query38 3203308330743074 query39 1309125612331233 query40 188 91 94 91 query41 36 36 34 34 query42 96 86 90 86 query43 502 505 527 505 query44 1102678 686 678 query45 191 182 175 175 query46 1056642 642 642 query47 1628142215091422 query48 415 351 347 347 query49 1094295 289 289 query50 774 372 383 372 query51 5244516951685168 query52 99 92 86 86 query53 338 272 279 272 query54 274 215 215 215 query55 83 77 75 75 query56 216 200 210 200 query57 935 894 887 887 query58 199 177 179 177 query59 2520232823792328 query60 232 213 219 213 query61 82 81 86 81 query62 668 371 354 354 query63 294 273 268 268 query64 5235368934013401 query65 3236322432423224 query66 954 305 305 305 query67 14206 14286 14208 14208 query68 4405537 561 537 query69 453 328 343 328 query70 1267125112511251 query71 337 255 251 251 query72 5946284026882688 query73 711 334 323 323 query74 6664615561676155 query75 3021234423642344 query76 2559885 876 876 query77 445 234 225 225 query78 9223879684638463 query79 2619506 489 489 query80 2213346 332 332 query81 543 197 202 197 query82 908 83 79 79 query83 255 125 120 120 query84 282 90 74 74 query85 2319328 327 327 query86 498 301 295 295 query87 3417327732043204 query88 4191237823842378 query89 420 364 367 364 query90 2164160 161 160 query91 168 120 140 120 query92 58 43 44 43 query93 4140498 487 487 query94 1401172 175 172 query95 479 356 345 345 query96 610 272 275 272 query97 4241408041614080 query98 238 202 189 189 query99 1086684 700 684 Total cold run time: 286779 ms Total hot run time: 174010 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 sp
Re: [PR] [fix](regex) fix wrong escape of function LIKE [doris]
doris-robot commented on PR #30557: URL: https://github.com/apache/doris/pull/30557#issuecomment-1931486312 TPC-H: Total hot run time: 37576 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit e45d312d4122b36ba599109b3a8a973023e7ce79, data reload: false -- Round 1 -- q1 17833 458545414541 q2 2389160 138 138 q3 11456 950 939 939 q4 4862796 783 783 q5 7766300429472947 q6 191 127 126 126 q7 1180762 733 733 q8 9324206520542054 q9 7933636363316331 q10 8117241424032403 q11 410 204 210 204 q12 814 290 289 289 q13 18013 336833223322 q14 281 259 240 240 q15 527 496 488 488 q16 471 410 417 410 q17 950 594 516 516 q18 6754599860825998 q19 1558141213891389 q20 644 343 341 341 q21 6728307531373075 q22 815 309 312 309 Total cold run time: 109016 ms Total hot run time: 37576 ms - Round 2, with runtime_filter_mode=off - q1 4494445344124412 q2 326 227 232 227 q3 2953282227992799 q4 1891164016841640 q5 5199519252315192 q6 191 114 115 114 q7 2099178317921783 q8 3147329432543254 q9 8324828782398239 q10 5848353035593530 q11 551 458 474 458 q12 761 592 575 575 q13 5122309830713071 q14 275 236 257 236 q15 527 480 493 480 q16 541 473 473 473 q17 1851172117321721 q18 8082765774917491 q19 6830152115311521 q20 2133193518971897 q21 4866469145654565 q22 537 474 470 470 Total cold run time: 66548 ms Total hot run time: 54148 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](index) remove OR predicate support for bitmap index [doris]
doris-robot commented on PR #30951: URL: https://github.com/apache/doris/pull/30951#issuecomment-1931491233 TPC-DS: Total hot run time: 174259 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 d28afd1b3c8e80f75a0120d50812084bb90a5d84, data reload: false query1 927 343 342 342 query2 6528185718451845 query3 6695210 203 203 query4 31884 21982 22046 21982 query5 4243423 421 421 query6 253 170 167 167 query7 4626277 279 277 query8 254 172 181 172 query9 9024234523142314 query10 404 226 219 219 query11 18970 15556 15285 15285 query12 129 77 79 77 query13 1622429 414 414 query14 9241720672347206 query15 247 175 185 175 query16 8145254 241 241 query17 2034547 491 491 query18 2103260 258 258 query19 364 142 137 137 query20 82 76 76 76 query21 194 126 119 119 query22 4851459043914391 query23 31898 29984 30096 29984 query24 11025 272227682722 query25 574 337 351 337 query26 1393145 147 145 query27 2908303 305 303 query28 7386186318481848 query29 863 618 615 615 query30 279 136 138 136 query31 894 705 711 705 query32 95 54 49 49 query33 735 216 217 216 query34 1056460 455 455 query35 859 782 771 771 query36 1021918 933 918 query37 116 55 55 55 query38 3229311331133113 query39 1285127012291229 query40 185 92 91 91 query41 38 36 35 35 query42 99 88 96 88 query43 503 490 491 490 query44 1124692 699 692 query45 194 184 181 181 query46 1052658 668 658 query47 1589155014441444 query48 410 377 350 350 query49 1098283 285 283 query50 759 370 387 370 query51 5283514551115111 query52 103 81 87 81 query53 349 268 276 268 query54 274 214 218 214 query55 86 81 72 72 query56 218 203 195 195 query57 995 917 897 897 query58 198 177 175 175 query59 2431231423152314 query60 237 222 215 215 query61 82 87 81 81 query62 672 348 367 348 query63 298 269 268 268 query64 5539359136583591 query65 3260324632223222 query66 1001309 307 307 query67 14598 14084 14072 14072 query68 4358541 531 531 query69 462 312 319 312 query70 1256121511861186 query71 328 255 242 242 query72 6046282526682668 query73 710 320 323 320 query74 6599614462056144 query75 3036237023072307 query76 2906963 953 953 query77 349 231 223 223 query78 9149863884988498 query79 2964493 504 493 query80 2022342 342 342 query81 547 196 197 196 query82 837 86 76 76 query83 240 122 125 122 query84 285 84 76 76 query85 2202341 322 322 query86 482 314 304 304 query87 3360321331873187 query88 4276230323202303 query89 444 374 353 353 query90 1934164 161 161 query91 144 121 118 118 query92 56 43 45 43 query93 4862466 488 466 query94 1234179 171 171 query95 469 354 7883354 query96 593 274 273 273 query97 4265412841074107 query98 221 205 209 205 query99 1117677 678 677 Total cold run time: 288864 ms Total hot run time: 174259 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 sp
Re: [PR] [feature](index) Replace BITMAP INDEX with INVERTED INDEX [doris]
doris-robot commented on PR #30950: URL: https://github.com/apache/doris/pull/30950#issuecomment-1931491140 ClickBench: Total hot run time: 30.75 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 7fa8984fbb22769043697ff03e2e4492d5e40ba4, data reload: false query1 0.040.030.04 query2 0.060.020.02 query3 0.240.060.07 query4 1.670.100.10 query5 0.520.520.52 query6 1.180.660.68 query7 0.020.010.01 query8 0.040.020.03 query9 0.550.510.51 query10 0.560.540.56 query11 0.120.080.08 query12 0.110.090.10 query13 0.600.610.60 query14 0.780.800.80 query15 0.810.780.77 query16 0.400.370.38 query17 1.041.051.03 query18 0.220.250.27 query19 1.821.741.80 query20 0.010.010.01 query21 15.40 0.560.56 query22 2.422.451.70 query23 17.34 0.780.75 query24 2.400.861.44 query25 0.380.100.06 query26 0.600.130.15 query27 0.050.050.06 query28 11.26 0.850.87 query29 12.57 3.153.31 query30 0.650.560.55 query31 2.810.350.37 query32 3.340.480.48 query33 3.233.253.19 query34 15.99 4.324.30 query35 4.274.264.25 query36 1.121.081.05 query37 0.060.050.05 query38 0.030.030.03 query39 0.020.020.02 query40 0.170.130.12 query41 0.070.020.01 query42 0.020.010.02 query43 0.020.020.02 Total cold run time: 105.01 s Total hot run time: 30.75 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](join) optimization for build_side_output_column [doris]
BiteThet commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931480812 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](index) Replace BITMAP INDEX with INVERTED INDEX [doris]
doris-robot commented on PR #30950: URL: https://github.com/apache/doris/pull/30950#issuecomment-1931495299 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 7fa8984fbb22769043697ff03e2e4492d5e40ba4 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.5 seconds inserted 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] [feature](index) remove OR predicate support for bitmap index [doris]
doris-robot commented on PR #30951: URL: https://github.com/apache/doris/pull/30951#issuecomment-1931498998 ClickBench: Total hot run time: 30.93 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d28afd1b3c8e80f75a0120d50812084bb90a5d84, data reload: false query1 0.040.030.02 query2 0.060.020.02 query3 0.220.060.06 query4 1.670.090.10 query5 0.540.510.52 query6 1.180.630.66 query7 0.020.010.01 query8 0.030.020.02 query9 0.580.500.51 query10 0.550.540.54 query11 0.110.080.08 query12 0.100.080.09 query13 0.600.600.60 query14 0.780.810.81 query15 0.790.780.77 query16 0.410.400.38 query17 1.041.011.02 query18 0.210.270.25 query19 1.851.801.80 query20 0.020.010.01 query21 15.44 0.600.54 query22 2.552.072.27 query23 17.26 0.750.80 query24 3.040.630.85 query25 0.280.200.18 query26 0.480.130.14 query27 0.040.050.04 query28 11.47 0.840.84 query29 12.62 3.203.19 query30 0.650.520.53 query31 2.800.350.35 query32 3.340.480.48 query33 3.223.153.26 query34 15.72 4.284.30 query35 4.304.294.29 query36 1.081.051.06 query37 0.060.050.05 query38 0.030.020.02 query39 0.020.020.01 query40 0.160.130.13 query41 0.070.010.01 query42 0.020.020.01 query43 0.030.020.02 Total cold run time: 105.48 s Total hot run time: 30.93 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] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
BePPPower commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931500289 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] [fix](regex) fix wrong escape of function LIKE [doris]
doris-robot commented on PR #30557: URL: https://github.com/apache/doris/pull/30557#issuecomment-1931499347 TeamCity be ut coverage result: Function Coverage: 36.17% (8638/23882) Line Coverage: 28.20% (70628/250479) Region Coverage: 27.20% (36467/134080) Branch Coverage: 23.98% (18676/77890) Coverage Report: http://coverage.selectdb-in.cc/coverage/e45d312d4122b36ba599109b3a8a973023e7ce79_e45d312d4122b36ba599109b3a8a973023e7ce79/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](regex) fix wrong escape of function LIKE [doris]
doris-robot commented on PR #30557: URL: https://github.com/apache/doris/pull/30557#issuecomment-1931502946 TPC-DS: Total hot run time: 173612 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 e45d312d4122b36ba599109b3a8a973023e7ce79, data reload: false query1 923 341 333 333 query2 6548192720081927 query3 6708209 202 202 query4 31611 21987 21935 21935 query5 4283369 363 363 query6 251 158 166 158 query7 4615282 280 280 query8 265 174 181 174 query9 9053223822192219 query10 421 209 214 209 query11 19006 15246 15317 15246 query12 132 75 73 73 query13 1632418 419 418 query14 9507704771187047 query15 264 181 179 179 query16 8147271 249 249 query17 2054537 490 490 query18 2102269 262 262 query19 362 141 140 140 query20 83 87 77 77 query21 202 123 115 115 query22 4805456246034562 query23 31718 29981 29948 29948 query24 11160 275927712759 query25 575 338 336 336 query26 1711149 148 148 query27 2921294 310 294 query28 7397184718001800 query29 964 633 604 604 query30 282 131 140 131 query31 928 693 719 693 query32 97 59 50 50 query33 729 221 225 221 query34 1091462 461 461 query35 916 743 731 731 query36 1020934 932 932 query37 115 56 57 56 query38 3260313630663066 query39 1319126312401240 query40 265 92 92 92 query41 36 35 34 34 query42 96 92 89 89 query43 529 509 495 495 query44 1148675 692 675 query45 186 180 175 175 query46 1056663 659 659 query47 1611147214671467 query48 418 351 353 351 query49 1181291 286 286 query50 760 389 377 377 query51 5271521651025102 query52 104 94 86 86 query53 332 268 261 261 query54 276 207 220 207 query55 83 75 75 75 query56 224 206 203 203 query57 1007904 903 903 query58 208 173 187 173 query59 2493245323392339 query60 236 210 208 208 query61 83 84 90 84 query62 639 346 362 346 query63 293 269 263 263 query64 6390347231973197 query65 3228322832183218 query66 1072313 306 306 query67 14197 13921 14247 13921 query68 4313535 537 535 query69 464 335 331 331 query70 1272123212371232 query71 320 243 252 243 query72 5980284226332633 query73 707 331 326 326 query74 6519618162006181 query75 3047230523242305 query76 2549913 887 887 query77 455 233 222 222 query78 9193878185848584 query79 2767485 490 485 query80 2038353 345 345 query81 540 197 196 196 query82 796 85 79 79 query83 245 120 128 120 query84 298 84 79 79 query85 2277346 321 321 query86 491 311 298 298 query87 3362321131833183 query88 3834236223722362 query89 439 367 351 351 query90 2130164 166 164 query91 156 118 123 118 query92 63 45 42 42 query93 2715498 492 492 query94 1385177 172 172 query95 81237849358 358 query96 588 281 276 276 query97 4215410440924092 query98 222 198 190 190 query99 1061690 697 690 Total cold run time: 295163 ms Total hot run time: 173612 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 sp
Re: [PR] [feature](index) remove OR predicate support for bitmap index [doris]
doris-robot commented on PR #30951: URL: https://github.com/apache/doris/pull/30951#issuecomment-1931503283 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit d28afd1b3c8e80f75a0120d50812084bb90a5d84 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 14.5 seconds inserted 1000 Rows, about 689K 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
[PR] [fix](test) Increase the timeout duration for the test case [doris]
liaoxin01 opened a new pull request, #30952: URL: https://github.com/apache/doris/pull/30952 ## 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](test) Increase the timeout duration for the test case [doris]
doris-robot commented on PR #30952: URL: https://github.com/apache/doris/pull/30952#issuecomment-1931510548 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](join) optimization for build_side_output_column [doris]
doris-robot commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931510755 TeamCity be ut coverage result: Function Coverage: 36.16% (8636/23883) Line Coverage: 28.18% (70585/250510) Region Coverage: 27.16% (36406/134060) Branch Coverage: 23.94% (18645/77872) Coverage Report: http://coverage.selectdb-in.cc/coverage/eebe1eaebae9b691485a9c965dae381e5c070eb3_eebe1eaebae9b691485a9c965dae381e5c070eb3/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](test) Increase the timeout duration for the test case [doris]
liaoxin01 commented on PR #30952: URL: https://github.com/apache/doris/pull/30952#issuecomment-1931510779 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] [fix](regex) fix wrong escape of function LIKE [doris]
doris-robot commented on PR #30557: URL: https://github.com/apache/doris/pull/30557#issuecomment-1931511405 ClickBench: Total hot run time: 30.91 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit e45d312d4122b36ba599109b3a8a973023e7ce79, data reload: false query1 0.040.040.03 query2 0.060.030.03 query3 0.240.060.05 query4 1.650.100.10 query5 0.540.520.52 query6 1.200.640.63 query7 0.010.010.01 query8 0.040.030.02 query9 0.560.500.50 query10 0.550.540.56 query11 0.120.080.08 query12 0.110.080.09 query13 0.600.610.61 query14 0.780.800.82 query15 0.780.780.77 query16 0.380.380.38 query17 1.041.041.00 query18 0.220.270.24 query19 1.921.801.74 query20 0.010.000.01 query21 15.43 0.580.55 query22 2.772.342.30 query23 17.43 0.790.85 query24 2.510.561.40 query25 0.310.190.09 query26 0.510.150.14 query27 0.050.060.06 query28 12.71 0.840.83 query29 12.50 3.293.09 query30 0.600.530.56 query31 2.780.350.36 query32 3.330.470.48 query33 3.153.253.17 query34 16.04 4.254.25 query35 4.294.304.31 query36 1.101.041.04 query37 0.070.050.05 query38 0.040.030.02 query39 0.020.020.01 query40 0.170.130.13 query41 0.070.010.02 query42 0.030.020.02 query43 0.030.020.02 Total cold run time: 106.79 s Total hot run time: 30.91 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] [DNM](Nereids) test disable fallback [doris]
doris-robot commented on PR #25344: URL: https://github.com/apache/doris/pull/25344#issuecomment-1931512649 TPC-H: Total hot run time: 36937 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 9a2bb6d5f46ad4e0a8cabf1b6be20e662b9229ea, data reload: false -- Round 1 -- q1 17636 438344234383 q2 2033141 136 136 q3 10593 911 894 894 q4 4660677 678 677 q5 7692279728032797 q6 180 120 119 119 q7 1125724 719 719 q8 9315198420211984 q9 7268633663496336 q10 8074245623902390 q11 423 202 210 202 q12 726 274 263 263 q13 18016 327132943271 q14 273 244 251 244 q15 525 485 495 485 q16 455 408 426 408 q17 927 565 531 531 q18 6805604260896042 q19 1534136214191362 q20 630 340 336 336 q21 6902304530823045 q22 813 315 313 313 Total cold run time: 106605 ms Total hot run time: 36937 ms - Round 2, with runtime_filter_mode=off - q1 4475440643824382 q2 332 236 222 222 q3 3000278028192780 q4 1819172117331721 q5 5103521451865186 q6 193 113 112 112 q7 2145179417561756 q8 3086321632613216 q9 8280828382828282 q10 5884354735303530 q11 548 460 452 452 q12 760 574 565 565 q13 14746 306430903064 q14 290 246 256 246 q15 528 488 491 488 q16 512 470 471 470 q17 1815169117061691 q18 7907765974477447 q19 8816154014851485 q20 2132191118901890 q21 4864460044664466 q22 550 462 484 462 Total cold run time: 77785 ms Total hot run time: 53913 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] [fix](regex) fix wrong escape of function LIKE [doris]
doris-robot commented on PR #30557: URL: https://github.com/apache/doris/pull/30557#issuecomment-1931516286 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit e45d312d4122b36ba599109b3a8a973023e7ce79 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.9 seconds inserted 1000 Rows, about 719K 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](scanner) refactoring and optimizing scanner scheduling [doris]
github-actions[bot] commented on PR #30746: URL: https://github.com/apache/doris/pull/30746#issuecomment-1931524836 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](join) optimization for build_side_output_column [doris]
doris-robot commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931526274 TPC-H: Total hot run time: 37002 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit eebe1eaebae9b691485a9c965dae381e5c070eb3, data reload: false -- Round 1 -- q1 17666 464944244424 q2 2034140 143 140 q3 10677 956 899 899 q4 4646749 702 702 q5 7709289628292829 q6 179 121 124 121 q7 1097739 709 709 q8 9262197619691969 q9 7206631963316319 q10 8077245224582452 q11 405 207 210 207 q12 781 261 261 261 q13 18027 334032923292 q14 277 248 253 248 q15 540 492 491 491 q16 480 394 392 392 q17 915 506 561 506 q18 6716594659385938 q19 1557141214401412 q20 574 353 327 327 q21 6555307631443076 q22 1208288 301 288 Total cold run time: 106588 ms Total hot run time: 37002 ms - Round 2, with runtime_filter_mode=off - q1 4508437344754373 q2 328 229 234 229 q3 2971288628562856 q4 1884161316281613 q5 5269524552695245 q6 192 113 115 113 q7 2146178417511751 q8 3151324132803241 q9 8351839683948394 q10 5998370237023702 q11 561 478 494 478 q12 765 593 589 589 q13 13302 326235123262 q14 280 257 267 257 q15 543 514 506 506 q16 536 470 499 470 q17 1848173517101710 q18 8650776175257525 q19 10446 153115371531 q20 2139190919131909 q21 4895466645974597 q22 585 492 436 436 Total cold run time: 79348 ms Total hot run time: 54787 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] [DNM](Nereids) test disable fallback [doris]
doris-robot commented on PR #25344: URL: https://github.com/apache/doris/pull/25344#issuecomment-1931530368 TPC-DS: Total hot run time: 181015 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 9a2bb6d5f46ad4e0a8cabf1b6be20e662b9229ea, data reload: false query1 927 334 327 327 query2 6549194119561941 query3 6724209 206 206 query4 31827 21959 21995 21959 query5 4273426 396 396 query6 254 166 159 159 query7 4598292 280 280 query8 253 174 166 166 query9 8928224422142214 query10 416 208 223 208 query11 18729 15405 15380 15380 query12 131 75 77 75 query13 1623425 420 420 query14 9056708165006500 query15 303 176 179 176 query16 8175275 244 244 query17 2050525 504 504 query18 2101263 260 260 query19 368 146 137 137 query20 79 77 76 76 query21 201 129 127 127 query22 5049463549544635 query23 30295 30136 30006 30006 query24 8713276027102710 query25 539 340 336 336 query26 713 146 145 145 query27 2157301 300 300 query28 5493183318121812 query29 858 601 592 592 query30 283 130 143 130 query31 917 703 696 696 query32 94 55 53 53 query33 495 215 219 215 query34 791 457 467 457 query35 832 743 754 743 query36 1007918 880 880 query37 93 54 57 54 query38 3254311431123112 query39 1289126712571257 query40 182 91 91 91 query41 38 35 33 33 query42 103 88 95 88 query43 507 493 476 476 query44 1030673 702 673 query45 195 177 174 174 query46 1046669 636 636 query47 1551148314921483 query48 433 358 368 358 query49 1041288 281 281 query50 759 368 375 368 query51 5324510951685109 query52 97 86 85 85 query53 331 270 260 260 query54 238 207 221 207 query55 76 73 73 73 query56 218 192 194 192 query57 971 864 898 864 query58 203 182 189 182 query59 2442225624122256 query60 226 217 221 217 query61 84 82 81 81 query62 621 357 346 346 query63 301 268 273 268 query64 4668371233523352 query65 3244320932173209 query66 823 311 299 299 query67 14247 14302 14007 14007 query68 4432541 543 541 query69 476 320 320 320 query70 1269121712311217 query71 346 244 254 244 query72 6083290726992699 query73 707 318 324 318 query74 6614621062416210 query75 3073232623032303 query76 2858913 872 872 query77 375 228 225 225 query78 9206869185568556 query79 2618492 497 492 query80 2076350 341 341 query81 546 196 201 196 query82 840 87 82 82 query83 243 129 123 123 query84 297 77 84 77 query85 2225333 335 333 query86 485 296 293 293 query87 3406320432163204 query88 3693234123772341 query89 423 353 372 353 query90 1940163 160 160 query91 152 120 120 120 query92 59 44 42 42 query93 3318523 464 464 query94 1294173 174 173 query95 8033790279057902 query96 606 278 275 275 query97 4269410341344103 query98 208 198 189 189 query99 1143691 696 691 Total cold run time: 284749 ms Total hot run time: 181015 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 s
Re: [PR] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
doris-robot commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931531007 TPC-H: Total hot run time: 37057 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2c6eb24f0f6122ae99f01dc6260a35d5f65855dd, data reload: false -- Round 1 -- q1 17662 452143954395 q2 2042149 136 136 q3 10779 953 958 953 q4 4755702 740 702 q5 7676277328852773 q6 182 120 120 120 q7 1156733 736 733 q8 9526203520632035 q9 7874636463596359 q10 8105243324212421 q11 408 208 204 204 q12 757 277 290 277 q13 18024 332932853285 q14 277 245 258 245 q15 530 500 490 490 q16 478 405 419 405 q17 942 558 509 509 q18 6776602260296022 q19 1578136213101310 q20 646 361 332 332 q21 6539305431633054 q22 803 297 304 297 Total cold run time: 107515 ms Total hot run time: 37057 ms - Round 2, with runtime_filter_mode=off - q1 4381443144644431 q2 327 231 230 230 q3 2961286628192819 q4 1824165216051605 q5 5176519952555199 q6 190 112 115 112 q7 2146183117661766 q8 3118322232503222 q9 8308834582868286 q10 5813354335843543 q11 549 461 488 461 q12 762 543 571 543 q13 8442309730613061 q14 271 250 263 250 q15 533 487 489 487 q16 514 455 473 455 q17 1836169016711671 q18 7911773076067606 q19 6949151915151515 q20 2126190819161908 q21 4701453045834530 q22 534 499 458 458 Total cold run time: 69372 ms Total hot run time: 54158 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
[PR] [nereids] refine group by elimination column prune [doris]
xzj7019 opened a new pull request, #30953: URL: https://github.com/apache/doris/pull/30953 ## 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] [nereids] refine group by elimination column prune [doris]
doris-robot commented on PR #30953: URL: https://github.com/apache/doris/pull/30953#issuecomment-1931532873 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](move-memtable) remove phmap and use shared ptr in delta writer v2 [doris]
github-actions[bot] commented on PR #30949: URL: https://github.com/apache/doris/pull/30949#issuecomment-1931533949 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] [refactor](move-memtable) remove phmap and use shared ptr in delta writer v2 [doris]
github-actions[bot] commented on PR #30949: URL: https://github.com/apache/doris/pull/30949#issuecomment-1931534015 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] [nereids] refine group by elimination column prune [doris]
xzj7019 commented on PR #30953: URL: https://github.com/apache/doris/pull/30953#issuecomment-1931534123 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] [DNM](Nereids) test disable fallback [doris]
doris-robot commented on PR #25344: URL: https://github.com/apache/doris/pull/25344#issuecomment-1931538720 ClickBench: Total hot run time: 30.07 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 9a2bb6d5f46ad4e0a8cabf1b6be20e662b9229ea, data reload: false query1 0.050.030.03 query2 0.060.030.02 query3 0.240.070.07 query4 1.660.110.12 query5 0.560.520.53 query6 1.200.640.63 query7 0.020.010.01 query8 0.040.030.03 query9 0.550.510.51 query10 0.580.580.55 query11 0.120.080.08 query12 0.110.090.09 query13 0.610.610.60 query14 0.770.810.78 query15 0.810.780.77 query16 0.380.370.39 query17 0.981.020.95 query18 0.240.270.23 query19 1.891.801.79 query20 0.020.010.01 query21 15.43 0.570.59 query22 2.502.371.79 query23 17.48 0.850.70 query24 2.341.320.12 query25 0.260.130.17 query26 0.470.150.14 query27 0.050.050.06 query28 12.18 0.850.85 query29 12.58 3.183.23 query30 0.590.540.52 query31 2.790.360.35 query32 3.350.480.48 query33 3.183.173.18 query34 15.96 4.364.25 query35 4.314.324.31 query36 1.091.051.05 query37 0.060.050.05 query38 0.040.030.03 query39 0.020.010.01 query40 0.150.130.14 query41 0.070.010.02 query42 0.020.010.02 query43 0.030.020.02 Total cold run time: 105.84 s Total hot run time: 30.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] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
doris-robot commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931542180 TeamCity be ut coverage result: Function Coverage: 36.17% (8638/23883) Line Coverage: 28.19% (70628/250502) Region Coverage: 27.18% (36440/134063) Branch Coverage: 23.96% (18660/77868) Coverage Report: http://coverage.selectdb-in.cc/coverage/2c6eb24f0f6122ae99f01dc6260a35d5f65855dd_2c6eb24f0f6122ae99f01dc6260a35d5f65855dd/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] [DNM](Nereids) test disable fallback [doris]
doris-robot commented on PR #25344: URL: https://github.com/apache/doris/pull/25344#issuecomment-1931543815 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 9a2bb6d5f46ad4e0a8cabf1b6be20e662b9229ea with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.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
(doris) branch master updated: [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948)
This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new d9c018e901a [fix](Nereids) should distribute first when do sort
enforce on must shuffle (#30948)
d9c018e901a is described below
commit d9c018e901abd9ac5f5892a53546e58e4cecca16
Author: morrySnow <101034200+morrys...@users.noreply.github.com>
AuthorDate: Wed Feb 7 16:44:51 2024 +0800
[fix](Nereids) should distribute first when do sort enforce on must shuffle
(#30948)
---
.../properties/EnforceMissingPropertiesHelper.java | 8 +++--
.../cte/test_cte_reuse_with_window.groovy | 39 ++
2 files changed, 45 insertions(+), 2 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/properties/EnforceMissingPropertiesHelper.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/properties/EnforceMissingPropertiesHelper.java
index 31d99765beb..b08db2aeba2 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/nereids/properties/EnforceMissingPropertiesHelper.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/nereids/properties/EnforceMissingPropertiesHelper.java
@@ -130,9 +130,13 @@ public class EnforceMissingPropertiesHelper {
private PhysicalProperties enforceSortAndDistribution(PhysicalProperties
outputProperty,
PhysicalProperties requiredProperty) {
-PhysicalProperties enforcedProperty;
+PhysicalProperties enforcedProperty = outputProperty;
if (requiredProperty.getDistributionSpec().equals(new
DistributionSpecGather())) {
-enforcedProperty = enforceLocalSort(outputProperty,
requiredProperty);
+// NOTICE: if output is must shuffle, we must do distribution
first. so add a random shuffle here.
+if (outputProperty.getDistributionSpec() instanceof
DistributionSpecMustShuffle) {
+enforcedProperty = enforceDistribution(enforcedProperty,
PhysicalProperties.EXECUTION_ANY);
+}
+enforcedProperty = enforceLocalSort(enforcedProperty,
requiredProperty);
enforcedProperty = enforceDistribution(enforcedProperty,
requiredProperty);
enforcedProperty = enforceGlobalSort(enforcedProperty,
requiredProperty);
} else {
diff --git
a/regression-test/suites/nereids_p0/cte/test_cte_reuse_with_window.groovy
b/regression-test/suites/nereids_p0/cte/test_cte_reuse_with_window.groovy
new file mode 100644
index 000..431aeda7540
--- /dev/null
+++ b/regression-test/suites/nereids_p0/cte/test_cte_reuse_with_window.groovy
@@ -0,0 +1,39 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_cte_reuse_with_window") {
+sql "SET enable_nereids_planner=true"
+sql "SET enable_pipeline_engine=true"
+sql "SET enable_fallback_to_original_planner=false"
+
+sql """
+drop table if exists test_cte_reuse_with_window;
+"""
+
+sql """
+create table test_cte_reuse_with_window (id int default '10', c1 int
default '10') distributed by hash(id) properties('replication_num'="1");
+"""
+
+sql """
+with temp as (select * from test_cte_reuse_with_window)
+select * from
+(select t.id, row_number() over(order by t.id) as num from temp t
limit 20) a
+left join
+(select t.id, row_number() over(order by t.id desc) as num
from temp t where t.id = 5) b
+on a.id = b.id
+"""
+}
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](Nereids) should distribute first when do sort enforce on must shuffle [doris]
morrySnow merged PR #30948: URL: https://github.com/apache/doris/pull/30948 -- 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](join) optimization for build_side_output_column [doris]
doris-robot commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931544144 TPC-DS: Total hot run time: 171029 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 eebe1eaebae9b691485a9c965dae381e5c070eb3, data reload: false query1 921 336 332 332 query2 6567184219241842 query3 6706207 205 205 query4 30539 20553 20592 20553 query5 4304368 402 368 query6 254 169 168 168 query7 4602293 290 290 query8 233 180 174 174 query9 2253 query10 405 216 216 216 query11 17247 14287 14113 14113 query12 124 75 73 73 query13 1626417 418 417 query14 9241691367946794 query15 240 172 181 172 query16 8146256 254 254 query17 1947540 491 491 query18 2100267 258 258 query19 361 141 140 140 query20 83 79 78 78 query21 196 122 123 122 query22 4951489747364736 query23 30864 30024 30006 30006 query24 10516 276528042765 query25 596 351 348 348 query26 1648143 143 143 query27 2405310 304 304 query28 7039187318741873 query29 880 629 610 610 query30 278 133 147 133 query31 923 713 722 713 query32 89 60 49 49 query33 736 215 219 215 query34 1102462 462 462 query35 861 764 746 746 query36 1029839 894 839 query37 121 57 54 54 query38 3117299329782978 query39 1319124712501247 query40 186 95 91 91 query41 37 40 34 34 query42 94 84 85 84 query43 487 477 502 477 query44 1156666 707 666 query45 191 175 175 175 query46 1048658 637 637 query47 1587149614851485 query48 440 345 336 336 query49 1088294 281 281 query50 767 386 366 366 query51 5251517551365136 query52 95 80 85 80 query53 340 263 264 263 query54 288 216 224 216 query55 79 76 74 74 query56 211 199 190 190 query57 962 907 851 851 query58 202 176 179 176 query59 2329244322612261 query60 239 214 211 211 query61 90 84 82 82 query62 613 374 338 338 query63 299 257 271 257 query64 5211371034713471 query65 3247322332073207 query66 822 310 310 310 query67 14479 14120 14242 14120 query68 4958539 532 532 query69 480 317 306 306 query70 1216123311951195 query71 323 241 243 241 query72 6039279826392639 query73 710 324 323 323 query74 6491608561076085 query75 3041234823262326 query76 3283938 934 934 query77 352 228 221 221 query78 9131876685288528 query79 2325486 490 486 query80 1333342 344 342 query81 532 194 201 194 query82 743 77 81 77 query83 237 126 120 120 query84 230 80 85 80 query85 1993347 323 323 query86 479 313 300 300 query87 3287311631023102 query88 3824240023672367 query89 444 352 356 352 query90 1974163 166 163 query91 154 121 141 121 query92 49 44 41 41 query93 2265507 490 490 query94 1269170 172 170 query95 79527740366 366 query96 583 277 276 276 query97 4216411540994099 query98 230 197 190 190 query99 1046729 662 662 Total cold run time: 286231 ms Total hot run time: 171029 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 sp
Re: [PR] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
doris-robot commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931548885 TPC-DS: Total hot run time: 174290 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 2c6eb24f0f6122ae99f01dc6260a35d5f65855dd, data reload: false query1 915 347 335 335 query2 6525193819221922 query3 6738209 204 204 query4 31914 22049 22035 22035 query5 4262354 422 354 query6 256 166 165 165 query7 4608286 283 283 query8 244 187 171 171 query9 8736224122252225 query10 414 206 207 206 query11 18587 15411 15324 15324 query12 132 77 73 73 query13 1614410 411 410 query14 9322716769816981 query15 312 176 189 176 query16 8146263 266 263 query17 2072537 495 495 query18 2126262 259 259 query19 346 139 141 139 query20 79 81 77 77 query21 204 121 125 121 query22 4773467346204620 query23 31573 30080 30067 30067 query24 10527 275827752758 query25 573 353 339 339 query26 1424144 148 144 query27 2933305 315 305 query28 7514182218061806 query29 903 627 601 601 query30 283 130 140 130 query31 901 708 723 708 query32 90 58 53 53 query33 736 229 218 218 query34 1094449 460 449 query35 859 754 761 754 query36 1027957 912 912 query37 121 55 58 55 query38 3214314630973097 query39 1290126112581258 query40 266 95 91 91 query41 37 36 34 34 query42 97 88 84 84 query43 523 490 489 489 query44 1087669 705 669 query45 193 185 179 179 query46 1038662 653 653 query47 1559151314771477 query48 418 373 362 362 query49 1198288 278 278 query50 759 383 381 381 query51 5241511451595114 query52 106 77 84 77 query53 327 266 273 266 query54 278 207 222 207 query55 77 76 72 72 query56 220 198 196 196 query57 952 910 913 910 query58 206 180 177 177 query59 2469237123452345 query60 249 218 209 209 query61 85 87 81 81 query62 674 368 361 361 query63 297 270 264 264 query64 5972354137173541 query65 3271322832223222 query66 1058308 313 308 query67 14574 13784 14243 13784 query68 4068557 541 541 query69 454 321 339 321 query70 1251123712151215 query71 326 238 247 238 query72 6034286726562656 query73 700 335 315 315 query74 6581625562666255 query75 2993238523202320 query76 2525958 932 932 query77 325 226 221 221 query78 9227873185418541 query79 3041494 482 482 query80 2056348 341 341 query81 520 195 193 193 query82 844 83 77 77 query83 245 129 123 123 query84 283 75 85 75 query85 2239344 326 326 query86 478 312 317 312 query87 3412325531743174 query88 3982237923612361 query89 441 366 360 360 query90 2030161 163 161 query91 150 120 120 120 query92 56 41 46 41 query93 3207487 472 472 query94 1293170 172 170 query95 455 355 354 354 query96 596 281 280 280 query97 4271411241144112 query98 220 206 193 193 query99 685 694 685 Total cold run time: 286032 ms Total hot run time: 174290 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 sp
Re: [PR] [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948) [doris]
morrySnow commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931551211 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) should distribute first when do sort enforce on must shuffle (#30948) [doris]
morrySnow opened a new pull request, #30954: URL: https://github.com/apache/doris/pull/30954 pick from master #30948 commit id d9c018e901 ## 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) should distribute first when do sort enforce on must shuffle (#30948) [doris]
doris-robot commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931551163 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](join) optimization for build_side_output_column [doris]
doris-robot commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931552833 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 eebe1eaebae9b691485a9c965dae381e5c070eb3, data reload: false query1 0.040.030.03 query2 0.060.020.03 query3 0.220.060.06 query4 1.660.100.10 query5 0.540.510.52 query6 1.220.680.62 query7 0.020.020.01 query8 0.040.020.02 query9 0.560.490.49 query10 0.550.550.55 query11 0.110.090.09 query12 0.110.080.09 query13 0.610.600.61 query14 0.780.810.80 query15 0.790.780.78 query16 0.380.380.39 query17 1.031.031.01 query18 0.210.280.22 query19 1.841.771.81 query20 0.010.010.01 query21 15.40 0.560.56 query22 2.442.132.42 query23 17.33 0.790.84 query24 2.691.120.97 query25 0.350.140.04 query26 0.490.150.14 query27 0.070.050.06 query28 11.23 0.840.83 query29 12.50 3.073.16 query30 0.670.550.51 query31 2.790.350.35 query32 3.340.480.47 query33 3.243.233.26 query34 15.86 4.354.26 query35 4.274.274.33 query36 1.111.061.08 query37 0.070.050.05 query38 0.050.030.03 query39 0.030.010.01 query40 0.160.130.13 query41 0.060.020.01 query42 0.020.010.02 query43 0.030.020.02 Total cold run time: 104.98 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] [opt](Nereids) support slot appears in both agg funcs and grouping sets [doris]
morrySnow closed pull request #30335: [opt](Nereids) support slot appears in both agg funcs and grouping sets URL: https://github.com/apache/doris/pull/30335 -- 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] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
doris-robot commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931557611 ClickBench: Total hot run time: 31.26 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2c6eb24f0f6122ae99f01dc6260a35d5f65855dd, data reload: false query1 0.040.030.03 query2 0.060.030.02 query3 0.220.070.06 query4 1.670.100.10 query5 0.530.510.53 query6 1.290.620.65 query7 0.020.010.02 query8 0.040.030.03 query9 0.550.490.51 query10 0.560.550.58 query11 0.120.080.09 query12 0.100.090.09 query13 0.620.610.62 query14 0.790.800.80 query15 0.800.780.79 query16 0.400.380.38 query17 1.031.011.03 query18 0.240.200.28 query19 1.881.781.78 query20 0.010.010.01 query21 15.48 0.580.56 query22 2.382.822.20 query23 17.44 0.800.93 query24 2.471.610.90 query25 0.400.240.07 query26 0.420.140.14 query27 0.040.050.06 query28 10.89 0.880.82 query29 12.59 3.163.20 query30 0.600.550.56 query31 2.800.340.36 query32 3.350.480.48 query33 3.233.243.26 query34 15.84 4.264.21 query35 4.274.274.29 query36 1.081.041.07 query37 0.060.050.05 query38 0.040.030.03 query39 0.020.010.02 query40 0.170.130.13 query41 0.070.020.02 query42 0.030.020.01 query43 0.020.020.02 Total cold run time: 104.66 s Total hot run time: 31.26 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: 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](join) optimization for build_side_output_column [doris]
doris-robot commented on PR #30826: URL: https://github.com/apache/doris/pull/30826#issuecomment-1931557765 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit eebe1eaebae9b691485a9c965dae381e5c070eb3 with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 13.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
[PR] [tool]add scripts to show user info quick [doris]
zhangweiwhim opened a new pull request, #30955: URL: https://github.com/apache/doris/pull/30955 Summary: As the title, add some scripts to show the user info, which may reduce the steps of querying user information. Checklist(Required) Does it affect the original behavior: (No) Has unit tests been added: (No Need) Has document been added or modified: (Yes) Does it need to update dependencies: (No) Are there any changes that cannot be rolled back: (No) -- 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] [tool]add scripts to show user info quick [doris]
doris-robot commented on PR #30955: URL: https://github.com/apache/doris/pull/30955#issuecomment-1931562907 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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] [Enhencement](Outfile/Export) Export data to csv file format with BOM [doris]
doris-robot commented on PR #30533: URL: https://github.com/apache/doris/pull/30533#issuecomment-1931562614 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit 2c6eb24f0f6122ae99f01dc6260a35d5f65855dd with default session variables Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s Insert into select: 14.6 seconds inserted 1000 Rows, about 684K 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](gc) fix a core introduced by #30854 [doris]
zhannngchen commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931565626 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] [fix](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
doris-robot commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931568576 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
hust-hhb opened a new pull request, #30956: URL: https://github.com/apache/doris/pull/30956 ## Proposed changes Now i found fe need to wait old wal to be deleted before creating MaterializedView, this is like schema change.However, schema change has shadow column, so it can do double writing，fe just need to wait on the final stage, i.e. waiting on before renaming shadow column to visible column.MaterializedView dosen't have shadow column, so it need to wait on the whole stage. 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](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
hust-hhb commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931568953 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] [opt](ES catalog) Add 3 connect attempts per node [doris]
qidaye opened a new pull request, #30957: URL: https://github.com/apache/doris/pull/30957 ## Proposed changes ## 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] [opt](ES catalog) Add 3 connect attempts per node [doris]
qidaye commented on PR #30957: URL: https://github.com/apache/doris/pull/30957#issuecomment-1931571140 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](ES catalog) Add 3 connect attempts per node [doris]
doris-robot commented on PR #30957: URL: https://github.com/apache/doris/pull/30957#issuecomment-1931570927 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](gc) fix a core introduced by #30854 [doris]
github-actions[bot] commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931572805 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] [nereids] refine group by elimination column prune [doris]
doris-robot commented on PR #30953: URL: https://github.com/apache/doris/pull/30953#issuecomment-1931574032 TPC-H: Total hot run time: 37509 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit fdffd7158785e4b71881055095f70114638be326, data reload: false -- Round 1 -- q1 17750 477546114611 q2 2947156 143 143 q3 11589 946 963 946 q4 5607737 757 737 q5 7947286829752868 q6 183 123 120 120 q7 1176765 758 758 q8 9530206820352035 q9 7298636563166316 q10 8140246424422442 q11 425 213 205 205 q12 771 281 267 267 q13 18019 329733043297 q14 274 255 249 249 q15 543 497 500 497 q16 463 400 405 400 q17 940 527 535 527 q18 6818602159815981 q19 1565138814261388 q20 590 348 334 334 q21 7111308930993089 q22 808 314 299 299 Total cold run time: 110494 ms Total hot run time: 37509 ms - Round 2, with runtime_filter_mode=off - q1 4921449943984398 q2 334 237 235 235 q3 2950290528942894 q4 1866167117131671 q5 5184523452155215 q6 194 113 113 113 q7 2138177017581758 q8 3055325032333233 q9 8383831883448318 q10 5732355335463546 q11 528 470 477 470 q12 752 593 572 572 q13 6305315831033103 q14 274 269 257 257 q15 540 487 486 486 q16 520 482 465 465 q17 1844167616681668 q18 7926763276407632 q19 9953151615171516 q20 2136189918931893 q21 4822449945454499 q22 585 478 486 478 Total cold run time: 70942 ms Total hot run time: 54420 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] [fix](nereids)should not infer predicate for nullaware anti-join [doris]
morrySnow commented on PR #30924: URL: https://github.com/apache/doris/pull/30924#issuecomment-1931575439 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] [fix](nereids)should not infer predicate for nullaware anti-join [doris]
github-actions[bot] commented on PR #30924: URL: https://github.com/apache/doris/pull/30924#issuecomment-1931577362 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
[PR] [branch-2.0](cherry-pick) process exception while iteratoring directory (#30850) [doris]
zhannngchen opened a new pull request, #30958: URL: https://github.com/apache/doris/pull/30958 ## Proposed changes Issue Number: close #xxx cherry-pick #30850 ## 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] [branch-2.0](cherry-pick) process exception while iteratoring directory (#30850) [doris]
doris-robot commented on PR #30958: URL: https://github.com/apache/doris/pull/30958#issuecomment-1931576364 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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)should not infer predicate for nullaware anti-join [doris]
github-actions[bot] commented on PR #30924: URL: https://github.com/apache/doris/pull/30924#issuecomment-1931577429 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] [fix](gc) fix a core introduced by #30854 [doris]
github-actions[bot] commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931584002 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] [branch-2.0](cherry-pick) process exception while iteratoring directory (#30850) [doris]
zhannngchen commented on PR #30958: URL: https://github.com/apache/doris/pull/30958#issuecomment-1931585156 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] [fix](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
github-actions[bot] commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931589672 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] [fix](nereids)aggregate function cannot contain aggregate parameters [doris]
morrySnow commented on PR #30928: URL: https://github.com/apache/doris/pull/30928#issuecomment-1931593870 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] [fix](nereids)aggregate function cannot contain aggregate parameters [doris]
github-actions[bot] commented on PR #30928: URL: https://github.com/apache/doris/pull/30928#issuecomment-1931594537 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] [fix](nereids)aggregate function cannot contain aggregate parameters [doris]
github-actions[bot] commented on PR #30928: URL: https://github.com/apache/doris/pull/30928#issuecomment-1931594486 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] [branch-2.0](cherry-pick) process exception while iteratoring directory (#30850) [doris]
github-actions[bot] commented on PR #30958: URL: https://github.com/apache/doris/pull/30958#issuecomment-1931593559 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] [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948) [doris]
doris-robot commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931594771 TPC-H: Total hot run time: 49737 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit e8d2e358ef8a9a03737951fb15bea19af40c944f, data reload: false -- Round 1 -- q1 17971 437443574357 q2 2022153 154 153 q3 10432 187518731873 q4 10346 123112991231 q5 8387393639803936 q6 228 124 125 124 q7 2037158616081586 q8 9282268527032685 q9 10733 10458 10330 10330 q10 8650355135113511 q11 430 253 241 241 q12 470 299 303 299 q13 18354 395839753958 q14 359 323 323 323 q15 500 461 464 461 q16 693 597 599 597 q17 11151008969 969 q18 7356676669016766 q19 1665156014911491 q20 503 313 311 311 q21 4466413441444134 q22 510 401 401 401 Total cold run time: 116509 ms Total hot run time: 49737 ms - Round 2, with runtime_filter_mode=off - q1 4301427442734273 q2 318 220 268 220 q3 4140415041064106 q4 2759274327702743 q5 7288718071987180 q6 231 119 117 117 q7 3200279329012793 q8 4328448044864480 q9 17090 16868 16900 16868 q10 4264423142184218 q11 757 685 680 680 q12 1025849 862 849 q13 7089375137463746 q14 438 425 421 421 q15 491 448 447 447 q16 765 718 694 694 q17 3845382038193819 q18 8809885888638858 q19 1698169916611661 q20 2413215421452145 q21 8513851484588458 q22 989 977 945 945 Total cold run time: 84751 ms Total hot run time: 79721 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] [case](mtmv)MTMV hive case [doris]
github-actions[bot] commented on PR #30930: URL: https://github.com/apache/doris/pull/30930#issuecomment-1931600503 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
[PR] [improvement](group_commit) Rename fail wal to tmp should only use in test P0 scenario [doris]
hust-hhb opened a new pull request, #30959: URL: https://github.com/apache/doris/pull/30959 ## Proposed changes Rename fail wal to tmp should only use in test P0 scenario 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] [improvement](group_commit) Rename fail wal to tmp should only use in test P0 scenario [doris]
doris-robot commented on PR #30959: URL: https://github.com/apache/doris/pull/30959#issuecomment-1931606453 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](group_commit) Rename fail wal to tmp should only use in test P0 scenario [doris]
hust-hhb commented on PR #30959: URL: https://github.com/apache/doris/pull/30959#issuecomment-1931606634 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] [case](mtmv)MTMV hive case [doris]
morrySnow merged PR #30930: URL: https://github.com/apache/doris/pull/30930 -- 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 (d9c018e901a -> 4c4050b4a8c)
This is an automated email from the ASF dual-hosted git repository. morrysnow pushed a change to branch master in repository https://gitbox.apache.org/repos/asf/doris.git from d9c018e901a [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948) add 4c4050b4a8c [case](mtmv) MTMV hive case (#30930) No new revisions were added by this update. Summary of changes: .../org/apache/doris/mtmv/MTMVPartitionUtil.java | 4 +- .../data/mtmv_p0/test_hive_olap_mtmv.out | 17 ++ .../data/mtmv_p0/test_hive_refresh_mtmv.out| 17 ++ .../suites/mtmv_p0/test_hive_mtmv.groovy | 2 +- .../suites/mtmv_p0/test_hive_olap_mtmv.groovy | 90 +++ .../suites/mtmv_p0/test_hive_refresh_mtmv.groovy | 180 + 6 files changed, 307 insertions(+), 3 deletions(-) create mode 100644 regression-test/data/mtmv_p0/test_hive_olap_mtmv.out create mode 100644 regression-test/data/mtmv_p0/test_hive_refresh_mtmv.out create mode 100644 regression-test/suites/mtmv_p0/test_hive_olap_mtmv.groovy create mode 100644 regression-test/suites/mtmv_p0/test_hive_refresh_mtmv.groovy - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [fix](gc) fix a core introduced by #30854 [doris]
doris-robot commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931612170 TeamCity be ut coverage result: Function Coverage: 36.17% (8638/23882) Line Coverage: 28.20% (70628/250475) Region Coverage: 27.18% (36439/134042) Branch Coverage: 23.98% (18665/77850) Coverage Report: http://coverage.selectdb-in.cc/coverage/f3f90e95e930fa26850fdebccfcbac59c653303c_f3f90e95e930fa26850fdebccfcbac59c653303c/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](Nereids) should distribute first when do sort enforce on must shuffle (#30948) [doris]
doris-robot commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931622192 TPC-DS: Total hot run time: 236386 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 e8d2e358ef8a9a03737951fb15bea19af40c944f, data reload: false query1 932 389 382 382 query2 6535217520772077 query3 6919197 200 197 query4 21067 18019 17937 17937 query5 19738 649865296498 query6 285 218 230 218 query7 4162296 298 296 query8 279 243 242 242 query9 3127269026292629 query10 429 291 295 291 query11 11291 10644 10727 10644 query12 124 77 72 72 query13 5584665 639 639 query14 17983 13178 13168 13168 query15 373 242 232 232 query16 6420264 263 263 query17 17181458854 854 query18 2336395 404 395 query19 205 139 149 139 query20 77 79 74 74 query21 187 93 95 93 query22 5240514250855085 query23 32302 31879 31852 31852 query24 6902648464926484 query25 523 406 400 400 query26 519 163 155 155 query27 1829290 292 290 query28 6114222621882188 query29 2877272327312723 query30 244 162 164 162 query31 892 774 734 734 query32 63 61 55 55 query33 395 251 245 245 query34 852 459 479 459 query35 1102905 914 905 query36 1508128816341288 query37 87 60 64 60 query38 3073294628992899 query39 1354130013201300 query40 200 96 98 96 query41 35 32 36 32 query42 83 87 81 81 query43 557 593 595 593 query44 1126719 733 719 query45 243 225 224 224 query46 1230960 956 956 query47 1717170618361706 query48 978 688 678 678 query49 610 373 360 360 query50 883 624 594 594 query51 5471544153915391 query52 95 89 72 72 query53 454 312 319 312 query54 2663245524372437 query55 86 75 83 75 query56 222 210 205 205 query57 1169110211331102 query58 204 201 201 201 query59 3419323435173234 query60 201 177 196 177 query61 83 82 81 81 query62 801 478 460 460 query63 479 337 344 337 query64 2469148313331333 query65 3636356035393539 query66 755 356 350 350 query67 17728 15404 15425 15404 query68 8186655 654 654 query69 556 334 347 334 query70 1803183417171717 query71 397 306 311 306 query72 6422340133753375 query73 732 321 318 318 query74 6325584458305830 query75 4583368036673667 query76 4697112811921128 query77 597 238 245 238 query78 31366 50229 45888 45888 query79 16099 649 647 647 query80 5266384 375 375 query81 562 228 227 227 query82 117999 98 98 query83 408 134 135 134 query84 260 67 68 67 query85 2656273 274 273 query86 486 377 375 375 query87 3238297129972971 query88 6799227122802271 query89 461 288 277 277 query90 2499198 210 198 query91 173 121 112 112 query92 60 49 50 49 query93 6606581 602 581 query94 1846205 204 204 query95 1101104710321032 query96 642 326 317 317 query97 6513634862916291 query98 182 176 169 169 query99 3942928 890 890 Total cold run time: 349886 ms Total hot run time: 236386 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go t
Re: [PR] [test](neredis) Add tpch test for query rewrite by materialized view [doris]
morrySnow commented on code in PR #30870:
URL: https://github.com/apache/doris/pull/30870#discussion_r1481165869
##
fe/fe-core/src/main/java/org/apache/doris/mtmv/MTMVCache.java:
##
@@ -68,13 +77,28 @@ public static MTMVCache from(MTMV mtmv, ConnectContext
connectContext) {
}
Plan mvRewrittenPlan =
planner.plan(unboundMvPlan, PhysicalProperties.ANY,
ExplainLevel.REWRITTEN_PLAN);
-Plan mvPlan = mvRewrittenPlan instanceof LogicalResultSink
-? (Plan) ((LogicalResultSink) mvRewrittenPlan).child() :
mvRewrittenPlan;
+// remove top sort and result sink node above materialized view plan
+if (mvRewrittenPlan instanceof LogicalResultSink) {
+// replace result sink to table sink for sort eliminate
+mvRewrittenPlan = new LogicalOlapTableSink<>(new Database(), mtmv,
mtmv.getBaseSchema(),
+mtmv.getPartitionIds(),
+
mvRewrittenPlan.getOutput().stream().map(NamedExpression.class::cast).collect(Collectors.toList()),
+mtmv.isPartitionedTable(), DMLCommandType.NONE,
mvRewrittenPlan.child(0));
+// eliminate sort under sink because sort is useless for
materialized view
+planner.getCascadesContext().setRewritePlan(mvRewrittenPlan);
+Rewriter rewriter =
Rewriter.getCteChildrenRewriter(planner.getCascadesContext(),
+Lists.newArrayList(AbstractBatchJobExecutor.topDown(new
EliminateSortUnderSink(;
+rewriter.execute();
+}
+if (planner.getCascadesContext().getRewritePlan() instanceof Sink) {
+// remove the sink
+mvRewrittenPlan =
planner.getCascadesContext().getRewritePlan().child(0);
+}
Review Comment:
should notice, result sink is not always the top plan node after plan. so u
should replace result sink with table sink before plan. and then when u do
plan, the top sort node will be removed
--
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](group_commit) Rename fail wal to tmp should only use in test P0 scenario [doris]
github-actions[bot] commented on code in PR #30959:
URL: https://github.com/apache/doris/pull/30959#discussion_r1481168388
##
be/src/olap/wal/wal_info.cpp:
##
@@ -32,7 +32,7 @@ std::string WalInfo::get_wal_path() {
return _wal_path;
}
-int64_t WalInfo::get_retry_num() {
+int32_t WalInfo::get_retry_num() {
Review Comment:
warning: method 'get_retry_num' can be made const
[readability-make-member-function-const]
```suggestion
int32_t WalInfo::get_retry_num() const {
```
be/src/olap/wal/wal_info.h:25:
```diff
- int32_t get_retry_num();
+ int32_t get_retry_num() const;
```
--
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](gc) fix a core introduced by #30854 [doris]
doris-robot commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931630052 TPC-H: Total hot run time: 36496 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f3f90e95e930fa26850fdebccfcbac59c653303c, data reload: false -- Round 1 -- q1 17693 440144494401 q2 2042139 130 130 q3 10618 933 916 916 q4 4643724 768 724 q5 7686277527182718 q6 183 121 118 118 q7 1165724 708 708 q8 9309194219761942 q9 7219634363836343 q10 8101243424632434 q11 419 210 214 210 q12 745 272 251 251 q13 18000 328032813280 q14 276 242 245 242 q15 521 506 487 487 q16 452 406 407 406 q17 923 576 511 511 q18 6756587158715871 q19 1562146013091309 q20 618 321 332 321 q21 6647290130142901 q22 806 296 273 273 Total cold run time: 106384 ms Total hot run time: 36496 ms - Round 2, with runtime_filter_mode=off - q1 4383442043284328 q2 321 232 233 232 q3 2967284927852785 q4 1826158315661566 q5 5123522551745174 q6 189 113 115 113 q7 2117172217281722 q8 3047318332433183 q9 8294820882438208 q10 5719352735563527 q11 538 455 472 455 q12 725 568 567 567 q13 13403 311030163016 q14 268 265 264 264 q15 529 487 496 487 q16 507 485 485 485 q17 1814166616401640 q18 8009754275167516 q19 10506 152015031503 q20 2133190018811881 q21 4860450844404440 q22 543 455 422 422 Total cold run time: 77821 ms Total hot run time: 53514 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](window-func) support percent_rank window function [doris]
github-actions[bot] commented on PR #30926: URL: https://github.com/apache/doris/pull/30926#issuecomment-1931633360 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] [fix](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
hust-hhb commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931635523 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](window-func) support percent_rank window function [doris]
github-actions[bot] commented on PR #30926: URL: https://github.com/apache/doris/pull/30926#issuecomment-1931633426 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] [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948) [doris]
doris-robot commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931633983 ClickBench: Total hot run time: 30.65 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit e8d2e358ef8a9a03737951fb15bea19af40c944f, data reload: false query1 0.030.020.02 query2 0.060.030.02 query3 0.250.040.04 query4 1.820.070.06 query5 0.530.530.52 query6 1.240.620.67 query7 0.020.020.02 query8 0.030.020.02 query9 0.520.470.48 query10 0.530.520.54 query11 0.110.090.08 query12 0.120.090.09 query13 0.610.610.61 query14 0.780.790.80 query15 0.790.750.79 query16 0.360.390.36 query17 0.991.001.00 query18 0.220.280.25 query19 1.891.881.83 query20 0.010.010.01 query21 15.47 0.580.57 query22 2.042.141.71 query23 17.27 1.050.84 query24 6.794.760.93 query25 1.640.120.11 query26 0.470.140.13 query27 0.100.100.11 query28 4.140.710.74 query29 12.63 2.332.16 query30 0.550.540.54 query31 2.810.370.39 query32 3.430.490.49 query33 3.083.073.10 query34 15.27 4.784.79 query35 4.834.804.86 query36 1.071.011.02 query37 0.050.050.04 query38 0.040.020.02 query39 0.020.020.02 query40 0.150.130.14 query41 0.060.020.02 query42 0.010.010.01 query43 0.020.020.01 Total cold run time: 102.85 s Total hot run time: 30.65 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](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
doris-robot commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931635220 TeamCity be ut coverage result: Function Coverage: 36.17% (8637/23882) Line Coverage: 28.19% (70604/250475) Region Coverage: 27.17% (36419/134042) Branch Coverage: 23.96% (18656/77850) Coverage Report: http://coverage.selectdb-in.cc/coverage/56e735345a7a2f027868b60fa5efd346be3ad5e3_56e735345a7a2f027868b60fa5efd346be3ad5e3/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](nereids)should not infer predicate for nullaware anti-join [doris]
doris-robot commented on PR #30924: URL: https://github.com/apache/doris/pull/30924#issuecomment-1931638622 TPC-H: Total hot run time: 37048 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 8ca59c3e1721fee9d9e34ee3ac5159ff49c20d88, data reload: false -- Round 1 -- q1 17668 496644644464 q2 2047143 134 134 q3 10663 955 904 904 q4 4653724 695 695 q5 7699279027312731 q6 184 120 120 120 q7 1146736 715 715 q8 9310196019781960 q9 7238631863176317 q10 8097242024332420 q11 406 218 214 214 q12 787 261 288 261 q13 18266 334632943294 q14 270 256 252 252 q15 526 499 496 496 q16 486 410 414 410 q17 923 510 493 493 q18 6801596960645969 q19 1569148013731373 q20 604 343 348 343 q21 6822317631693169 q22 797 327 314 314 Total cold run time: 106962 ms Total hot run time: 37048 ms - Round 2, with runtime_filter_mode=off - q1 4537440043774377 q2 322 234 223 223 q3 2983289128432843 q4 1866166516331633 q5 5196525052875250 q6 191 129 115 115 q7 2156180917611761 q8 3110323232523232 q9 8492851785948517 q10 6052372737723727 q11 564 462 475 462 q12 746 605 622 605 q13 19247 316931203120 q14 273 257 266 257 q15 546 499 493 493 q16 532 472 455 455 q17 1831165617091656 q18 8120767875227522 q19 10194 156015471547 q20 2144190119161901 q21 4965452945784529 q22 555 443 448 443 Total cold run time: 84622 ms Total hot run time: 54668 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] [fix](nereids)aggregate function cannot contain aggregate parameters [doris]
doris-robot commented on PR #30928: URL: https://github.com/apache/doris/pull/30928#issuecomment-1931638972 TPC-H: Total hot run time: 36950 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 90e3080e88ce06344056b6622288fdf8e3da3f83, data reload: false -- Round 1 -- q1 17757 547543814381 q2 2040146 135 135 q3 10686 917 907 907 q4 4669731 695 695 q5 7695278727892787 q6 184 121 120 120 q7 1147731 723 723 q8 9308200820292008 q9 7281638663666366 q10 8112243424732434 q11 410 220 208 208 q12 753 285 286 285 q13 18027 329332803280 q14 302 260 245 245 q15 535 489 482 482 q16 480 399 411 399 q17 926 617 484 484 q18 6816595059305930 q19 1556135913701359 q20 594 337 339 337 q21 6925307931043079 q22 813 319 306 306 Total cold run time: 107016 ms Total hot run time: 36950 ms - Round 2, with runtime_filter_mode=off - q1 4485440843074307 q2 328 234 221 221 q3 2977290928332833 q4 1951172916721672 q5 5165522252185218 q6 197 113 115 113 q7 2134178617481748 q8 3114322432183218 q9 8409834282788278 q10 5796362036053605 q11 553 463 467 463 q12 744 569 597 569 q13 9299311931083108 q14 276 262 271 262 q15 531 494 497 494 q16 515 462 474 462 q17 1864168416871684 q18 7917773875487548 q19 10181 156815521552 q20 2131191019301910 q21 5797456145704561 q22 613 489 432 432 Total cold run time: 74977 ms Total hot run time: 54258 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] [fix](Nereids) should distribute first when do sort enforce on must shuffle (#30948) [doris]
doris-robot commented on PR #30954: URL: https://github.com/apache/doris/pull/30954#issuecomment-1931639766 Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G' ``` Load test result on commit e8d2e358ef8a9a03737951fb15bea19af40c944f 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: 21.8 seconds inserted 1000 Rows, about 458K 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](ES catalog) Add 3 connect attempts per node [doris]
doris-robot commented on PR #30957: URL: https://github.com/apache/doris/pull/30957#issuecomment-1931638915 TPC-H: Total hot run time: 36926 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 55f7d0bf25d9a01d00892df074f157ee03eb18a1, data reload: false -- Round 1 -- q1 17684 479644384438 q2 2051140 131 131 q3 10686 929 899 899 q4 4653690 690 690 q5 7691272227812722 q6 183 119 118 118 q7 1126725 716 716 q8 9292196820011968 q9 7235630863556308 q10 8093243224142414 q11 421 199 204 199 q12 773 284 271 271 q13 18346 334633033303 q14 271 244 239 239 q15 531 495 489 489 q16 465 416 396 396 q17 926 545 532 532 q18 6710598359785978 q19 1565147813571357 q20 613 366 357 357 q21 7126307330813073 q22 818 328 329 328 Total cold run time: 107259 ms Total hot run time: 36926 ms - Round 2, with runtime_filter_mode=off - q1 4537450644394439 q2 347 242 234 234 q3 3014283528232823 q4 1859176017071707 q5 5191522852305228 q6 194 114 117 114 q7 2138176517101710 q8 3121322832943228 q9 8549848585258485 q10 5990371837113711 q11 552 468 473 468 q12 757 587 602 587 q13 15653 312931043104 q14 271 263 279 263 q15 534 510 518 510 q16 531 493 497 493 q17 1874166117221661 q18 8117774674457445 q19 9770152615341526 q20 2140191619071907 q21 4928454445734544 q22 546 489 488 488 Total cold run time: 80613 ms Total hot run time: 54675 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] [fix](test) Increase the timeout duration for the test case [doris]
liaoxin01 commented on PR #30952: URL: https://github.com/apache/doris/pull/30952#issuecomment-1931641397 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] [branch-2.0](cherry-pick) process exception while iteratoring directory (#30850) [doris]
zhannngchen commented on PR #30958: URL: https://github.com/apache/doris/pull/30958#issuecomment-1931641560 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](window-func) support percent_rank window function [doris]
morrySnow commented on PR #30926: URL: https://github.com/apache/doris/pull/30926#issuecomment-1931642439 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] [nereids] refine group by elimination column prune [doris]
xzj7019 commented on PR #30953: URL: https://github.com/apache/doris/pull/30953#issuecomment-1931646429 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] [Bug](java-udf) fix core dump when javaudf input 0 row block (#30720) [doris]
BiteThet opened a new pull request, #30960: URL: https://github.com/apache/doris/pull/30960 fix core dump when javaudf input 0 row block ## Proposed changes pick from #30720 ## 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](java-udf) fix core dump when javaudf input 0 row block (#30720) [doris]
doris-robot commented on PR #30960: URL: https://github.com/apache/doris/pull/30960#issuecomment-1931646722 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](java-udf) fix core dump when javaudf input 0 row block (#30720) [doris]
BiteThet commented on PR #30960: URL: https://github.com/apache/doris/pull/30960#issuecomment-1931647130 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] [Bug](compaction) pass arena to function->add_batch_range (#30709) [doris]
BiteThet opened a new pull request, #30961: URL: https://github.com/apache/doris/pull/30961 ## Proposed changes pick from #30709 ## 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](compaction) pass arena to function->add_batch_range (#30709) [doris]
BiteThet commented on PR #30961: URL: https://github.com/apache/doris/pull/30961#issuecomment-1931650449 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](compaction) pass arena to function->add_batch_range (#30709) [doris]
doris-robot commented on PR #30961: URL: https://github.com/apache/doris/pull/30961#issuecomment-1931650382 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-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](gc) fix a core introduced by #30854 [doris]
doris-robot commented on PR #30932: URL: https://github.com/apache/doris/pull/30932#issuecomment-1931650758 TPC-DS: Total hot run time: 174093 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 f3f90e95e930fa26850fdebccfcbac59c653303c, data reload: false query1 932 342 329 329 query2 6540197818891889 query3 6722212 202 202 query4 32239 22159 22188 22159 query5 4285433 358 358 query6 250 163 157 157 query7 4670296 298 296 query8 237 189 202 189 query9 9118229822782278 query10 420 219 237 219 query11 16862 15573 15392 15392 query12 128 74 77 74 query13 1617418 429 418 query14 9104712670057005 query15 291 178 183 178 query16 8138265 253 253 query17 2005549 522 522 query18 2106258 256 256 query19 350 141 141 141 query20 79 74 81 74 query21 194 127 126 126 query22 4970469945884588 query23 30247 29986 29910 29910 query24 9940271627242716 query25 537 339 348 339 query26 709 147 150 147 query27 2155301 304 301 query28 5735184118151815 query29 870 613 608 608 query30 284 132 141 132 query31 932 707 689 689 query32 92 52 49 49 query33 624 223 229 223 query34 841 444 469 444 query35 871 776 727 727 query36 1050961 921 921 query37 89 57 59 57 query38 3236308631163086 query39 1303126512521252 query40 184 93 90 90 query41 38 36 35 35 query42 99 95 91 91 query43 497 483 473 473 query44 1018668 691 668 query45 194 182 172 172 query46 1046652 654 652 query47 1514155014281428 query48 431 383 351 351 query49 1046299 292 292 query50 764 387 368 368 query51 5306520251115111 query52 86 84 84 84 query53 331 273 258 258 query54 277 216 218 216 query55 76 74 72 72 query56 222 195 199 195 query57 1001909 913 909 query58 199 175 171 171 query59 2375220323522203 query60 237 216 221 216 query61 86 92 85 85 query62 646 347 362 347 query63 285 271 277 271 query64 4730369535343534 query65 3233321132033203 query66 812 309 305 305 query67 14451 14131 13989 13989 query68 5480531 550 531 query69 494 351 336 336 query70 1270119712031197 query71 370 242 253 242 query72 6561288426652665 query73 706 322 327 322 query74 6671624562006200 query75 3044233123152315 query76 3546865 917 865 query77 373 231 225 225 query78 9253874385208520 query79 3675491 492 491 query80 1939349 340 340 query81 542 199 195 195 query82 888 79 79 79 query83 297 122 125 122 query84 278 77 82 77 query85 2083345 324 324 query86 475 302 275 275 query87 3397321232023202 query88 4582235623742356 query89 471 342 358 342 query90 1984161 159 159 query91 152 133 121 121 query92 50 42 41 41 query93 5523499 465 465 query94 1256177 175 175 query95 79917797357 357 query96 610 280 273 273 query97 4262409141444091 query98 221 201 190 190 query99 1084706 692 692 Total cold run time: 291484 ms Total hot run time: 174093 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 sp
Re: [PR] [fix](group_commit) Need to wait wal to be deleted when creating MaterializedView [doris]
github-actions[bot] commented on PR #30956: URL: https://github.com/apache/doris/pull/30956#issuecomment-1931650542 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] [feature](test)Add mtmv increment create case [doris]
zfr9527 commented on PR #30751: URL: https://github.com/apache/doris/pull/30751#issuecomment-1931651567 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
