Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
eldenmoon closed pull request #67168: [fix](be) Restore default iterator for schema-missing columns URL: https://github.com/apache/doris/pull/67168 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
hello-stephen commented on PR #67168: URL: https://github.com/apache/doris/pull/67168#issuecomment-5424925817 ClickBench: Total hot run time: 14.54 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 119858972db876d833839094d5747e019b1b17d3, data reload: false query1 0.010.010.00 query2 0.080.030.04 query3 0.240.100.11 query4 1.600.100.10 query5 0.180.160.17 query6 1.250.680.69 query7 0.040.000.01 query8 0.040.030.04 query9 0.300.210.21 query10 0.360.340.33 query11 0.170.120.11 query12 0.160.130.12 query13 0.310.310.31 query14 0.440.440.46 query15 0.350.350.36 query16 0.230.230.22 query17 0.680.680.72 query18 0.170.170.17 query19 1.231.201.07 query20 0.010.010.01 query21 15.45 0.160.13 query22 5.060.040.05 query23 16.20 0.250.10 query24 2.990.310.25 query25 0.100.030.04 query26 0.800.160.13 query27 0.040.030.04 query28 3.600.570.30 query29 12.41 3.182.54 query30 0.250.110.12 query31 2.760.370.17 query32 3.500.320.24 query33 1.481.431.40 query34 15.39 2.191.76 query35 1.741.711.69 query36 0.450.290.28 query37 0.070.040.03 query38 0.050.030.03 query39 0.030.030.02 query40 0.120.080.08 query41 0.080.030.02 query42 0.030.020.02 query43 0.030.020.03 Total cold run time: 90.48 s Total hot run time: 14.54 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
hello-stephen commented on PR #67168: URL: https://github.com/apache/doris/pull/67168#issuecomment-5424881613 TPC-DS: Total hot run time: 82480 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 119858972db876d833839094d5747e019b1b17d3, data reload: false query5 4253404 329 329 query6 389 133 124 124 query7 4963426 240 240 query8 309 127 119 119 query9 8667289728722872 query10 388 211 187 187 query11 53671034904 904 query12 128 71 76 71 query13 1216471 309 309 query14 6156224521342134 query14_11997200220202002 query15 172 132 123 123 query16 919 372 354 354 query17 802 452 363 363 query18 2344335 249 249 query19 166 139 112 112 query20 89 74 70 70 query21 201 103 88 88 query22 5374544253195319 query23 6678605760676057 query23_16067589460625894 query24 73311124780 780 query24_1768 796 796 796 query25 440 311 275 275 query26 1238242 130 130 query27 2777421 262 262 query28 4678149915021499 query29 948 454 356 356 query30 250 161 131 131 query31 827 410 333 333 query32 128 77 81 77 query33 468 222 194 194 query34 988 841 483 483 query35 420 417 347 347 query36 565 569 548 548 query37 123 84 73 73 query38 999 848 811 811 query39 530 468 476 468 query39_1445 482 486 482 query40 238 91 80 80 query41 61 58 58 58 query42 79 77 74 74 query43 242 244 225 225 query44 1015557 563 557 query45 115 110 102 102 query46 808 877 523 523 query47 743 784 696 696 query48 319 311 230 230 query49 532 233 182 182 query50 744 258 190 190 query51 8251819883428198 query52 70 67 59 59 query53 201 218 149 149 query54 229 165 192 165 query55 86 84 59 59 query56 186 166 190 166 query57 666 630 652 630 query58 202 165 183 165 query59 1216121811351135 query60 233 194 188 188 query61 119 131 130 130 query62 365 199 180 180 query63 174 131 153 131 query64 2837761 612 612 query65 1642157816281578 query66 1970275 200 200 query67 9837975596659665 query68 29961257746 746 query69 356 217 191 191 query70 663 635 631 631 query71 256 181 167 167 query72 2388176515431543 query73 643 630 327 327 query74 2014120311431143 query75 1175945 945 query76 2362744 525 525 query77 258 263 214 214 query78 4029367033023302 query79 2306762 599 599 query80 1596331 288 288 query81 482 156 133 133 query82 625 130 98 98 query83 286 206 191 191 query84 300 111 88 88 query85 791 367 294 294 query86 398 184 173 173 query87 1017975 891 891 query88 2787210520882088 query89 291 196 175 175 query90 1961130 129 129 query91 132 119 98 98 query92 79 68 68 68 query93 14231042740 740 query94 663 262 224 224 query95 534 326 232 232 query96 864 599 277 277 query97 1076105110511051 query98 144 135 135 135 query99 420 343 306 306 Total cold run time: 178495 ms Total hot run time: 82480 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
Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
hello-stephen commented on PR #67168: URL: https://github.com/apache/doris/pull/67168#issuecomment-5424813857 TPC-H: Total hot run time: 17056 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 119858972db876d833839094d5747e019b1b17d3, data reload: false -- Round 1 -- q1 17577 305930353035 q2 280 232 232 q3 10090 875 522 522 q4 4674254 201 201 q5 7670577 401 401 q6 141 116 91 91 q7 534 525 391 391 q8 9243907 933 907 q9 3469242223972397 q10 6501867 748 748 q11 399 197 177 177 q12 612 259 199 199 q13 18141 154211641164 q14 158 149 138 138 q15 q16 447 397 369 369 q17 1385882 791 791 q18 3136225422432243 q19 1271918 787 787 q20 376 289 201 201 q21 5609182818451828 q22 336 272 234 234 Total cold run time: 93991 ms Total hot run time: 17056 ms - Round 2, with runtime_filter_mode=off - q1 3484334433593344 q2 507 414 363 363 q3 2211264921872187 q4 11941171901 901 q5 2193211120852085 q6 166 116 86 86 q7 1095975 853 853 q8 1602141714161416 q9 3167312831213121 q10 1890185516351635 q11 365 272 251 251 q12 452 428 350 350 q13 1478154111661166 q14 170 164 163 163 q15 q16 406 403 355 355 q17 3641330932923292 q18 4823443047474430 q19 1021882 907 882 q20 986 999 847 847 q21 3827320832243208 q22 397 361 323 323 Total cold run time: 35075 ms Total hot run time: 31258 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
eldenmoon commented on PR #67168: URL: https://github.com/apache/doris/pull/67168#issuecomment-5423999695 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](be) Restore default iterator for schema-missing columns [doris]
hello-stephen commented on PR #67168: URL: https://github.com/apache/doris/pull/67168#issuecomment-5423932826 Thank you for your contribution to Apache Doris. Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR). Please clearly describe your PR: 1. What problem was fixed (it's best to include specific error reporting information). How it was fixed. 2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be. 3. What features were added. Why was this function added? 4. Which code was refactored and why was this part of the code refactored? 5. Which functions were optimized and what is the difference before and after the optimization? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
