Re: [PR] [feature](schema) support temporary table like mysql [doris]
github-actions[bot] closed pull request #49112: [feature](schema) support temporary table like mysql URL: https://github.com/apache/doris/pull/49112 -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
github-actions[bot] commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-3544419772 We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable. If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag! -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2898046787 # BE UT Coverage Report Increment line coverage ` ` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/2887f625cc3256d03c57bd0b3d58d561562dd0e0_2887f625cc3256d03c57bd0b3d58d561562dd0e0/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/2887f625cc3256d03c57bd0b3d58d561562dd0e0_2887f625cc3256d03c57bd0b3d58d561562dd0e0/report/index.html) | Category | Coverage | |---|| | Function Coverage | 41.11% (10859/26414) | | Line Coverage | 31.91% (92714/290532) | | Region Coverage | 30.98% (47818/154375) | | Branch Coverage | 27.45% (24486/89214) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2898015167 ClickBench: Total hot run time: 31.7 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2887f625cc3256d03c57bd0b3d58d561562dd0e0, data reload: false query1 0.030.040.03 query2 0.090.040.04 query3 0.230.060.06 query4 1.630.090.09 query5 0.530.520.49 query6 1.140.750.75 query7 0.030.020.02 query8 0.050.040.05 query9 0.550.500.50 query10 0.560.540.57 query11 0.160.120.12 query12 0.160.140.14 query13 0.610.600.59 query14 0.810.790.81 query15 0.860.850.83 query16 0.380.380.38 query17 0.991.051.07 query18 0.180.190.19 query19 1.941.871.93 query20 0.020.020.02 query21 15.40 0.680.67 query22 4.077.142.40 query23 18.28 1.531.39 query24 2.320.230.23 query25 0.160.080.10 query26 0.280.180.18 query27 0.080.080.08 query28 13.18 0.610.60 query29 12.67 3.403.36 query30 0.260.060.06 query31 2.880.400.40 query32 3.210.490.49 query33 3.013.033.04 query34 17.05 4.514.57 query35 4.624.584.57 query36 0.650.470.48 query37 0.200.170.17 query38 0.160.160.16 query39 0.050.040.05 query40 0.160.140.13 query41 0.100.060.05 query42 0.060.050.04 query43 0.050.050.05 Total cold run time: 109.85 s Total hot run time: 31.7 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2897994528 TPC-DS: Total hot run time: 196904 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 2887f625cc3256d03c57bd0b3d58d561562dd0e0, data reload: false query1 1324902 926 902 query2 6326190319321903 query3 10793 423744134237 query4 60924 29643 23503 23503 query5 5216460 460 460 query6 401 171 174 171 query7 5484306 311 306 query8 303 224 221 221 query9 8681261225682568 query10 455 274 253 253 query11 17747 15394 15880 15394 query12 168 107 100 100 query13 1471439 444 439 query14 10509 763467136713 query15 206 190 183 183 query16 7116477 474 474 query17 1264586 593 586 query18 1880329 333 329 query19 228 166 167 166 query20 115 106 108 106 query21 201 102 106 102 query22 4843464048994640 query23 34912 34419 33976 33976 query24 6212297329442944 query25 535 425 436 425 query26 657 167 167 167 query27 1890379 356 356 query28 4401218921452145 query29 766 439 435 435 query30 243 161 165 161 query31 960 821 846 821 query32 68 55 60 55 query33 449 278 287 278 query34 905 515 515 515 query35 863 711 745 711 query36 1082948 921 921 query37 107 64 70 64 query38 4007398640193986 query39 1674145014681450 query40 199 100 105 100 query41 54 54 50 50 query42 118 106 102 102 query43 532 493 482 482 query44 1183806 803 803 query45 177 168 168 168 query46 1144739 740 739 query47 2033193519751935 query48 484 377 389 377 query49 709 402 416 402 query50 840 438 443 438 query51 7498731073217310 query52 105 94 91 91 query53 266 188 182 182 query54 584 475 454 454 query55 77 79 78 78 query56 269 254 253 253 query57 1242122211601160 query58 224 215 215 215 query59 3230310229342934 query60 281 257 261 257 query61 119 173 116 116 query62 779 666 674 666 query63 217 187 182 182 query64 1388669 636 636 query65 3266324631963196 query66 705 302 297 297 query67 16036 15696 15648 15648 query68 4079587 574 574 query69 429 263 266 263 query70 1199112411221122 query71 352 257 257 257 query72 6371408340254025 query73 770 345 355 345 query74 10222 922689398939 query75 3384260527012605 query76 2000101610461016 query77 464 272 273 272 query78 10606 972496269626 query79 1632589 588 588 query80 1140423 425 423 query81 505 230 217 217 query82 124592 89 89 query83 270 152 148 148 query84 283 82 78 78 query85 916 314 297 297 query86 341 297 294 294 query87 4383422742294227 query88 3595239423692369 query89 418 295 301 295 query90 1976186 180 180 query91 176 147 152 147 query92 62 52 53 52 query93 2001547 557 547 query94 752 305 289 289 query95 352 256 253 253 query96 621 284 282 282 query97 3317323231643164 query98 226 202 203 202 query99 1580129012821282 Total cold run time: 314812 ms Total hot run time: 196904 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2897954240 TPC-H: Total hot run time: 39969 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2887f625cc3256d03c57bd0b3d58d561562dd0e0, data reload: false -- Round 1 -- q1 17590 683266256625 q2 2082166 163 163 q3 10655 108711431087 q4 10556 723 726 723 q5 7744287728312831 q6 218 137 133 133 q7 993 616 599 599 q8 9359199720371997 q9 6655645564726455 q10 7076233422682268 q11 475 263 270 263 q12 404 217 213 213 q13 17796 302330033003 q14 239 208 208 208 q15 504 474 465 465 q16 517 380 369 369 q17 989 598 541 541 q18 7449660666206606 q19 1395108010841080 q20 485 204 196 196 q21 4101315532713155 q22 1096989 1010989 Total cold run time: 108378 ms Total hot run time: 39969 ms - Round 2, with runtime_filter_mode=off - q1 6613659066206590 q2 326 234 248 234 q3 2915280429602804 q4 2026179417581758 q5 5770579457695769 q6 207 132 134 132 q7 2256179318011793 q8 3429359035533553 q9 8915901290209012 q10 3576351735263517 q11 581 501 490 490 q12 796 637 604 604 q13 9806318231903182 q14 300 255 275 255 q15 513 465 461 461 q16 500 451 457 451 q17 1850163516061606 q18 8295774876597659 q19 1708167814611461 q20 2122185018221822 q21 555054915491 q22 11141053992 992 Total cold run time: 69173 ms Total hot run time: 59636 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2897714729 # Cloud UT Coverage Report Increment line coverage ` ` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/2887f625cc3256d03c57bd0b3d58d561562dd0e0_2887f625cc3256d03c57bd0b3d58d561562dd0e0_cloud/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/2887f625cc3256d03c57bd0b3d58d561562dd0e0_2887f625cc3256d03c57bd0b3d58d561562dd0e0_cloud/report/index.html) | Category | Coverage | |---|| | Function Coverage | 83.13% (1094/1316) | | Line Coverage | 66.20% (18163/27438) | | Region Coverage | 65.92% (8992/13641) | | Branch Coverage | 55.64% (4853/8722) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
pingchunzhang commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2897643642 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2888992214 run p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869953366 ClickBench: Total hot run time: 33.62 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 3be4b1c3a314bb35ce1b228a1b7adac2e2818847, data reload: false query1 0.030.030.03 query2 0.080.040.04 query3 0.240.050.06 query4 1.640.080.09 query5 0.530.520.50 query6 1.140.780.74 query7 0.020.010.01 query8 0.060.050.04 query9 0.550.490.51 query10 0.550.550.54 query11 0.170.120.12 query12 0.160.120.13 query13 0.610.590.59 query14 2.732.722.74 query15 0.910.840.85 query16 0.380.360.38 query17 1.031.001.03 query18 0.190.180.20 query19 1.851.862.03 query20 0.010.010.01 query21 15.37 0.660.66 query22 4.076.192.64 query23 18.25 1.381.34 query24 2.160.230.22 query25 0.150.080.08 query26 0.270.180.18 query27 0.080.070.08 query28 13.32 0.600.58 query29 12.66 3.453.39 query30 0.240.060.05 query31 2.850.400.40 query32 3.220.480.48 query33 2.992.983.04 query34 17.04 4.594.56 query35 4.534.574.56 query36 0.660.490.48 query37 0.210.160.18 query38 0.170.160.16 query39 0.060.050.04 query40 0.160.140.13 query41 0.090.050.05 query42 0.060.050.05 query43 0.050.040.05 Total cold run time: 111.54 s Total hot run time: 33.62 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869952645 # BE UT Coverage Report Increment line coverage ` ` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/3be4b1c3a314bb35ce1b228a1b7adac2e2818847_3be4b1c3a314bb35ce1b228a1b7adac2e2818847/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/3be4b1c3a314bb35ce1b228a1b7adac2e2818847_3be4b1c3a314bb35ce1b228a1b7adac2e2818847/report/index.html) | Category | Coverage | |---|| | Function Coverage | 40.95% (10796/26362) | | Line Coverage | 31.80% (92142/289762) | | Region Coverage | 30.88% (47568/154030) | | Branch Coverage | 27.39% (24378/89014) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869951524 TPC-DS: Total hot run time: 197148 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 3be4b1c3a314bb35ce1b228a1b7adac2e2818847, data reload: false query1 1284889 901 889 query2 6256200419961996 query3 10817 447540624062 query4 60986 29182 23432 23432 query5 5163455 445 445 query6 403 176 167 167 query7 5497309 307 307 query8 295 217 215 215 query9 8351261525832583 query10 458 268 258 258 query11 17515 15186 15630 15186 query12 161 104 103 103 query13 1460453 456 453 query14 9823702271867022 query15 212 181 187 181 query16 7096484 478 478 query17 1144604 632 604 query18 1885333 336 333 query19 208 166 158 158 query20 120 110 108 108 query21 206 104 100 100 query22 4728449747754497 query23 34662 34033 34268 34033 query24 6130294829612948 query25 514 409 439 409 query26 661 165 162 162 query27 2046348 373 348 query28 4310248624502450 query29 682 444 441 441 query30 240 164 160 160 query31 1008816 830 816 query32 68 58 60 58 query33 477 292 285 285 query34 951 510 523 510 query35 865 732 719 719 query36 1092955 960 955 query37 115 66 61 61 query38 4097406239833983 query39 1503147114591459 query40 209 99 105 99 query41 50 48 49 48 query42 112 107 101 101 query43 544 490 493 490 query44 1163816 813 813 query45 186 169 170 169 query46 1174726 730 726 query47 2073196219161916 query48 489 409 383 383 query49 731 415 388 388 query50 872 437 430 430 query51 7245724871577157 query52 112 94 90 90 query53 263 186 187 186 query54 609 472 459 459 query55 79 81 80 80 query56 281 251 253 251 query57 1263117111781171 query58 233 215 220 215 query59 3179288829202888 query60 269 253 249 249 query61 129 111 112 111 query62 788 625 696 625 query63 217 189 188 188 query64 1415682 651 651 query65 3311321232103210 query66 701 304 312 304 query67 15903 15594 15607 15594 query68 3996578 589 578 query69 439 273 281 273 query70 1176113710981098 query71 353 254 252 252 query72 6531420141684168 query73 749 349 362 349 query74 10059 922690539053 query75 3361266226662662 query76 2054106611041066 query77 492 280 281 280 query78 10606 966895399539 query79 2135606 620 606 query80 1368429 433 429 query81 540 244 241 241 query82 121390 87 87 query83 274 151 153 151 query84 282 85 79 79 query85 1028318 303 303 query86 405 282 292 282 query87 4392431942664266 query88 3889239523522352 query89 415 300 307 300 query90 1975188 190 188 query91 188 153 146 146 query92 64 49 49 49 query93 2656558 555 555 query94 799 307 296 296 query95 363 256 256 256 query96 617 291 277 277 query97 3271319631443144 query98 222 210 200 200 query99 1589130112571257 Total cold run time: 314590 ms Total hot run time: 197148 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869945432 TPC-H: Total hot run time: 40165 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 3be4b1c3a314bb35ce1b228a1b7adac2e2818847, data reload: false -- Round 1 -- q1 17578 679966686668 q2 2059167 180 167 q3 10926 108511801085 q4 10559 773 680 680 q5 7771287128952871 q6 228 140 143 140 q7 987 630 614 614 q8 9389199220481992 q9 6610647664226422 q10 6988223523572235 q11 458 265 265 265 q12 414 219 209 209 q13 17807 297429972974 q14 239 200 207 200 q15 514 468 477 468 q16 632 583 594 583 q17 1007545 572 545 q18 7393668866176617 q19 1403103410811034 q20 479 205 205 205 q21 4145320232733202 q22 11071010989 989 Total cold run time: 108693 ms Total hot run time: 40165 ms - Round 2, with runtime_filter_mode=off - q1 6619664065856585 q2 321 238 243 238 q3 2911279029662790 q4 2041180317751775 q5 5808576957825769 q6 216 137 132 132 q7 2230180818371808 q8 3385358035333533 q9 8866886588978865 q10 3540351835353518 q11 613 501 506 501 q12 813 606 630 606 q13 8777310231573102 q14 299 262 272 262 q15 514 450 456 450 q16 709 663 659 659 q17 1848165216541652 q18 8209778977317731 q19 1741154116561541 q20 2107182518531825 q21 5557529053505290 q22 1123107410241024 Total cold run time: 68247 ms Total hot run time: 59656 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869873164 TeamCity cloud ut coverage result: Function Coverage: 83.08% (1090/1312) Line Coverage: 66.01% (18031/27316) Region Coverage: 65.50% (8873/13547) Branch Coverage: 55.40% (4788/8642) Coverage Report: http://coverage.selectdb-in.cc/coverage/3be4b1c3a314bb35ce1b228a1b7adac2e2818847_3be4b1c3a314bb35ce1b228a1b7adac2e2818847_cloud/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2869870052 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727306186 # BE UT Coverage Report Increment line coverage ` ` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/80ec43a4a13868e7bbf2f641e89705a7cdf2577e_80ec43a4a13868e7bbf2f641e89705a7cdf2577e/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/80ec43a4a13868e7bbf2f641e89705a7cdf2577e_80ec43a4a13868e7bbf2f641e89705a7cdf2577e/report/index.html) | Category | Coverage | |---|| | Function Coverage | 38.87% (10166/26152) | | Line Coverage | 30.28% (86608/286010) | | Region Coverage | 29.34% (44496/151670) | | Branch Coverage | 25.85% (22625/87520) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727302071 ClickBench: Total hot run time: 33.55 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 80ec43a4a13868e7bbf2f641e89705a7cdf2577e, data reload: false query1 0.040.030.03 query2 0.090.050.04 query3 0.230.060.05 query4 1.650.090.08 query5 0.510.510.53 query6 1.120.740.75 query7 0.030.020.02 query8 0.050.040.04 query9 0.550.490.52 query10 0.560.550.56 query11 0.160.120.12 query12 0.160.130.12 query13 0.610.610.61 query14 2.752.862.92 query15 0.920.840.84 query16 0.380.390.39 query17 1.051.011.06 query18 0.180.200.19 query19 1.971.892.02 query20 0.020.010.02 query21 15.35 0.680.66 query22 3.787.402.49 query23 18.29 1.491.34 query24 2.180.230.24 query25 0.150.070.08 query26 0.280.170.18 query27 0.090.070.07 query28 13.28 0.590.57 query29 12.64 3.313.33 query30 0.240.050.05 query31 2.870.400.39 query32 3.230.500.49 query33 3.003.003.09 query34 16.84 4.544.49 query35 4.594.534.58 query36 0.670.510.48 query37 0.190.160.15 query38 0.160.150.15 query39 0.060.040.04 query40 0.160.130.14 query41 0.100.050.05 query42 0.060.050.05 query43 0.050.050.05 Total cold run time: 111.29 s Total hot run time: 33.55 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727299346 TPC-DS: Total hot run time: 196684 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 80ec43a4a13868e7bbf2f641e89705a7cdf2577e, data reload: false query1 1315955 954 954 query2 6236207820712071 query3 10815 430542574257 query4 65266 27796 23253 23253 query5 5028471 462 462 query6 438 183 189 183 query7 5702321 311 311 query8 314 225 232 225 query9 9062263226142614 query10 488 276 264 264 query11 17888 15195 15687 15195 query12 169 114 102 102 query13 1518487 430 430 query14 10927 767368456845 query15 204 193 195 193 query16 7181486 415 415 query17 1119604 629 604 query18 1865320 308 308 query19 199 161 149 149 query20 116 111 116 111 query21 206 103 103 103 query22 4500434743904347 query23 34586 33743 34081 33743 query24 6140302229812981 query25 517 423 417 417 query26 661 167 168 167 query27 1961364 346 346 query28 4377250224802480 query29 696 458 436 436 query30 236 160 163 160 query31 976 813 833 813 query32 70 54 58 54 query33 441 307 295 295 query34 905 517 530 517 query35 862 730 723 723 query36 1108968 965 965 query37 113 65 69 65 query38 4213400039293929 query39 1539146814701468 query40 207 106 109 106 query41 51 53 50 50 query42 117 109 102 102 query43 556 511 492 492 query44 1222851 837 837 query45 187 173 170 170 query46 1163769 750 750 query47 2029189919431899 query48 491 397 393 393 query49 757 419 411 411 query50 872 430 447 430 query51 7284721771247124 query52 103 93 90 90 query53 279 189 189 189 query54 576 473 473 473 query55 82 82 79 79 query56 272 259 269 259 query57 1187109211301092 query58 225 222 222 222 query59 3094296928782878 query60 284 262 262 262 query61 137 131 152 131 query62 771 685 652 652 query63 226 203 201 201 query64 1401691 652 652 query65 3235318432023184 query66 700 299 324 299 query67 15862 15552 15658 15552 query68 4029601 593 593 query69 437 266 273 266 query70 1190113811531138 query71 368 266 262 262 query72 6455393639883936 query73 752 358 354 354 query74 10470 919291849184 query75 3348265826742658 query76 1846101710941017 query77 523 284 272 272 query78 10476 960895489548 query79 1626606 621 606 query80 888 452 428 428 query81 516 240 238 238 query82 114992 91 91 query83 159 148 148 148 query84 280 76 83 76 query85 878 343 291 291 query86 332 306 302 302 query87 4518424942774249 query88 3881239723672367 query89 430 301 294 294 query90 2044186 186 186 query91 180 146 148 146 query92 69 51 53 51 query93 1833562 559 559 query94 867 302 287 287 query95 367 261 259 259 query96 613 278 280 278 query97 3321315631803156 query98 216 208 195 195 query99 1590132213151315 Total cold run time: 318978 ms Total hot run time: 196684 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727290876 TPC-H: Total hot run time: 39983 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 80ec43a4a13868e7bbf2f641e89705a7cdf2577e, data reload: false -- Round 1 -- q1 17588 704765836583 q2 2065173 182 173 q3 10769 111411961114 q4 10268 782 711 711 q5 7719290228402840 q6 218 132 131 131 q7 972 609 594 594 q8 9352196320701963 q9 6633642264276422 q10 7055230322972297 q11 468 265 258 258 q12 403 208 206 206 q13 17781 299429732973 q14 241 208 219 208 q15 512 465 465 465 q16 675 594 584 584 q17 981 562 500 500 q18 7409661066926610 q19 1402987 1036987 q20 470 213 199 199 q21 4038326231913191 q22 1061983 974 974 Total cold run time: 108080 ms Total hot run time: 39983 ms - Round 2, with runtime_filter_mode=off - q1 6637653966366539 q2 339 237 234 234 q3 2903278229222782 q4 2056179817381738 q5 5772574557185718 q6 220 131 128 128 q7 2221185818441844 q8 3443357735203520 q9 8679890888098809 q10 3548352735533527 q11 599 494 475 475 q12 824 603 605 603 q13 9858323130923092 q14 304 272 280 272 q15 503 465 483 465 q16 680 644 651 644 q17 1863163916171617 q18 8406788576747674 q19 1659155916421559 q20 2149186918451845 q21 5591523054455230 q22 1119102110091009 Total cold run time: 69373 ms Total hot run time: 59324 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727252736 TeamCity cloud ut coverage result: Function Coverage: 83.00% (1074/1294) Line Coverage: 65.93% (17725/26883) Region Coverage: 65.32% (8720/13350) Branch Coverage: 55.27% (4701/8506) Coverage Report: http://coverage.selectdb-in.cc/coverage/80ec43a4a13868e7bbf2f641e89705a7cdf2577e_80ec43a4a13868e7bbf2f641e89705a7cdf2577e_cloud/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Thearas commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727245470 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]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #49112: URL: https://github.com/apache/doris/pull/49112#issuecomment-2727245489 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2705923764 TPC-H: Total hot run time: 32853 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 5b80f6d3e35a336c82550aa9ece08e05e8348c8c, data reload: false -- Round 1 -- q1 17640 527251485148 q2 2057303 166 166 q3 10414 1265773 773 q4 10235 1043557 557 q5 7661241024162410 q6 205 168 136 136 q7 905 755 630 630 q8 9317135711141114 q9 5043471046844684 q10 6820232519311931 q11 491 283 269 269 q12 358 352 216 216 q13 17769 369130653065 q14 237 233 217 217 q15 535 523 468 468 q16 626 615 600 600 q17 595 872 350 350 q18 6820645864026402 q19 22681000552 552 q20 315 338 189 189 q21 2945222420022002 q22 10791025974 974 Total cold run time: 104335 ms Total hot run time: 32853 ms - Round 2, with runtime_filter_mode=off - q1 5326521452385214 q2 247 334 230 230 q3 2182266422942294 q4 1483193113811381 q5 4329418141964181 q6 219 171 127 127 q7 1968190817771777 q8 2684269426322632 q9 7228719472047194 q10 3049325527692769 q11 571 502 497 497 q12 728 773 585 585 q13 3485401832523252 q14 270 306 272 272 q15 515 491 482 482 q16 663 666 660 660 q17 1165162913271327 q18 7825760875997599 q19 895 877 865 865 q20 1995204118951895 q21 5539495447694769 q22 1099109110391039 Total cold run time: 53465 ms Total hot run time: 51041 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] [feature](schema) support temporary table like mysql [doris]
github-actions[bot] commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2709356407 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
dataroaring merged PR #40680: URL: https://github.com/apache/doris/pull/40680 -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
github-actions[bot] commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2709356378 PR approved by at least one committer and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706586123 run feut -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2705960703 ClickBench: Total hot run time: 31.48 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 5b80f6d3e35a336c82550aa9ece08e05e8348c8c, data reload: false query1 0.040.030.02 query2 0.100.050.04 query3 0.270.060.05 query4 1.610.070.08 query5 0.550.550.55 query6 1.200.740.71 query7 0.020.010.02 query8 0.060.040.04 query9 0.620.530.52 query10 0.580.600.58 query11 0.250.130.12 query12 0.260.130.13 query13 0.640.620.61 query14 2.802.742.82 query15 1.000.900.88 query16 0.380.380.37 query17 1.051.041.07 query18 0.190.180.19 query19 1.981.961.91 query20 0.010.010.01 query21 15.35 0.970.67 query22 0.931.110.82 query23 14.72 1.530.75 query24 5.090.620.29 query25 0.160.090.08 query26 0.550.220.18 query27 0.080.080.09 query28 11.08 1.200.58 query29 12.61 4.033.43 query30 0.280.080.06 query31 2.830.640.43 query32 3.230.600.50 query33 3.043.163.06 query34 16.53 5.134.40 query35 4.474.454.44 query36 0.630.510.50 query37 0.200.170.16 query38 0.170.160.15 query39 0.050.040.04 query40 0.190.150.15 query41 0.100.060.05 query42 0.060.040.04 query43 0.050.040.04 Total cold run time: 106.01 s Total hot run time: 31.48 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] [feature](schema) support temporary table like mysql [doris]
hello-stephen commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706397087 # BE UT Coverage Report Increment line coverage `0.00% (0/0)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/4023ed7d094f26de95d765585f31c2abe6a75def_4023ed7d094f26de95d765585f31c2abe6a75def/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/4023ed7d094f26de95d765585f31c2abe6a75def_4023ed7d094f26de95d765585f31c2abe6a75def/report/index.html) | Category | Coverage | |---|| | Function Coverage | 46.86% (12533/26744) | | Line Coverage | 36.45% (106854/293115) | | Region Coverage | 35.49% (54563/153757) | | Branch Coverage | 30.84% (27439/88972) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706334670 ClickBench: Total hot run time: 31.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 4023ed7d094f26de95d765585f31c2abe6a75def, data reload: false query1 0.030.030.03 query2 0.100.050.05 query3 0.280.060.04 query4 1.600.070.08 query5 0.570.560.55 query6 1.180.740.72 query7 0.020.010.02 query8 0.050.050.05 query9 0.630.530.53 query10 0.580.590.59 query11 0.240.130.12 query12 0.260.130.12 query13 0.630.620.62 query14 2.802.682.82 query15 0.990.870.87 query16 0.360.380.37 query17 1.041.081.03 query18 0.190.190.18 query19 2.081.861.84 query20 0.020.010.02 query21 15.37 0.990.67 query22 0.931.030.78 query23 14.71 1.510.75 query24 5.350.580.28 query25 0.160.090.09 query26 0.550.210.18 query27 0.090.090.09 query28 11.00 1.150.57 query29 12.53 4.123.36 query30 0.290.080.06 query31 2.820.620.44 query32 3.230.590.50 query33 3.033.043.12 query34 16.57 5.154.46 query35 4.514.534.54 query36 0.680.490.50 query37 0.210.180.17 query38 0.170.150.14 query39 0.050.040.04 query40 0.200.160.15 query41 0.100.050.05 query42 0.060.050.05 query43 0.050.050.04 Total cold run time: 106.31 s Total hot run time: 31.41 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706324143 TPC-DS: Total hot run time: 192228 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 4023ed7d094f26de95d765585f31c2abe6a75def, data reload: false query1 1380988 983 983 query2 6259198319161916 query3 11122 462647054626 query4 55060 25943 23336 23336 query5 5064630 486 486 query6 337 215 209 209 query7 4876531 294 294 query8 330 249 242 242 query9 5521253425502534 query10 422 326 259 259 query11 15076 15115 14805 14805 query12 159 111 110 110 query13 1038509 401 401 query14 10669 698463346334 query15 212 208 198 198 query16 7132647 471 471 query17 1088768 598 598 query18 1530410 323 323 query19 221 201 172 172 query20 131 136 127 127 query21 209 126 107 107 query22 4548459243364336 query23 33878 33388 33359 33359 query24 5719242124342421 query25 454 475 405 405 query26 706 275 153 153 query27 1845493 350 350 query28 2883247024442444 query29 587 587 448 448 query30 267 222 191 191 query31 897 869 773 773 query32 70 69 63 63 query33 457 353 301 301 query34 764 862 512 512 query35 781 815 758 758 query36 954 985 895 895 query37 122 103 79 79 query38 4254421841754175 query39 1467143614481436 query40 209 115 104 104 query41 53 53 49 49 query42 119 104 102 102 query43 516 514 472 472 query44 1324809 822 809 query45 191 171 165 165 query46 856 1038669 669 query47 1893188717851785 query48 378 413 305 305 query49 712 516 424 424 query50 713 777 416 416 query51 4267432043244320 query52 105 105 91 91 query53 250 264 196 196 query54 490 507 425 425 query55 91 81 85 81 query56 282 277 247 247 query57 1139119411201120 query58 240 245 237 237 query59 2998298129542954 query60 295 265 268 265 query61 127 119 126 119 query62 742 747 694 694 query63 238 191 195 191 query64 18561062687 687 query65 4544442244324422 query66 750 403 305 305 query67 16042 15728 15360 15360 query68 6876878 509 509 query69 535 301 294 294 query70 1204108311001083 query71 501 306 272 272 query72 5837359738623597 query73 1463724 341 341 query74 9599922288028802 query75 3991318327032703 query76 42161198754 754 query77 836 354 278 278 query78 10001 10165 92869286 query79 2903829 578 578 query80 684 532 441 441 query81 488 260 217 217 query82 636 124 94 94 query83 222 174 155 155 query84 281 107 74 74 query85 783 356 309 309 query86 351 315 245 245 query87 4436444944784449 query88 3438224922802249 query89 417 311 277 277 query90 1913212 223 212 query91 136 140 112 112 query92 74 66 55 55 query93 15771041585 585 query94 659 416 310 310 query95 349 331 263 263 query96 486 574 284 284 query97 3339336532913291 query98 226 207 199 199 query99 1473142212661266 Total cold run time: 299839 ms Total hot run time: 192228 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706300721 TPC-H: Total hot run time: 32512 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 4023ed7d094f26de95d765585f31c2abe6a75def, data reload: false -- Round 1 -- q1 17645 518050965096 q2 2052300 168 168 q3 10805 1250736 736 q4 10334 1068533 533 q5 9078235323902353 q6 201 166 135 135 q7 896 768 603 603 q8 9314128811071107 q9 4886472346684668 q10 6844229719051905 q11 503 279 282 279 q12 353 354 226 226 q13 17772 363630713071 q14 224 232 226 226 q15 540 495 479 479 q16 647 619 581 581 q17 583 866 347 347 q18 6979634964346349 q19 1306954 536 536 q20 327 323 198 198 q21 2757216219241924 q22 10931041992 992 Total cold run time: 105139 ms Total hot run time: 32512 ms - Round 2, with runtime_filter_mode=off - q1 5186512351355123 q2 235 333 232 232 q3 2137263623092309 q4 1483183514401440 q5 4254411641144114 q6 212 163 126 126 q7 1948191117651765 q8 2654267726382638 q9 7216731872367236 q10 3036320627672767 q11 569 507 495 495 q12 705 745 568 568 q13 3394393132673267 q14 277 300 272 272 q15 525 467 490 467 q16 628 691 645 645 q17 1161162913281328 q18 7848762275187518 q19 853 833 867 833 q20 1972202119051905 q21 5471499346934693 q22 1115111610611061 Total cold run time: 52879 ms Total hot run time: 50802 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706239793 TeamCity cloud ut coverage result: Function Coverage: 82.15% (1063/1294) Line Coverage: 65.75% (17648/26840) Region Coverage: 65.19% (8697/13340) Branch Coverage: 55.17% (4695/8510) Coverage Report: http://coverage.selectdb-in.cc/coverage/4023ed7d094f26de95d765585f31c2abe6a75def_4023ed7d094f26de95d765585f31c2abe6a75def_cloud/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706201395 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] [feature](schema) support temporary table like mysql [doris]
hello-stephen commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2706110823 # BE UT Coverage Report Increment line coverage `0.00% (0/0)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/5b80f6d3e35a336c82550aa9ece08e05e8348c8c_5b80f6d3e35a336c82550aa9ece08e05e8348c8c/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/5b80f6d3e35a336c82550aa9ece08e05e8348c8c_5b80f6d3e35a336c82550aa9ece08e05e8348c8c/report/index.html) | Category | Coverage | |---|| | Function Coverage | 46.86% (12533/26744) | | Line Coverage | 36.44% (106824/293115) | | Region Coverage | 35.49% (54570/153757) | | Branch Coverage | 30.84% (27435/88972) | -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2705949537 TPC-DS: Total hot run time: 191579 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 5b80f6d3e35a336c82550aa9ece08e05e8348c8c, data reload: false query1 1387101210141012 query2 6262200219611961 query3 11079 459245214521 query4 53773 25328 23461 23461 query5 5280561 510 510 query6 366 218 194 194 query7 4925509 294 294 query8 315 256 236 236 query9 6020251425272514 query10 436 308 259 259 query11 15237 15383 14769 14769 query12 160 116 107 107 query13 1107503 401 401 query14 10367 614764146147 query15 215 191 184 184 query16 7133654 483 483 query17 1086728 579 579 query18 1559420 327 327 query19 202 195 169 169 query20 140 133 121 121 query21 214 125 107 107 query22 4597447245144472 query23 33885 33325 33190 33190 query24 5982243424522434 query25 440 464 393 393 query26 764 273 149 149 query27 2224485 331 331 query28 2796245724642457 query29 594 574 452 452 query30 272 224 193 193 query31 894 873 802 802 query32 75 60 66 60 query33 468 366 310 310 query34 755 830 512 512 query35 805 857 742 742 query36 949 1012909 909 query37 129 104 72 72 query38 4086426341424142 query39 1487146614591459 query40 217 115 104 104 query41 55 52 50 50 query42 125 118 107 107 query43 497 534 495 495 query44 1313811 799 799 query45 184 175 170 170 query46 854 1034644 644 query47 1887190818041804 query48 377 421 312 312 query49 705 509 424 424 query50 718 780 441 441 query51 4336429542384238 query52 106 106 92 92 query53 229 268 193 193 query54 503 496 420 420 query55 84 84 83 83 query56 304 296 268 268 query57 1152119811291129 query58 292 240 233 233 query59 2852283129042831 query60 326 276 269 269 query61 119 115 123 115 query62 756 759 688 688 query63 236 196 189 189 query64 20531038683 683 query65 4517443144624431 query66 762 393 296 296 query67 15709 15849 15193 15193 query68 7202877 506 506 query69 525 293 261 261 query70 1134105210561052 query71 488 304 248 248 query72 5746356037623560 query73 1248729 342 342 query74 8971921889968996 query75 3760316126882688 query76 41601184766 766 query77 631 362 267 267 query78 10115 10107 92389238 query79 2965828 579 579 query80 715 511 442 442 query81 497 259 224 224 query82 477 122 100 100 query83 290 184 154 154 query84 287 85 78 78 query85 883 346 303 303 query86 396 289 299 289 query87 4483449342994299 query88 340721982198 query89 412 309 282 282 query90 1766205 214 205 query91 143 181 112 112 query92 75 62 54 54 query93 23061073583 583 query94 654 409 297 297 query95 347 270 258 258 query96 492 576 271 271 query97 3381332833123312 query98 230 201 201 201 query99 1456138212781278 Total cold run time: 299375 ms Total hot run time: 191579 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2705729815 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2705760690 TeamCity cloud ut coverage result: Function Coverage: 82.15% (1063/1294) Line Coverage: 65.70% (17634/26840) Region Coverage: 65.16% (8692/13340) Branch Coverage: 55.09% (4688/8510) Coverage Report: http://coverage.selectdb-in.cc/coverage/5b80f6d3e35a336c82550aa9ece08e05e8348c8c_5b80f6d3e35a336c82550aa9ece08e05e8348c8c_cloud/report/index.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1983225192
##
fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java:
##
@@ -381,6 +382,19 @@ public void checkQuota() throws DdlException {
checkReplicaQuota();
}
+public boolean isTableExist(String tableName, boolean isTemporary) {
+if (Env.isTableNamesCaseInsensitive()) {
+tableName = tableName.toLowerCase();
+}
+
+if (isTemporary) {
+Set tableSet =
ConnectContext.get().getDbToTempTableNamesMap().get(fullQualifiedName);
+return tableSet != null && tableSet.contains(tableName);
+} else {
+return nameToTable.containsKey(tableName);
+}
+}
+
public boolean isTableExist(String tableName) {
Review Comment:
done
##
fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java:
##
@@ -381,6 +382,19 @@ public void checkQuota() throws DdlException {
checkReplicaQuota();
}
+public boolean isTableExist(String tableName, boolean isTemporary) {
+if (Env.isTableNamesCaseInsensitive()) {
+tableName = tableName.toLowerCase();
Review Comment:
fixed
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1983242239
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -304,11 +308,23 @@ private void sendJobId(List analysisInfos,
boolean proxy) {
row.add(databaseIf.isPresent() ? databaseIf.get().getFullName() :
"DB may get deleted");
if (databaseIf.isPresent()) {
Optional table =
databaseIf.get().getTable(analysisInfo.tblId);
-row.add(table.isPresent() ? table.get().getName() : "Table may
get deleted");
+row.add(table.isPresent() ?
Util.getTempTableDisplayName(table.get().getName())
Review Comment:
will allow analyze temporary table
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680: URL: https://github.com/apache/doris/pull/40680#discussion_r1978830411 ## fe/fe-core/src/main/java/org/apache/doris/alter/Alter.java: ## @@ -127,7 +127,7 @@ public void processCreateMaterializedView(CreateMaterializedViewStmt stmt) Database db = Env.getCurrentInternalCatalog().getDbOrDdlException(dbName); Env.getCurrentInternalCatalog().checkAvailableCapacity(db); -OlapTable olapTable = (OlapTable) db.getTableOrMetaException(tableName, TableType.OLAP); +OlapTable olapTable = (OlapTable) db.getNonTempTableOrMetaException(tableName, TableType.OLAP); Review Comment: done, forbid create async mtmv as well -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1978835045
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -304,11 +308,23 @@ private void sendJobId(List analysisInfos,
boolean proxy) {
row.add(databaseIf.isPresent() ? databaseIf.get().getFullName() :
"DB may get deleted");
if (databaseIf.isPresent()) {
Optional table =
databaseIf.get().getTable(analysisInfo.tblId);
-row.add(table.isPresent() ? table.get().getName() : "Table may
get deleted");
+row.add(table.isPresent() ?
Util.getTempTableDisplayName(table.get().getName())
Review Comment:
done. now temp table will be analyzed as well
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1978831436
##
fe/fe-core/src/main/java/org/apache/doris/catalog/DatabaseIf.java:
##
@@ -167,6 +183,17 @@ default T getTableOrMetaException(String tableName,
TableIf.TableType tableType)
return table;
}
+default T getNonTempTableOrMetaException(String tableName,
TableIf.TableType tableType)
+throws MetaNotFoundException {
+T table = getNonTempTableOrMetaException(tableName);
+TableType type = Objects.requireNonNull(table.getType());
Review Comment:
done
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1978829193
##
fe/fe-core/src/main/java/org/apache/doris/backup/BackupHandler.java:
##
@@ -435,14 +436,27 @@ private void backup(Repository repository, Database db,
BackupStmt stmt) throws
if (Config.ignore_backup_not_support_table_type) {
LOG.warn("Table '{}' is a {} table, can not backup and
ignore it."
+ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
-tblName, tbl.getType().toString());
+tblName, tbl.isTemporary() ? "temporary" :
tbl.getType().toString());
tblRefsNotSupport.add(tblRef);
continue;
} else {
ErrorReport.reportDdlException(ErrorCode.ERR_NOT_OLAP_TABLE, tblName);
}
}
+if (tbl.isTemporary()) {
+if (Config.ignore_backup_not_support_table_type) {
+LOG.warn("Table '{}' is a temporary table, can not backup
and ignore it."
++ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
+Util.getTempTableDisplayName(tblName));
+tblRefsNotSupport.add(tblRef);
+continue;
+} else {
+ErrorReport.reportDdlException("Table " +
Util.getTempTableDisplayName(tblName)
Review Comment:
As discussed, if a backup job only contains one temporary table, will throw
error. While, if a backup job contains temporary table and other olap table,
will just ignore temporary table, and the backup job will run.
Done
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680: URL: https://github.com/apache/doris/pull/40680#discussion_r1971210290 ## fe/fe-core/src/main/java/org/apache/doris/alter/Alter.java: ## @@ -127,7 +127,7 @@ public void processCreateMaterializedView(CreateMaterializedViewStmt stmt) Database db = Env.getCurrentInternalCatalog().getDbOrDdlException(dbName); Env.getCurrentInternalCatalog().checkAvailableCapacity(db); -OlapTable olapTable = (OlapTable) db.getTableOrMetaException(tableName, TableType.OLAP); +OlapTable olapTable = (OlapTable) db.getNonTempTableOrMetaException(tableName, TableType.OLAP); Review Comment: will implement it in pr later -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1975314869
##
fe/fe-core/src/main/java/org/apache/doris/policy/PolicyMgr.java:
##
@@ -179,12 +180,16 @@ public void dropPolicy(DropPolicyLog dropPolicyLog,
boolean ifExists) throws Ddl
for (Table table : tables) {
if (table instanceof OlapTable) {
OlapTable olapTable = (OlapTable) table;
+String tableName = table.getName();
+if (table.isTemporary()) {
+tableName =
Util.getTempTableDisplayName(tableName);
+}
Review Comment:
coz sometimes only have tablename with string type. refactor this code
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1975326911
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -206,6 +207,9 @@ public List
buildAnalysisInfosForDB(DatabaseIf db, Analyz
if (table instanceof View) {
continue;
}
+if (table.isTemporary()) {
Review Comment:
done. removed this restriction.
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1975321253
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -206,6 +207,9 @@ public List
buildAnalysisInfosForDB(DatabaseIf db, Analyz
if (table instanceof View) {
continue;
}
+if (table.isTemporary()) {
Review Comment:
done
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1975312060
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowPartitionIdCommand.java:
##
@@ -84,13 +90,22 @@ private ShowResultSet handleShowPartitionId(ConnectContext
ctx, StmtExecutor exe
if (partition != null) {
List row = new ArrayList<>();
row.add(database.getFullName());
-row.add(tbl.getName());
+if (tbl.isTemporary()) {
+if
(!Util.isTempTableInCurrentSession(tbl.getName())) {
+continue;
+}
+
row.add(Util.getTempTableDisplayName(tbl.getName()));
Review Comment:
done
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1975269929
##
fe/fe-core/src/main/java/org/apache/doris/backup/BackupHandler.java:
##
@@ -435,14 +436,27 @@ private void backup(Repository repository, Database db,
BackupStmt stmt) throws
if (Config.ignore_backup_not_support_table_type) {
LOG.warn("Table '{}' is a {} table, can not backup and
ignore it."
+ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
-tblName, tbl.getType().toString());
+tblName, tbl.isTemporary() ? "temporary" :
tbl.getType().toString());
tblRefsNotSupport.add(tblRef);
continue;
} else {
ErrorReport.reportDdlException(ErrorCode.ERR_NOT_OLAP_TABLE, tblName);
}
}
+if (tbl.isTemporary()) {
+if (Config.ignore_backup_not_support_table_type) {
+LOG.warn("Table '{}' is a temporary table, can not backup
and ignore it."
++ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
+Util.getTempTableDisplayName(tblName));
+tblRefsNotSupport.add(tblRef);
+continue;
+} else {
+ErrorReport.reportDdlException("Table " +
Util.getTempTableDisplayName(tblName)
Review Comment:
what action should take if a backup job only contains one temporary table
and has no olap tables？
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680: URL: https://github.com/apache/doris/pull/40680#discussion_r1974891643 ## fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4: ## @@ -177,6 +177,19 @@ supportedCreateStatement properties=propertyClause? (BROKER extProperties=propertyClause)? (AS query)? #createTable +| CREATE (TEMPORARY)? TABLE (IF NOT EXISTS)? name=multipartIdentifier Review Comment: done ## fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4: ## @@ -185,6 +198,9 @@ supportedCreateStatement | CREATE (EXTERNAL)? TABLE (IF NOT EXISTS)? name=multipartIdentifier LIKE existedTable=multipartIdentifier (WITH ROLLUP (rollupNames=identifierList)?)? #createTableLike +| CREATE (TEMPORARY)? TABLE (IF NOT EXISTS)? name=multipartIdentifier Review Comment: done -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680: URL: https://github.com/apache/doris/pull/40680#discussion_r1971210290 ## fe/fe-core/src/main/java/org/apache/doris/alter/Alter.java: ## @@ -127,7 +127,7 @@ public void processCreateMaterializedView(CreateMaterializedViewStmt stmt) Database db = Env.getCurrentInternalCatalog().getDbOrDdlException(dbName); Env.getCurrentInternalCatalog().checkAvailableCapacity(db); -OlapTable olapTable = (OlapTable) db.getTableOrMetaException(tableName, TableType.OLAP); +OlapTable olapTable = (OlapTable) db.getNonTempTableOrMetaException(tableName, TableType.OLAP); Review Comment: will implement it in pr later -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1971207968
##
fe/fe-core/src/main/java/org/apache/doris/binlog/BinlogManager.java:
##
@@ -154,7 +154,11 @@ private void addBinlog(long dbId, List tableIds,
long commitSeq, long time
if (tableIds != null) {
for (long tableId : tableIds) {
boolean tableBinlogEnable =
binlogConfigCache.isEnableTable(dbId, tableId);
-anyEnable = anyEnable || tableBinlogEnable;
+if (tableIds.size() > 1) {
+anyEnable = anyEnable || tableBinlogEnable;
+} else {
+anyEnable = tableBinlogEnable;
+}
Review Comment:
this code is used to ignore generating binlog for temporary table, coz
temporary table always has binlog.enable = false
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on code in PR #40680: URL: https://github.com/apache/doris/pull/40680#discussion_r1971201444 ## fe/fe-core/src/main/java/org/apache/doris/alter/Alter.java: ## @@ -127,7 +127,7 @@ public void processCreateMaterializedView(CreateMaterializedViewStmt stmt) Database db = Env.getCurrentInternalCatalog().getDbOrDdlException(dbName); Env.getCurrentInternalCatalog().checkAvailableCapacity(db); -OlapTable olapTable = (OlapTable) db.getTableOrMetaException(tableName, TableType.OLAP); +OlapTable olapTable = (OlapTable) db.getNonTempTableOrMetaException(tableName, TableType.OLAP); Review Comment: Due to their lifecycle difference. A mtmv created base on temporary table will not work after session closed -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
morrySnow commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1948925992
##
fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java:
##
@@ -569,7 +589,33 @@ public Table getTableNullable(String tableName) {
return null;
}
}
-return nameToTable.get(tableName);
+
+// return temp table first
+Table table =
nameToTable.get(Util.generateTempTableInnerName(tableName));
Review Comment:
so temporary table's name could same with permanent table?
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Jibing-Li commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1949131141
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -304,11 +308,23 @@ private void sendJobId(List analysisInfos,
boolean proxy) {
row.add(databaseIf.isPresent() ? databaseIf.get().getFullName() :
"DB may get deleted");
if (databaseIf.isPresent()) {
Optional table =
databaseIf.get().getTable(analysisInfo.tblId);
-row.add(table.isPresent() ? table.get().getName() : "Table may
get deleted");
+row.add(table.isPresent() ?
Util.getTempTableDisplayName(table.get().getName())
Review Comment:
Why do we need to do this and the following about newColNames if we skip
analyzing temp table?
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Jibing-Li commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1949128256
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -206,6 +207,9 @@ public List
buildAnalysisInfosForDB(DatabaseIf db, Analyz
if (table instanceof View) {
continue;
}
+if (table.isTemporary()) {
Review Comment:
If we need to skip analyzing temp table, we also need to skip it in
AnalysisManager.buildAnalysisJobInfo and StatisticsAutoCollector.processOneJob.
##
fe/fe-core/src/main/java/org/apache/doris/statistics/AnalysisManager.java:
##
@@ -304,11 +308,23 @@ private void sendJobId(List analysisInfos,
boolean proxy) {
row.add(databaseIf.isPresent() ? databaseIf.get().getFullName() :
"DB may get deleted");
if (databaseIf.isPresent()) {
Optional table =
databaseIf.get().getTable(analysisInfo.tblId);
-row.add(table.isPresent() ? table.get().getName() : "Table may
get deleted");
+row.add(table.isPresent() ?
Util.getTempTableDisplayName(table.get().getName())
Review Comment:
Why do we need to do this and the following about newColNames if we skip
analyze temp table?
--
This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
morrySnow commented on code in PR #40680:
URL: https://github.com/apache/doris/pull/40680#discussion_r1948879175
##
fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4:
##
@@ -185,6 +198,9 @@ supportedCreateStatement
| CREATE (EXTERNAL)? TABLE (IF NOT EXISTS)? name=multipartIdentifier
LIKE existedTable=multipartIdentifier
(WITH ROLLUP (rollupNames=identifierList)?)?
#createTableLike
+| CREATE (TEMPORARY)? TABLE (IF NOT EXISTS)? name=multipartIdentifier
Review Comment:
same as create table
##
fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4:
##
@@ -177,6 +177,19 @@ supportedCreateStatement
properties=propertyClause?
(BROKER extProperties=propertyClause)?
(AS query)?
#createTable
+| CREATE (TEMPORARY)? TABLE (IF NOT EXISTS)? name=multipartIdentifier
Review Comment:
remove this new branch
```
(EXTERNAL | TEMPORARY)?
```
##
fe/fe-core/src/main/java/org/apache/doris/binlog/BinlogManager.java:
##
@@ -154,7 +154,11 @@ private void addBinlog(long dbId, List tableIds,
long commitSeq, long time
if (tableIds != null) {
for (long tableId : tableIds) {
boolean tableBinlogEnable =
binlogConfigCache.isEnableTable(dbId, tableId);
-anyEnable = anyEnable || tableBinlogEnable;
+if (tableIds.size() > 1) {
+anyEnable = anyEnable || tableBinlogEnable;
+} else {
+anyEnable = tableBinlogEnable;
+}
Review Comment:
i think this is code of temporary table, it is better to submit another PR
to solve this problem
##
fe/fe-core/src/main/java/org/apache/doris/catalog/DatabaseIf.java:
##
@@ -167,6 +183,17 @@ default T getTableOrMetaException(String tableName,
TableIf.TableType tableType)
return table;
}
+default T getNonTempTableOrMetaException(String tableName,
TableIf.TableType tableType)
+throws MetaNotFoundException {
+T table = getNonTempTableOrMetaException(tableName);
+TableType type = Objects.requireNonNull(table.getType());
Review Comment:
add error message
##
fe/fe-core/src/main/java/org/apache/doris/backup/BackupHandler.java:
##
@@ -435,14 +436,27 @@ private void backup(Repository repository, Database db,
BackupStmt stmt) throws
if (Config.ignore_backup_not_support_table_type) {
LOG.warn("Table '{}' is a {} table, can not backup and
ignore it."
+ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
-tblName, tbl.getType().toString());
+tblName, tbl.isTemporary() ? "temporary" :
tbl.getType().toString());
tblRefsNotSupport.add(tblRef);
continue;
} else {
ErrorReport.reportDdlException(ErrorCode.ERR_NOT_OLAP_TABLE, tblName);
}
}
+if (tbl.isTemporary()) {
+if (Config.ignore_backup_not_support_table_type) {
+LOG.warn("Table '{}' is a temporary table, can not backup
and ignore it."
++ "Only OLAP(Doris)/ODBC/VIEW table can be backed
up",
+Util.getTempTableDisplayName(tblName));
+tblRefsNotSupport.add(tblRef);
+continue;
+} else {
+ErrorReport.reportDdlException("Table " +
Util.getTempTableDisplayName(tblName)
Review Comment:
i think backup should always ignore temporary table and should not failed
even if has temporary table in current Cluster
##
fe/fe-core/src/main/java/org/apache/doris/alter/Alter.java:
##
@@ -127,7 +127,7 @@ public void
processCreateMaterializedView(CreateMaterializedViewStmt stmt)
Database db =
Env.getCurrentInternalCatalog().getDbOrDdlException(dbName);
Env.getCurrentInternalCatalog().checkAvailableCapacity(db);
-OlapTable olapTable = (OlapTable)
db.getTableOrMetaException(tableName, TableType.OLAP);
+OlapTable olapTable = (OlapTable)
db.getNonTempTableOrMetaException(tableName, TableType.OLAP);
Review Comment:
why temporary table could not create materialized view?
##
fe/fe-core/src/main/java/org/apache/doris/catalog/Database.java:
##
@@ -381,6 +382,19 @@ public void checkQuota() throws DdlException {
checkReplicaQuota();
}
+public boolean isTableExist(String tableName, boolean isTemporary) {
+if (Env.isTableNamesCaseInsensitive()) {
+tableName = tableName.toLowerCase();
+}
+
+if (isTemporary) {
+Set tableSet =
ConnectContext.get().getDbToTempTableNamesMap().get(full
Re: [PR] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2604371937 ClickBench: Total hot run time: 30.97 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a67688672ceec85887fd2b7ad0e7edce3c29e316, data reload: false query1 0.030.030.03 query2 0.080.040.04 query3 0.230.060.06 query4 1.650.080.09 query5 0.410.420.40 query6 1.160.670.66 query7 0.020.010.01 query8 0.060.060.05 query9 0.540.500.50 query10 0.540.570.54 query11 0.160.120.12 query12 0.150.120.12 query13 0.620.610.60 query14 2.722.842.82 query15 0.900.840.84 query16 0.380.380.39 query17 1.060.990.99 query18 0.190.190.21 query19 1.851.792.05 query20 0.020.010.01 query21 15.35 0.980.68 query22 0.770.790.72 query23 14.91 1.460.68 query24 2.190.360.23 query25 0.150.090.08 query26 0.270.180.19 query27 0.080.080.08 query28 13.43 1.250.54 query29 12.66 4.133.44 query30 0.240.070.05 query31 2.820.600.39 query32 3.230.570.49 query33 3.033.023.08 query34 16.64 5.134.54 query35 4.584.524.60 query36 0.610.480.47 query37 0.200.170.16 query38 0.150.150.16 query39 0.050.040.04 query40 0.160.130.14 query41 0.090.050.05 query42 0.070.060.06 query43 0.050.040.04 Total cold run time: 104.5 s Total hot run time: 30.97 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2604357190 TPC-DS: Total hot run time: 194158 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 a67688672ceec85887fd2b7ad0e7edce3c29e316, data reload: false query1 1314970 940 940 query2 6324203019981998 query3 10969 438143274327 query4 60696 32037 23074 23074 query5 5100625 474 474 query6 442 195 188 188 query7 5574520 304 304 query8 330 251 222 222 query9 8154260026142600 query10 437 329 261 261 query11 16073 15085 15228 15085 query12 165 112 113 112 query13 1458547 430 430 query14 11518 750469346934 query15 210 195 193 193 query16 7212635 496 496 query17 1097789 594 594 query18 1897422 309 309 query19 186 182 160 160 query20 113 109 113 109 query21 222 120 101 101 query22 4576451244884488 query23 33807 33522 33281 33281 query24 5552234224162342 query25 481 480 396 396 query26 645 269 151 151 query27 1744486 341 341 query28 4237248524202420 query29 533 569 438 438 query30 216 198 161 161 query31 948 870 832 832 query32 72 60 58 58 query33 412 370 307 307 query34 747 858 521 521 query35 792 840 831 831 query36 10541067980 980 query37 122 128 72 72 query38 4296430541864186 query39 1526150114291429 query40 206 112 104 104 query41 62 50 50 50 query42 113 103 107 103 query43 548 526 485 485 query44 1309821 818 818 query45 185 172 165 165 query46 915 1087669 669 query47 1913191218481848 query48 385 398 334 334 query49 740 485 392 392 query50 648 689 420 420 query51 7013703068906890 query52 100 104 100 100 query53 222 252 184 184 query54 476 529 431 431 query55 84 84 79 79 query56 277 263 260 260 query57 1219115011151115 query58 240 234 232 232 query59 2998315229522952 query60 272 268 256 256 query61 112 110 113 110 query62 724 705 653 653 query63 218 188 192 188 query64 13361040659 659 query65 3270315631353135 query66 678 401 291 291 query67 16060 15888 15557 15557 query68 5315829 526 526 query69 487 296 268 268 query70 1231115211211121 query71 409 282 272 272 query72 6361392039093909 query73 789 755 360 360 query74 10053 917185908590 query75 3188315426972697 query76 38141149779 779 query77 476 359 277 277 query78 10130 10148 97069706 query79 2843809 600 600 query80 1752540 448 448 query81 552 287 233 233 query82 360 148 119 119 query83 316 163 150 150 query84 289 85 71 71 query85 789 353 308 308 query86 429 305 301 301 query87 4341446643944394 query88 352021532153 query89 407 326 296 296 query90 1606187 192 187 query91 130 158 105 105 query92 65 56 51 51 query93 2073879 530 530 query94 766 445 309 309 query95 332 268 264 264 query96 475 611 287 287 query97 2831283827692769 query98 218 212 194 194 query99 1329138412591259 Total cold run time: 311250 ms Total hot run time: 194158 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go
Re: [PR] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2604327172 TPC-H: Total hot run time: 32266 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a67688672ceec85887fd2b7ad0e7edce3c29e316, data reload: false -- Round 1 -- q1 17843 551354545454 q2 2051327 176 176 q3 10564 1226730 730 q4 10231 974 522 522 q5 7796238521292129 q6 194 165 132 132 q7 896 767 606 606 q8 9254133611501150 q9 5292492549004900 q10 6847235018811881 q11 464 276 250 250 q12 337 353 230 230 q13 17771 367430963096 q14 229 227 208 208 q15 529 469 468 468 q16 630 618 586 586 q17 560 863 316 316 q18 7186638463726372 q19 3810971 593 593 q20 299 310 185 185 q21 2740214419681968 q22 374 345 314 314 Total cold run time: 105897 ms Total hot run time: 32266 ms - Round 2, with runtime_filter_mode=off - q1 5696550255085502 q2 242 328 239 239 q3 2263262523182318 q4 1441178313341334 q5 4326472047174717 q6 170 165 128 128 q7 2060198317971797 q8 2615279327232723 q9 7282721973237219 q10 3005327827682768 q11 572 518 500 500 q12 635 746 566 566 q13 3616390433543354 q14 273 301 275 275 q15 512 494 479 479 q16 656 676 656 656 q17 1219176612761276 q18 7744743472477247 q19 794 117410611061 q20 1992202718711871 q21 5722517449804980 q22 638 607 563 563 Total cold run time: 53473 ms Total hot run time: 51573 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2604164796 run performance -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2603902211 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564287554 run p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564166135 ClickBench: Total hot run time: 31.49 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a2d642a6ec8d0d1fa0787e08f47b5a0263a17789, data reload: false query1 0.030.030.03 query2 0.080.040.05 query3 0.240.050.05 query4 1.640.090.09 query5 0.400.410.39 query6 1.150.670.66 query7 0.020.020.02 query8 0.060.040.04 query9 0.570.500.51 query10 0.560.580.56 query11 0.170.120.12 query12 0.150.130.13 query13 0.610.590.61 query14 2.742.722.71 query15 0.910.860.83 query16 0.380.380.38 query17 0.971.041.04 query18 0.190.190.19 query19 1.941.862.08 query20 0.010.010.01 query21 15.35 0.950.66 query22 0.760.790.70 query23 15.00 1.520.67 query24 2.170.370.22 query25 0.140.090.09 query26 0.280.180.17 query27 0.080.080.08 query28 13.45 1.851.14 query29 12.69 4.123.43 query30 0.240.080.05 query31 2.840.590.39 query32 3.230.580.49 query33 3.183.093.10 query34 16.31 5.134.49 query35 4.534.514.49 query36 0.640.480.48 query37 0.190.160.16 query38 0.170.160.14 query39 0.050.040.05 query40 0.180.130.13 query41 0.100.050.05 query42 0.060.050.06 query43 0.050.040.04 Total cold run time: 104.51 s Total hot run time: 31.49 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564164983 TPC-DS: Total hot run time: 196706 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 a2d642a6ec8d0d1fa0787e08f47b5a0263a17789, data reload: false query1 1288974 946 946 query2 6497240822562256 query3 10955 475148524751 query4 33186 23609 25782 23609 query5 4118661 451 451 query6 278 204 185 185 query7 3989477 294 294 query8 298 233 223 223 query9 9583277227482748 query10 459 313 242 242 query11 17689 15420 15272 15272 query12 169 109 112 109 query13 1577555 401 401 query14 10532 683477846834 query15 230 204 191 191 query16 7979646 464 464 query17 1545799 610 610 query18 2081422 330 330 query19 227 197 170 170 query20 133 118 117 117 query21 204 131 110 110 query22 4672448045224480 query23 34456 33715 34286 33715 query24 6561240123182318 query25 441 453 402 402 query26 866 272 155 155 query27 2235481 340 340 query28 5641250124582458 query29 586 605 454 454 query30 216 186 158 158 query31 1010921 884 884 query32 71 61 58 58 query33 475 347 329 329 query34 747 883 529 529 query35 815 831 741 741 query36 10291036984 984 query37 121 106 73 73 query38 4232423041004100 query39 1564144214561442 query40 217 124 114 114 query41 43 45 44 44 query42 122 102 104 102 query43 530 552 508 508 query44 1398848 862 848 query45 190 178 164 164 query46 894 1039662 662 query47 2025201418911891 query48 389 417 330 330 query49 723 476 417 417 query50 654 682 411 411 query51 7386729570997099 query52 106 105 92 92 query53 225 252 188 188 query54 493 535 432 432 query55 84 83 78 78 query56 265 257 252 252 query57 1218122611561156 query58 245 224 227 224 query59 3242344731713171 query60 277 269 259 259 query61 109 106 115 106 query62 867 834 748 748 query63 233 194 201 194 query64 29991086661 661 query65 3324327732493249 query66 862 406 306 306 query67 16411 15930 15537 15537 query68 9388755 524 524 query69 487 304 251 251 query70 1228113111621131 query71 432 286 243 243 query72 5909394438493849 query73 822 752 351 351 query74 9954927288378837 query75 4579316026532653 query76 55761193784 784 query77 1027370 291 291 query78 10757 10218 95239523 query79 3324890 588 588 query80 760 523 441 441 query81 478 270 237 237 query82 230 158 132 132 query83 201 178 143 143 query84 282 92 73 73 query85 756 346 304 304 query86 350 298 313 298 query87 4571459342914291 query88 3600226322242224 query89 437 323 297 297 query90 2067184 189 184 query91 129 138 105 105 query92 66 57 53 53 query93 1427798 530 530 query94 674 405 297 297 query95 334 272 254 254 query96 500 617 283 283 query97 2772280426822682 query98 218 206 204 204 query99 1666160714731473 Total cold run time: 299287 ms Total hot run time: 196706 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564161081 TPC-H: Total hot run time: 32697 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a2d642a6ec8d0d1fa0787e08f47b5a0263a17789, data reload: false -- Round 1 -- q1 17602 612860106010 q2 2054303 179 179 q3 10396 1217755 755 q4 10210 865 458 458 q5 7505217519801980 q6 205 184 152 152 q7 897 753 603 603 q8 9226133711921192 q9 5253490249234902 q10 6758228618501850 q11 475 284 254 254 q12 357 367 222 222 q13 17748 354530113011 q14 235 239 206 206 q15 554 522 492 492 q16 651 617 601 601 q17 592 852 345 345 q18 7244654064286428 q19 1437978 571 571 q20 316 319 192 192 q21 2883225719781978 q22 366 342 316 316 Total cold run time: 102964 ms Total hot run time: 32697 ms - Round 2, with runtime_filter_mode=off - q1 6256618261976182 q2 230 327 251 251 q3 2296271323162316 q4 1388183213841384 q5 4327484247494749 q6 192 178 147 147 q7 2111196118381838 q8 2603283826962696 q9 7259727073677270 q10 3093335328832883 q11 583 518 497 497 q12 660 742 643 643 q13 3422375631743174 q14 311 304 277 277 q15 572 518 512 512 q16 673 689 636 636 q17 1226176412591259 q18 7721750672477247 q19 874 114711451145 q20 1962203019281928 q21 5713535449834983 q22 634 605 593 593 Total cold run time: 54106 ms Total hot run time: 52610 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564157047 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2564145645 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563745432 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563588760 run feut -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563583170 ClickBench: Total hot run time: 31.67 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 78a93210171a3a3267ccedc083bb36ac6dd0dcf8, data reload: false query1 0.040.030.03 query2 0.090.040.04 query3 0.230.050.05 query4 1.650.080.09 query5 0.430.410.41 query6 1.150.660.65 query7 0.020.020.02 query8 0.050.040.04 query9 0.550.500.49 query10 0.550.560.55 query11 0.170.120.12 query12 0.160.130.13 query13 0.610.610.60 query14 2.832.742.83 query15 0.920.840.84 query16 0.380.360.38 query17 1.091.051.06 query18 0.190.180.18 query19 1.952.011.87 query20 0.020.010.01 query21 15.35 0.960.67 query22 0.760.770.69 query23 15.03 1.550.69 query24 2.220.360.23 query25 0.130.080.09 query26 0.300.180.18 query27 0.090.070.07 query28 13.42 1.831.11 query29 12.61 4.113.47 query30 0.240.080.07 query31 2.840.600.40 query32 3.230.580.48 query33 3.163.073.07 query34 16.72 5.164.56 query35 4.554.574.53 query36 0.620.480.50 query37 0.210.170.17 query38 0.160.150.15 query39 0.050.050.04 query40 0.170.130.12 query41 0.100.060.06 query42 0.060.050.05 query43 0.050.050.04 Total cold run time: 105.15 s Total hot run time: 31.67 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] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563578966 TPC-DS: Total hot run time: 199138 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 78a93210171a3a3267ccedc083bb36ac6dd0dcf8, data reload: false query1 1300977 932 932 query2 6318251822622262 query3 11121 503149074907 query4 33084 23656 23543 23543 query5 4313620 449 449 query6 294 204 181 181 query7 3995500 313 313 query8 319 265 243 243 query9 9539276427842764 query10 468 304 259 259 query11 18076 15615 15315 15315 query12 170 108 109 108 query13 1631549 406 406 query14 11524 744478077444 query15 260 211 196 196 query16 8096674 514 514 query17 1549798 617 617 query18 2145428 334 334 query19 244 187 157 157 query20 123 116 117 116 query21 201 125 107 107 query22 4577451245024502 query23 34665 33888 33599 33599 query24 6485242523842384 query25 506 447 388 388 query26 910 277 151 151 query27 2191468 338 338 query28 5371252124922492 query29 673 566 430 430 query30 217 208 153 153 query31 986 953 864 864 query32 93 61 60 60 query33 515 375 313 313 query34 773 860 510 510 query35 808 838 755 755 query36 10301077970 970 query37 118 100 77 77 query38 4343423042334230 query39 1508148514591459 query40 207 117 101 101 query41 48 46 41 41 query42 116 103 107 103 query43 528 540 510 510 query44 1404849 842 842 query45 185 177 171 171 query46 877 1076674 674 query47 1977201319451945 query48 393 401 322 322 query49 721 482 382 382 query50 635 701 408 408 query51 7285725972327232 query52 105 101 97 97 query53 230 252 190 190 query54 482 493 408 408 query55 83 83 83 83 query56 257 245 228 228 query57 1279125011761176 query58 246 231 214 214 query59 3404351934953495 query60 277 267 258 258 query61 111 104 107 104 query62 859 840 763 763 query63 240 201 195 195 query64 37701044665 665 query65 3403325932873259 query66 799 411 303 303 query67 16539 15800 15513 15513 query68 9842756 503 503 query69 472 299 252 252 query70 1232114511481145 query71 440 297 252 252 query72 6216389438483848 query73 660 761 376 376 query74 10164 905393439053 query75 4414310826712671 query76 50711208824 824 query77 925 377 283 283 query78 10205 10331 10449 10331 query79 2892850 612 612 query80 747 529 424 424 query81 495 277 224 224 query82 484 147 122 122 query83 195 156 160 156 query84 280 97 78 78 query85 790 387 315 315 query86 390 317 302 302 query87 4382456744044404 query88 4581222721782178 query89 423 325 296 296 query90 1830190 191 190 query91 137 136 106 106 query92 64 57 52 52 query93 1391832 524 524 query94 642 411 290 290 query95 332 261 254 254 query96 482 611 293 293 query97 2775281326322632 query98 228 228 197 197 query99 1799151514271427 Total cold run time: 301979 ms Total hot run time: 199138 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go
Re: [PR] [feature](schema) support temporary table like mysql [doris]
doris-robot commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563569637 TPC-H: Total hot run time: 32695 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 78a93210171a3a3267ccedc083bb36ac6dd0dcf8, data reload: false -- Round 1 -- q1 17582 615460706070 q2 2055306 171 171 q3 10416 1240743 743 q4 10210 903 432 432 q5 7553223019821982 q6 211 185 147 147 q7 921 740 611 611 q8 9244141612091209 q9 5405499249354935 q10 6769234618741874 q11 494 274 267 267 q12 353 367 217 217 q13 17760 362030103010 q14 235 237 230 230 q15 577 508 498 498 q16 631 617 586 586 q17 567 863 326 326 q18 7170652963536353 q19 38301005598 598 q20 294 316 183 183 q21 2807217219441944 q22 368 342 309 309 Total cold run time: 105452 ms Total hot run time: 32695 ms - Round 2, with runtime_filter_mode=off - q1 6454624362826243 q2 236 332 235 235 q3 2294269323402340 q4 1449190514031403 q5 4364476848964768 q6 177 176 145 145 q7 2156201118491849 q8 2649282427092709 q9 7264738773537353 q10 3125337227252725 q11 583 514 508 508 q12 691 808 607 607 q13 3454385131213121 q14 280 315 271 271 q15 569 512 517 512 q16 662 712 657 657 q17 1225176312561256 q18 7885759475367536 q19 842 118610921092 q20 1989205419111911 q21 5878507750705070 q22 665 643 587 587 Total cold run time: 54891 ms Total hot run time: 52898 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2563478568 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2426478027 run cloud_p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2426398830 run cloud_p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2426011822 run external -- This is an automated message 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2426011313 run cloud_p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2425850239 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2425684550 run p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2425683561 run cloud_p0 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2425584638 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2424691587 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2422318623 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] [feature](schema) support temporary table like mysql [doris]
Yulei-Yang commented on PR #40680: URL: https://github.com/apache/doris/pull/40680#issuecomment-2406891207 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]
