Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
starocean999 merged PR #50695: URL: https://github.com/apache/doris/pull/50695 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
github-actions[bot] commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2920972337 PR approved by at least one committer and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
github-actions[bot] commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2920972360 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918299092 TPC-H: Total hot run time: 33833 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 862956108087d271334b8310a0e695cfb66ff8d4, data reload: false -- Round 1 -- q1 26120 503351225033 q2 2076285 185 185 q3 10534 1234694 694 q4 10230 993 523 523 q5 7702235923452345 q6 178 162 130 130 q7 902 751 617 617 q8 9317128810911091 q9 6779507851375078 q10 6879229919071907 q11 505 289 276 276 q12 342 354 210 210 q13 17779 368031083108 q14 224 232 221 221 q15 528 476 475 475 q16 435 434 377 377 q17 602 855 375 375 q18 7521723770567056 q19 2057962 545 545 q20 347 335 224 224 q21 3698259523662366 q22 10511021997 997 Total cold run time: 115806 ms Total hot run time: 33833 ms - Round 2, with runtime_filter_mode=off - q1 5229507651215076 q2 245 315 232 232 q3 2161266322702270 q4 1348174914001400 q5 4464437544134375 q6 218 180 134 134 q7 2011196017731773 q8 2552263226042604 q9 7153717569486948 q10 3039319927652765 q11 558 510 487 487 q12 684 743 630 630 q13 3492390332853285 q14 284 300 271 271 q15 535 495 503 495 q16 458 510 433 433 q17 1155143614501436 q18 7757757375697569 q19 808 791 821 791 q20 1993203018341834 q21 4740439544874395 q22 1158107610041004 Total cold run time: 52042 ms Total hot run time: 50207 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918321058 ClickBench: Total hot run time: 29.28 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 862956108087d271334b8310a0e695cfb66ff8d4, data reload: false query1 0.040.040.03 query2 0.130.110.11 query3 0.270.200.19 query4 1.590.190.18 query5 0.450.460.45 query6 1.160.660.65 query7 0.020.010.02 query8 0.040.030.04 query9 0.590.520.51 query10 0.560.570.57 query11 0.160.110.11 query12 0.150.120.11 query13 0.610.600.60 query14 0.780.830.80 query15 0.860.840.87 query16 0.390.380.38 query17 1.041.031.02 query18 0.230.210.22 query19 2.001.811.84 query20 0.010.020.01 query21 15.40 0.890.55 query22 0.771.210.79 query23 14.75 1.380.62 query24 7.470.890.90 query25 0.480.140.15 query26 0.600.170.13 query27 0.050.050.05 query28 8.940.870.43 query29 12.53 3.983.31 query30 0.250.100.06 query31 2.840.630.39 query32 3.240.570.47 query33 3.083.253.06 query34 15.82 5.084.46 query35 4.514.524.50 query36 0.680.510.49 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.030.02 query40 0.160.130.14 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.030.03 Total cold run time: 102.96 s Total hot run time: 29.28 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918314626 TPC-DS: Total hot run time: 193304 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 862956108087d271334b8310a0e695cfb66ff8d4, data reload: false query1 1395110510681068 query2 6149187018491849 query3 11064 456546484565 query4 54189 25626 23308 23308 query5 5159574 470 470 query6 369 234 201 201 query7 4875508 301 301 query8 293 250 218 218 query9 5704265326482648 query10 399 339 282 282 query11 15172 15101 14905 14905 query12 160 105 105 105 query13 1040535 426 426 query14 10557 640863406340 query15 211 209 181 181 query16 7150669 479 479 query17 1076727 573 573 query18 1608405 319 319 query19 207 187 173 173 query20 132 122 119 119 query21 203 130 109 109 query22 4376438943004300 query23 34197 33819 33698 33698 query24 6551241924372419 query25 462 483 411 411 query26 709 277 154 154 query27 2329522 342 342 query28 3176220121842184 query29 587 559 442 442 query30 269 214 185 185 query31 854 833 764 764 query32 70 63 59 59 query33 461 370 360 360 query34 777 892 544 544 query35 786 819 750 750 query36 966 1006913 913 query37 117 101 75 75 query38 4221438742504250 query39 1527146414461446 query40 204 125 112 112 query41 60 60 62 60 query42 135 121 124 121 query43 543 524 502 502 query44 1324852 837 837 query45 196 175 172 172 query46 867 1061665 665 query47 1845186117781778 query48 388 437 316 316 query49 687 509 430 430 query50 667 706 414 414 query51 4237428441614161 query52 119 106 99 99 query53 236 261 188 188 query54 592 578 531 531 query55 82 87 79 79 query56 314 303 293 293 query57 1188114910891089 query58 266 280 276 276 query59 2775292327842784 query60 341 334 335 334 query61 122 127 151 127 query62 737 751 677 677 query63 229 198 191 191 query64 18061141738 738 query65 4291427342834273 query66 747 405 309 309 query67 15980 15807 15219 15219 query68 6406891 532 532 query69 547 301 263 263 query70 11491114 query71 472 329 307 307 query72 5954478650934786 query73 1308663 362 362 query74 9060926790339033 query75 3625329027142714 query76 40541189764 764 query77 700 373 296 296 query78 10199 10183 93519351 query79 2666831 587 587 query80 664 507 458 458 query81 486 257 218 218 query82 557 126 95 95 query83 242 252 231 231 query84 301 111 93 93 query85 765 344 303 303 query86 363 300 284 284 query87 4392438842944294 query88 3506231223332312 query89 417 307 289 289 query90 1718215 222 215 query91 150 146 111 111 query92 75 64 57 57 query93 2368947 584 584 query94 726 390 273 273 query95 358 296 288 288 query96 500 571 286 286 query97 2691275226292629 query98 239 210 205 205 query99 1331139312631263 Total cold run time: 298514 ms Total hot run time: 193304 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918125940 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918055113 ClickBench: Total hot run time: 28.78 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d90620ed78dc2b1693638d736d5c25449a20a498, data reload: false query1 0.040.040.03 query2 0.130.100.11 query3 0.250.200.19 query4 1.600.190.19 query5 0.460.420.47 query6 1.160.670.66 query7 0.020.020.02 query8 0.040.040.03 query9 0.580.520.53 query10 0.580.580.55 query11 0.160.110.11 query12 0.150.120.12 query13 0.620.600.60 query14 0.790.820.83 query15 0.880.860.88 query16 0.380.380.37 query17 1.071.041.02 query18 0.220.210.21 query19 1.951.851.88 query20 0.020.010.01 query21 15.40 0.930.54 query22 0.751.160.81 query23 14.78 1.370.64 query24 7.761.140.32 query25 0.300.110.14 query26 0.710.170.13 query27 0.050.060.05 query28 8.410.910.44 query29 12.55 4.063.36 query30 0.250.100.06 query31 2.820.600.40 query32 3.240.560.46 query33 3.013.083.03 query34 15.80 5.084.44 query35 4.514.534.52 query36 0.660.490.49 query37 0.080.060.07 query38 0.050.040.04 query39 0.030.020.02 query40 0.170.120.13 query41 0.090.030.02 query42 0.030.030.02 query43 0.030.030.02 Total cold run time: 102.58 s Total hot run time: 28.78 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918048489 TPC-DS: Total hot run time: 193365 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 d90620ed78dc2b1693638d736d5c25449a20a498, data reload: false query1 1453108310781078 query2 6331180418091804 query3 11013 454046664540 query4 55238 25990 23234 23234 query5 5042541 466 466 query6 341 208 214 208 query7 4879527 288 288 query8 277 235 225 225 query9 5363263126492631 query10 453 334 266 266 query11 15183 15022 14832 14832 query12 162 117 106 106 query13 1040512 400 400 query14 10113 639163466346 query15 206 196 174 174 query16 7165649 484 484 query17 1097768 556 556 query18 1678418 303 303 query19 197 187 164 164 query20 127 135 124 124 query21 203 123 106 106 query22 4449443244044404 query23 34218 33576 33460 33460 query24 6570243324682433 query25 467 463 410 410 query26 689 287 156 156 query27 2261503 361 361 query28 3030217821682168 query29 581 562 440 440 query30 270 216 190 190 query31 890 887 789 789 query32 79 71 68 68 query33 440 368 342 342 query34 792 860 550 550 query35 786 834 749 749 query36 939 1004908 908 query37 112 108 82 82 query38 4175432243384322 query39 1553147014701470 query40 224 129 110 110 query41 62 58 56 56 query42 122 114 109 109 query43 501 513 484 484 query44 1343845 851 845 query45 223 175 169 169 query46 855 1041650 650 query47 1838186818121812 query48 408 441 328 328 query49 651 515 384 384 query50 646 706 423 423 query51 4262430142174217 query52 111 114 101 101 query53 242 254 187 187 query54 589 590 520 520 query55 87 93 84 84 query56 336 303 313 303 query57 1190117911571157 query58 271 267 268 267 query59 2724279927362736 query60 342 362 329 329 query61 154 151 155 151 query62 765 729 697 697 query63 229 202 196 196 query64 18201156669 669 query65 4307421042254210 query66 723 429 308 308 query67 16081 15857 15421 15421 query68 7532864 516 516 query69 544 318 270 270 query70 1189110510891089 query71 473 322 300 300 query72 5814477048694770 query73 1330641 356 356 query74 8962911989138913 query75 3705320527452745 query76 41201205748 748 query77 616 373 289 289 query78 10326 10356 95559555 query79 2066815 579 579 query80 585 533 522 522 query81 481 251 227 227 query82 473 128 104 104 query83 262 243 237 237 query84 288 114 88 88 query85 794 341 308 308 query86 388 291 277 277 query87 4408439842904290 query88 3822226922732269 query89 409 324 282 282 query90 1886217 202 202 query91 140 142 189 142 query92 74 60 57 57 query93 1494915 587 587 query94 681 410 313 313 query95 373 293 291 291 query96 486 568 279 279 query97 2752281227132713 query98 226 213 207 207 query99 1397138612801280 Total cold run time: 299064 ms Total hot run time: 193365 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2918029751 TPC-H: Total hot run time: 33632 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d90620ed78dc2b1693638d736d5c25449a20a498, data reload: false -- Round 1 -- q1 26153 501349894989 q2 2061270 177 177 q3 10424 1213697 697 q4 10223 983 516 516 q5 7560228823212288 q6 176 158 129 129 q7 872 752 620 620 q8 9313128210641064 q9 6911510650735073 q10 6791230118631863 q11 477 288 274 274 q12 342 343 209 209 q13 17786 371130973097 q14 232 226 219 219 q15 533 513 482 482 q16 432 440 382 382 q17 600 839 362 362 q18 7504722971147114 q19 1441928 563 563 q20 328 328 222 222 q21 3834308423292329 q22 10191036963 963 Total cold run time: 115012 ms Total hot run time: 33632 ms - Round 2, with runtime_filter_mode=off - q1 5107505550625055 q2 239 324 231 231 q3 2184266022882288 q4 1354177713671367 q5 4402432643844326 q6 221 173 131 131 q7 1989191417431743 q8 2576258525792579 q9 7196719469796979 q10 3069317127412741 q11 578 526 502 502 q12 693 748 626 626 q13 3430388933013301 q14 284 290 292 290 q15 520 479 470 470 q16 465 495 463 463 q17 1164159313651365 q18 7681749573027302 q19 780 758 925 758 q20 2048204119201920 q21 4806447643694369 q22 10521033994 994 Total cold run time: 51838 ms Total hot run time: 49800 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2917977146 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916940511 ClickBench: Total hot run time: 28.89 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 107fe6422c256d814f8dfad9b5c59613ffc61d2d, data reload: false query1 0.040.030.04 query2 0.120.100.11 query3 0.260.180.19 query4 1.590.200.20 query5 0.440.430.44 query6 1.450.660.65 query7 0.020.010.01 query8 0.040.040.04 query9 0.590.530.53 query10 0.580.560.56 query11 0.160.110.11 query12 0.140.110.12 query13 0.610.590.59 query14 0.790.800.82 query15 0.870.860.85 query16 0.380.380.38 query17 1.031.011.01 query18 0.220.210.21 query19 1.901.801.80 query20 0.010.020.01 query21 15.40 0.890.56 query22 0.771.150.64 query23 15.06 1.370.64 query24 6.481.900.63 query25 0.520.240.09 query26 0.570.170.14 query27 0.050.050.05 query28 9.370.880.43 query29 12.53 4.023.33 query30 0.260.100.06 query31 2.820.590.38 query32 3.230.540.46 query33 3.113.003.05 query34 15.84 5.134.54 query35 4.594.574.54 query36 0.660.500.49 query37 0.080.060.06 query38 0.050.040.03 query39 0.030.020.03 query40 0.170.140.12 query41 0.080.030.03 query42 0.040.030.02 query43 0.040.040.03 Total cold run time: 102.99 s Total hot run time: 28.89 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916925275 TPC-DS: Total hot run time: 185601 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 107fe6422c256d814f8dfad9b5c59613ffc61d2d, data reload: false query1 998 481 487 481 query2 6565184817701770 query3 6765222 225 222 query4 26340 23109 23041 23041 query5 4369611 476 476 query6 293 207 213 207 query7 4616501 290 290 query8 267 210 220 210 query9 8593261326352613 query10 483 333 285 285 query11 15845 15077 14762 14762 query12 173 109 116 109 query13 1669554 416 416 query14 10260 613060766076 query15 205 204 178 178 query16 7658626 488 488 query17 1353721 594 594 query18 2016397 300 300 query19 193 191 171 171 query20 122 124 120 120 query21 212 138 109 109 query22 4127435941464146 query23 34122 33125 33029 33029 query24 8260237923862379 query25 587 456 396 396 query26 1222276 155 155 query27 2691497 343 343 query28 4290213121082108 query29 720 602 429 429 query30 279 214 187 187 query31 950 853 778 778 query32 71 65 62 62 query33 550 390 316 316 query34 791 841 525 525 query35 780 804 738 738 query36 948 1004865 865 query37 103 104 80 80 query38 4117405339983998 query39 1503141114191411 query40 204 120 105 105 query41 64 56 55 55 query42 123 117 114 114 query43 491 500 478 478 query44 1313845 819 819 query45 175 174 166 166 query46 832 1018636 636 query47 1763178517011701 query48 394 417 311 311 query49 739 493 394 394 query50 629 692 396 396 query51 4046420641334133 query52 107 106 98 98 query53 224 247 203 203 query54 576 573 506 506 query55 87 83 87 83 query56 299 318 293 293 query57 1125112610591059 query58 264 259 254 254 query59 2569266426702664 query60 320 341 304 304 query61 129 133 130 130 query62 800 698 655 655 query63 219 188 184 184 query64 42581004687 687 query65 4321423142374231 query66 1065410 310 310 query67 15786 15723 15393 15393 query68 8751887 524 524 query69 461 324 266 266 query70 1169111710331033 query71 511 329 300 300 query72 5651475848664758 query73 703 630 359 359 query74 8986905789958995 query75 4020321026682668 query76 37061176752 752 query77 784 373 298 298 query78 10187 10243 92979297 query79 1843833 573 573 query80 601 547 453 453 query81 477 245 223 223 query82 444 124 93 93 query83 274 250 238 238 query84 241 111 94 94 query85 825 356 321 321 query86 341 299 252 252 query87 4497439443554355 query88 3532230123042301 query89 394 311 287 287 query90 1949214 205 205 query91 143 156 121 121 query92 71 65 56 56 query93 1474941 581 581 query94 668 406 283 283 query95 369 296 285 285 query96 497 565 285 285 query97 2713279326122612 query98 237 216 202 202 query99 1452138613061306 Total cold run time: 275999 ms Total hot run time: 185601 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916893163 TPC-H: Total hot run time: 33861 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 107fe6422c256d814f8dfad9b5c59613ffc61d2d, data reload: false -- Round 1 -- q1 26167 503350075007 q2 2064275 187 187 q3 10383 1213694 694 q4 10252 1000520 520 q5 7556229623702296 q6 177 162 135 135 q7 898 754 615 615 q8 9315132612041204 q9 6983511350915091 q10 6874231818741874 q11 489 289 270 270 q12 348 352 214 214 q13 17787 363730773077 q14 224 227 214 214 q15 545 489 483 483 q16 420 430 380 380 q17 580 864 370 370 q18 7820715671067106 q19 22341091545 545 q20 339 343 231 231 q21 3689253923642364 q22 10441023984 984 Total cold run time: 116188 ms Total hot run time: 33861 ms - Round 2, with runtime_filter_mode=off - q1 5203504350565043 q2 242 324 229 229 q3 2157264622712271 q4 1353178113611361 q5 4243412841044104 q6 205 165 124 124 q7 1900178616761676 q8 2509242924002400 q9 6827680467626762 q10 2881306626262626 q11 554 492 480 480 q12 638 706 564 564 q13 3360365831003100 q14 263 279 258 258 q15 518 468 457 457 q16 433 476 421 421 q17 1102150412991299 q18 7224721771137113 q19 762 774 895 774 q20 1972193418081808 q21 4797436342734273 q22 10711038995 995 Total cold run time: 50214 ms Total hot run time: 48138 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916836905 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916825801 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916825199 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916744335 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916687678 ClickBench: Total hot run time: 29.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit fe54f7297eda8c16d723cecf86616c2c99314f5a, data reload: false query1 0.040.040.04 query2 0.120.100.13 query3 0.250.180.19 query4 1.590.190.18 query5 0.460.440.43 query6 1.150.660.65 query7 0.020.020.02 query8 0.040.040.03 query9 0.580.510.53 query10 0.560.570.57 query11 0.150.110.10 query12 0.140.120.11 query13 0.620.600.59 query14 0.800.800.83 query15 0.870.840.84 query16 0.370.390.39 query17 1.031.021.00 query18 0.220.200.20 query19 1.961.781.79 query20 0.010.010.01 query21 15.39 0.870.56 query22 0.751.010.73 query23 15.02 1.350.60 query24 6.781.191.14 query25 0.510.170.09 query26 0.560.160.15 query27 0.050.050.04 query28 9.290.890.45 query29 12.56 3.973.33 query30 0.250.090.06 query31 2.850.590.38 query32 3.230.540.46 query33 3.013.073.07 query34 15.79 5.194.49 query35 4.574.574.55 query36 0.650.490.48 query37 0.090.070.06 query38 0.050.040.03 query39 0.030.020.02 query40 0.170.140.13 query41 0.070.020.02 query42 0.030.020.02 query43 0.030.030.02 Total cold run time: 102.71 s Total hot run time: 29.41 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916667533 TPC-DS: Total hot run time: 192498 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 fe54f7297eda8c16d723cecf86616c2c99314f5a, data reload: false query1 1410110210731073 query2 6273182418261824 query3 11137 458144724472 query4 54524 25283 23242 23242 query5 5129582 466 466 query6 349 219 197 197 query7 4875510 306 306 query8 275 235 227 227 query9 5437260826072607 query10 434 343 292 292 query11 15264 15153 14813 14813 query12 153 108 102 102 query13 1014515 404 404 query14 10070 620361986198 query15 207 192 181 181 query16 7078668 523 523 query17 1076742 565 565 query18 1561418 301 301 query19 230 183 166 166 query20 130 125 117 117 query21 207 128 106 106 query22 4454456343744374 query23 33986 33471 33495 33471 query24 6538240923722372 query25 467 485 420 420 query26 682 277 156 156 query27 2332506 342 342 query28 2888217321412141 query29 612 610 437 437 query30 274 215 191 191 query31 868 856 767 767 query32 67 61 63 61 query33 467 378 323 323 query34 777 876 540 540 query35 793 816 763 763 query36 936 1016885 885 query37 117 104 78 78 query38 4258427341724172 query39 1533147014761470 query40 211 120 111 111 query41 61 62 61 61 query42 142 116 120 116 query43 521 501 481 481 query44 1337838 849 838 query45 183 177 169 169 query46 862 1037648 648 query47 1835191618471847 query48 424 429 328 328 query49 653 529 403 403 query50 662 708 414 414 query51 4159425942174217 query52 107 116 108 108 query53 230 263 187 187 query54 596 568 524 524 query55 87 87 89 87 query56 312 293 303 293 query57 1208118211601160 query58 285 280 264 264 query59 2686283827152715 query60 346 359 339 339 query61 157 155 153 153 query62 771 754 677 677 query63 239 205 196 196 query64 17771030679 679 query65 4336425941904190 query66 726 411 312 312 query67 16025 15514 15395 15395 query68 6582881 524 524 query69 539 307 264 264 query70 1164109510781078 query71 505 317 306 306 query72 5997490550124905 query73 1514752 360 360 query74 8844924388838883 query75 4056319927122712 query76 42321205771 771 query77 745 363 280 280 query78 10026 10175 93349334 query79 5558806 563 563 query80 660 535 452 452 query81 486 253 222 222 query82 601 130 96 96 query83 298 244 235 235 query84 288 110 95 95 query85 819 362 346 346 query86 332 319 276 276 query87 4362442942254225 query88 3315228722802280 query89 444 318 286 286 query90 1983216 208 208 query91 162 139 125 125 query92 74 61 56 56 query93 2674924 574 574 query94 674 412 308 308 query95 378 290 287 287 query96 490 575 277 277 query97 2743281626432643 query98 224 213 198 198 query99 1436142312721272 Total cold run time: 302025 ms Total hot run time: 192498 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916626113 TPC-H: Total hot run time: 34441 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit fe54f7297eda8c16d723cecf86616c2c99314f5a, data reload: false -- Round 1 -- q1 25839 501850235018 q2 2065276 182 182 q3 10417 1244725 725 q4 10225 999 545 545 q5 7508234523022302 q6 178 166 131 131 q7 904 726 615 615 q8 9301125911061106 q9 6852512051325120 q10 6858228118901890 q11 503 284 265 265 q12 339 350 216 216 q13 17751 368730923092 q14 230 225 210 210 q15 540 496 502 496 q16 427 425 365 365 q17 577 862 360 360 q18 7515715470447044 q19 1680973 545 545 q20 351 337 221 221 q21 4077319530403040 q22 10751037953 953 Total cold run time: 115212 ms Total hot run time: 34441 ms - Round 2, with runtime_filter_mode=off - q1 5162509551205095 q2 234 317 238 238 q3 2172262723022302 q4 1366177913731373 q5 4413432944014329 q6 255 168 131 131 q7 1992191217731773 q8 2587259825202520 q9 7177715869076907 q10 3002316027572757 q11 580 520 496 496 q12 670 749 621 621 q13 3551400132553255 q14 286 285 297 285 q15 522 485 494 485 q16 434 502 469 469 q17 1125154714091409 q18 7619750475687504 q19 842 805 837 805 q20 1982204318381838 q21 4884464644724472 q22 1101103010261026 Total cold run time: 51956 ms Total hot run time: 50090 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916497038 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916430945 run p0 regression -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916415418 run p0 regression -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2916272561 run p0 regression -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2915660579 run p0 regression -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2914824945 ClickBench: Total hot run time: 29.18 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 125af60815f39d2e5a42fd14dd990d26d82d9027, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.260.180.19 query4 1.590.200.11 query5 0.430.390.43 query6 1.170.660.66 query7 0.020.010.02 query8 0.040.040.03 query9 0.570.530.51 query10 0.570.580.57 query11 0.160.110.11 query12 0.150.110.12 query13 0.610.610.58 query14 0.790.820.82 query15 0.870.840.86 query16 0.380.380.38 query17 1.041.011.01 query18 0.220.210.21 query19 1.901.901.86 query20 0.020.010.01 query21 15.39 0.880.59 query22 0.741.180.75 query23 14.90 1.370.65 query24 7.261.650.84 query25 0.500.270.06 query26 0.580.160.14 query27 0.060.050.04 query28 9.180.880.43 query29 12.55 4.003.30 query30 0.250.090.07 query31 2.840.590.39 query32 3.230.550.47 query33 3.063.163.10 query34 15.84 5.184.51 query35 4.614.564.50 query36 0.680.510.49 query37 0.080.060.06 query38 0.050.040.03 query39 0.030.030.03 query40 0.160.130.13 query41 0.070.030.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.08 s Total hot run time: 29.18 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2914815172 TPC-DS: Total hot run time: 192371 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 125af60815f39d2e5a42fd14dd990d26d82d9027, data reload: false query1 1398111910871087 query2 6223181418141814 query3 11123 468647604686 query4 25357 23352 23052 23052 query5 3525619 475 475 query6 289 213 202 202 query7 3990481 288 288 query8 306 253 227 227 query9 8467260426012601 query10 435 312 262 262 query11 15716 15014 14815 14815 query12 174 114 111 111 query13 1558561 446 446 query14 9245617160796079 query15 203 185 182 182 query16 7264622 504 504 query17 1196706 591 591 query18 2009434 334 334 query19 213 213 172 172 query20 128 138 121 121 query21 210 128 110 110 query22 4442454243484348 query23 35090 34026 33561 33561 query24 8405245724202420 query25 521 467 403 403 query26 728 275 163 163 query27 2668522 354 354 query28 4661224721812181 query29 669 587 469 469 query30 272 216 190 190 query31 895 883 780 780 query32 77 68 65 65 query33 535 380 310 310 query34 824 901 550 550 query35 838 844 763 763 query36 965 1014890 890 query37 122 103 80 80 query38 4335430342104210 query39 1519145614591456 query40 208 119 131 119 query41 56 56 52 52 query42 119 110 118 110 query43 514 518 479 479 query44 1340846 838 838 query45 180 176 167 167 query46 867 1021638 638 query47 1818191017641764 query48 398 435 334 334 query49 710 551 429 429 query50 671 695 406 406 query51 4211438641994199 query52 113 111 105 105 query53 226 256 187 187 query54 596 580 514 514 query55 86 82 84 82 query56 295 299 319 299 query57 1180121511051105 query58 275 264 276 264 query59 2728286527262726 query60 342 312 320 312 query61 131 137 122 122 query62 788 718 659 659 query63 227 189 193 189 query64 32711082714 714 query65 4415434043634340 query66 996 413 306 306 query67 16070 15675 15453 15453 query68 8362924 520 520 query69 503 303 275 275 query70 1222117510471047 query71 475 323 304 304 query72 5415478949144789 query73 714 642 362 362 query74 8885927387628762 query75 3997319026962696 query76 37011181744 744 query77 811 380 289 289 query78 10136 10228 92559255 query79 2410827 569 569 query80 683 505 433 433 query81 487 258 226 226 query82 485 126 99 99 query83 253 253 240 240 query84 250 108 93 93 query85 832 362 317 317 query86 382 286 275 275 query87 4428444143184318 query88 3846229222552255 query89 414 331 273 273 query90 1892206 200 200 query91 146 144 118 118 query92 70 62 57 57 query93 1852977 573 573 query94 616 400 305 305 query95 370 293 294 293 query96 493 573 276 276 query97 2735279026722672 query98 235 206 211 206 query99 1353140212661266 Total cold run time: 277879 ms Total hot run time: 192371 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2914796000 TPC-H: Total hot run time: 33841 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 125af60815f39d2e5a42fd14dd990d26d82d9027, data reload: false -- Round 1 -- q1 26462 502652965026 q2 2085306 202 202 q3 10437 1269712 712 q4 10230 1007514 514 q5 7574233723692337 q6 182 162 133 133 q7 898 761 622 622 q8 9322133211361136 q9 6851512450915091 q10 6868233118611861 q11 484 293 273 273 q12 341 353 209 209 q13 17763 361730823082 q14 235 235 222 222 q15 537 487 488 487 q16 421 428 374 374 q17 615 862 364 364 q18 7661720071037103 q19 1818967 555 555 q20 319 333 224 224 q21 3733313723512351 q22 10781058963 963 Total cold run time: 115914 ms Total hot run time: 33841 ms - Round 2, with runtime_filter_mode=off - q1 5221508950665066 q2 250 328 235 235 q3 2197265422492249 q4 1363186114401440 q5 4459442343814381 q6 256 168 126 126 q7 2012195917511751 q8 2608257325282528 q9 7285704872837048 q10 3017317127592759 q11 589 539 511 511 q12 688 734 615 615 q13 3482379833853385 q14 282 309 284 284 q15 515 484 472 472 q16 486 492 460 460 q17 1151149213931393 q18 7819765673577357 q19 813 851 890 851 q20 1896197118581858 q21 4897447544804475 q22 105710761057 Total cold run time: 52397 ms Total hot run time: 50301 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2914623724 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
starocean999 commented on code in PR #50695:
URL: https://github.com/apache/doris/pull/50695#discussion_r2110670586
##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowTransactionCommand.java:
##
@@ -0,0 +1,180 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.DatabaseIf;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.common.AnalysisException;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.common.proc.TransProcDir;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.analyzer.UnboundSlot;
+import org.apache.doris.nereids.trees.expressions.EqualTo;
+import org.apache.doris.nereids.trees.expressions.Expression;
+import org.apache.doris.nereids.trees.expressions.Like;
+import org.apache.doris.nereids.trees.expressions.literal.IntegerLikeLiteral;
+import org.apache.doris.nereids.trees.expressions.literal.StringLikeLiteral;
+import org.apache.doris.nereids.trees.expressions.literal.StringLiteral;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.ShowResultSetMetaData;
+import org.apache.doris.qe.StmtExecutor;
+import org.apache.doris.transaction.GlobalTransactionMgrIface;
+import org.apache.doris.transaction.TransactionStatus;
+
+import com.google.common.base.Strings;
+
+/**
+ * ShowTransactionCommand
+ */
+public class ShowTransactionCommand extends ShowCommand {
+
+private String dbName;
+private Expression expr;
+private long txnId = -1;
+private String label = "";
+private TransactionStatus status = TransactionStatus.UNKNOWN;
+private boolean labelMatch = false;
+
+public ShowTransactionCommand(String dbName, Expression whereClause) {
+super(PlanType.SHOW_TRANSACTION_COMMAND);
+this.dbName = dbName;
+this.expr = whereClause;
+}
+
+public String getDbName() {
+return dbName;
+}
+
+public long getTxnId() {
+return txnId;
+}
+
+public String getLabel() {
+return label;
+}
+
+@Override
+public ShowResultSet doRun(ConnectContext ctx, StmtExecutor executor)
throws Exception {
+validate(ctx);
+return handleShowTransaction(ctx);
+}
+
+private ShowResultSet handleShowTransaction(ConnectContext ctx) throws
AnalysisException {
+DatabaseIf db =
ctx.getEnv().getInternalCatalog().getDbOrAnalysisException(dbName);
+GlobalTransactionMgrIface transactionMgr =
Env.getCurrentGlobalTransactionMgr();
+ShowResultSet resultSet;
+if (status != TransactionStatus.UNKNOWN) {
+resultSet = new ShowResultSet(getMetaData(),
transactionMgr.getDbTransInfoByStatus(db.getId(), status));
+} else if (labelMatch && !label.isEmpty()) {
+resultSet = new ShowResultSet(getMetaData(),
transactionMgr.getDbTransInfoByLabelMatch(db.getId(), label));
+} else {
+if (!label.isEmpty()) {
+txnId = transactionMgr.getTransactionId(db.getId(), label);
+if (txnId == -1) {
+throw new AnalysisException("transaction with label " +
label + " does not exist");
+}
+}
+resultSet = new ShowResultSet(getMetaData(),
transactionMgr.getSingleTranInfo(db.getId(), txnId));
+}
+return resultSet;
+}
+
+/**
+ * validate
+ */
+public void validate(ConnectContext ctx) throws AnalysisException {
+// check auth
+if
(!Env.getCurrentEnv().getAccessManager().checkGlobalPriv(ConnectContext.get(),
PrivPredicate.ADMIN)) {
+
ErrorReport.reportAnalysisException(ErrorCode.ERR_SPECIFIC_ACCESS_DENIED_ERROR,
+PrivPredicate.ADMIN.getPrivs().toString());
+}
+
+if (Strings.isNullOrEmpty(dbName)) {
+
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2911055677 TPC-H: Total hot run time: 34081 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ac26b8a4de1bed9505577acdea07deea620eb495, data reload: false -- Round 1 -- q1 25985 512450715071 q2 2078295 196 196 q3 10483 1265714 714 q4 10230 1000510 510 q5 7682243423572357 q6 189 166 135 135 q7 927 752 612 612 q8 9316131310951095 q9 6831510251255102 q10 6881233319031903 q11 492 282 278 278 q12 345 358 216 216 q13 17787 367930983098 q14 235 250 224 224 q15 528 492 476 476 q16 427 431 376 376 q17 615 873 370 370 q18 7593731872437243 q19 1745972 563 563 q20 334 336 226 226 q21 3818321723802380 q22 1028984 936 936 Total cold run time: 115549 ms Total hot run time: 34081 ms - Round 2, with runtime_filter_mode=off - q1 5201513651575136 q2 243 331 234 234 q3 2174264523082308 q4 1376179614501450 q5 4486438743894387 q6 230 173 128 128 q7 2035195617471747 q8 2630246725992467 q9 7243721071007100 q10 3069321827662766 q11 581 512 504 504 q12 681 777 622 622 q13 3536389932903290 q14 311 326 302 302 q15 547 494 500 494 q16 422 493 464 464 q17 1168156613841384 q18 7758758076387580 q19 817 850 972 850 q20 1946201318471847 q21 4852459043994399 q22 11031079996 996 Total cold run time: 52409 ms Total hot run time: 50455 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2911076841 ClickBench: Total hot run time: 28.64 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ac26b8a4de1bed9505577acdea07deea620eb495, data reload: false query1 0.040.040.03 query2 0.140.100.12 query3 0.270.200.20 query4 1.590.190.19 query5 0.460.440.46 query6 1.140.670.66 query7 0.020.010.02 query8 0.040.040.04 query9 0.580.510.53 query10 0.570.590.57 query11 0.150.110.11 query12 0.160.120.12 query13 0.620.600.59 query14 0.790.810.80 query15 0.890.830.87 query16 0.380.380.38 query17 1.011.041.03 query18 0.230.210.22 query19 1.861.761.81 query20 0.010.010.02 query21 15.39 0.920.56 query22 0.741.160.67 query23 14.94 1.370.65 query24 7.171.210.33 query25 0.300.270.08 query26 0.640.160.13 query27 0.050.050.04 query28 8.530.920.44 query29 12.52 4.073.35 query30 0.250.090.07 query31 2.820.630.38 query32 3.230.560.47 query33 3.053.093.06 query34 15.66 5.104.53 query35 4.534.554.48 query36 0.680.490.48 query37 0.100.060.06 query38 0.060.040.04 query39 0.030.030.03 query40 0.170.130.14 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.040.03 Total cold run time: 101.97 s Total hot run time: 28.64 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2911070265 TPC-DS: Total hot run time: 193649 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 ac26b8a4de1bed9505577acdea07deea620eb495, data reload: false query1 1400110910421042 query2 6191186918631863 query3 11038 444945334449 query4 55144 25408 23469 23469 query5 5139559 476 476 query6 348 216 186 186 query7 4873507 289 289 query8 309 237 218 218 query9 5468264026442640 query10 424 334 287 287 query11 14996 15058 14762 14762 query12 168 115 113 113 query13 1039555 419 419 query14 10214 636462546254 query15 206 205 180 180 query16 7103668 501 501 query17 1102757 607 607 query18 1651420 329 329 query19 200 213 218 213 query20 125 143 125 125 query21 204 126 107 107 query22 4426457744824482 query23 34618 33711 33684 33684 query24 6670248424772477 query25 470 491 432 432 query26 695 275 152 152 query27 2239522 342 342 query28 3736219921972197 query29 605 588 438 438 query30 267 228 188 188 query31 906 888 826 826 query32 71 64 68 64 query33 455 364 310 310 query34 794 870 525 525 query35 820 839 751 751 query36 968 1015904 904 query37 117 101 76 76 query38 4173422142024202 query39 1492145714941457 query40 213 123 110 110 query41 59 56 50 50 query42 120 116 112 112 query43 498 529 476 476 query44 1343858 833 833 query45 181 175 165 165 query46 859 1051658 658 query47 1837187817931793 query48 417 459 351 351 query49 685 522 477 477 query50 695 718 423 423 query51 4309425242154215 query52 111 119 102 102 query53 240 260 189 189 query54 593 581 514 514 query55 90 86 86 86 query56 326 335 309 309 query57 1172116411521152 query58 278 267 268 267 query59 2707292427532753 query60 356 336 307 307 query61 141 122 128 122 query62 702 712 664 664 query63 227 182 185 182 query64 14851048673 673 query65 4311421742674217 query66 732 419 357 357 query67 15999 15603 15506 15506 query68 7107832 514 514 query69 543 317 269 269 query70 1193109911031099 query71 512 329 303 303 query72 5852491049894910 query73 1391694 364 364 query74 8939891587518751 query75 3936320326972697 query76 41441196743 743 query77 673 360 290 290 query78 10046 10199 93839383 query79 2012821 569 569 query80 597 493 472 472 query81 469 257 221 221 query82 444 125 102 102 query83 248 254 225 225 query84 292 114 79 79 query85 790 418 315 315 query86 369 322 278 278 query87 4424436843724368 query88 3798237023072307 query89 412 329 287 287 query90 1853207 206 206 query91 143 153 123 123 query92 76 122 55 55 query93 1716953 579 579 query94 661 416 311 311 query95 368 293 276 276 query96 500 573 286 286 query97 2741283126592659 query98 234 204 204 204 query99 1446137513051305 Total cold run time: 299479 ms Total hot run time: 193649 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2910928198 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2908570037 TPC-DS: Total hot run time: 192697 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 aab08ff82d75303de5e1c75f70920d3a30baceb6, data reload: false query1 1398113910691069 query2 6288181117791779 query3 10983 442945404429 query4 53708 25268 23062 23062 query5 5031531 470 470 query6 347 213 214 213 query7 4976504 282 282 query8 320 244 234 234 query9 5868263126082608 query10 448 329 273 273 query11 15084 15072 14788 14788 query12 168 123 106 106 query13 1079553 413 413 query14 10237 633564696335 query15 203 206 182 182 query16 7100621 494 494 query17 1066756 620 620 query18 1599409 311 311 query19 205 191 159 159 query20 131 136 120 120 query21 204 129 109 109 query22 4510443843954395 query23 34117 33535 33651 33535 query24 6553242524402425 query25 463 491 419 419 query26 674 270 152 152 query27 2245530 352 352 query28 3000213121402131 query29 591 596 421 421 query30 273 215 191 191 query31 903 871 787 787 query32 76 64 68 64 query33 445 355 333 333 query34 804 890 563 563 query35 818 892 773 773 query36 952 1003914 914 query37 108 99 77 77 query38 4318425542604255 query39 1489148614511451 query40 219 122 105 105 query41 56 55 52 52 query42 133 118 115 115 query43 510 503 493 493 query44 1410861 845 845 query45 180 182 177 177 query46 893 1039670 670 query47 1832187618191819 query48 418 442 329 329 query49 716 518 467 467 query50 689 738 444 444 query51 4225430642364236 query52 113 113 102 102 query53 237 269 196 196 query54 612 611 538 538 query55 89 85 95 85 query56 350 332 342 332 query57 1201116811551155 query58 283 275 306 275 query59 2696281626592659 query60 336 355 407 355 query61 132 125 132 125 query62 757 736 654 654 query63 233 199 184 184 query64 14761027684 684 query65 4318424241864186 query66 720 395 304 304 query67 15737 15705 15469 15469 query68 6998908 516 516 query69 540 314 269 269 query70 1217109711051097 query71 505 328 303 303 query72 5549476148024761 query73 1348670 361 361 query74 8884918386768676 query75 3857322126792679 query76 42861197782 782 query77 623 392 286 286 query78 10033 10181 93829382 query79 3299861 574 574 query80 646 526 463 463 query81 485 262 225 225 query82 490 129 148 129 query83 332 260 235 235 query84 290 105 80 80 query85 796 352 311 311 query86 387 280 295 280 query87 4420437743394339 query88 3561230623312306 query89 419 316 292 292 query90 1929220 215 215 query91 141 141 110 110 query92 79 66 56 56 query93 2306939 584 584 query94 678 402 309 309 query95 379 288 292 288 query96 504 582 290 290 query97 2723275226982698 query98 239 213 200 200 query99 1463140212521252 Total cold run time: 298759 ms Total hot run time: 192697 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2908549521 TPC-H: Total hot run time: 33575 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit aab08ff82d75303de5e1c75f70920d3a30baceb6, data reload: false -- Round 1 -- q1 26456 513251095109 q2 2106287 190 190 q3 10557 1283688 688 q4 10238 1009498 498 q5 7755235922352235 q6 181 164 136 136 q7 891 734 620 620 q8 9302125410221022 q9 6673506850475047 q10 6866230118721872 q11 488 286 274 274 q12 354 351 220 220 q13 17780 365930613061 q14 221 225 210 210 q15 532 483 500 483 q16 434 424 375 375 q17 575 845 359 359 q18 7816725971647164 q19 21381045527 527 q20 317 351 208 208 q21 3693315723242324 q22 10271002953 953 Total cold run time: 116400 ms Total hot run time: 33575 ms - Round 2, with runtime_filter_mode=off - q1 5389518751745174 q2 234 332 234 234 q3 2151264123232323 q4 1415178214331433 q5 4446437543304330 q6 208 169 134 134 q7 1988194817681768 q8 2587270425572557 q9 7276707269856985 q10 3013317727592759 q11 588 519 502 502 q12 680 780 592 592 q13 3483390232633263 q14 279 301 299 299 q15 524 502 479 479 q16 436 465 435 435 q17 1138155813631363 q18 7768762674247424 q19 780 851 1059851 q20 1960202518201820 q21 4828442744504427 q22 1122109010121012 Total cold run time: 52293 ms Total hot run time: 50164 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2908577207 ClickBench: Total hot run time: 28.92 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit aab08ff82d75303de5e1c75f70920d3a30baceb6, data reload: false query1 0.040.040.04 query2 0.130.100.10 query3 0.250.200.19 query4 1.590.190.19 query5 0.460.430.46 query6 1.510.640.65 query7 0.030.010.01 query8 0.040.030.04 query9 0.590.530.51 query10 0.580.580.57 query11 0.150.110.11 query12 0.150.120.12 query13 0.610.610.60 query14 0.790.810.82 query15 0.880.850.86 query16 0.380.370.39 query17 1.071.051.07 query18 0.220.220.21 query19 1.931.861.79 query20 0.020.010.01 query21 15.39 0.880.55 query22 0.761.020.65 query23 15.10 1.390.59 query24 7.061.380.84 query25 0.520.230.08 query26 0.580.160.13 query27 0.050.050.04 query28 9.960.880.44 query29 12.63 3.963.27 query30 0.260.080.07 query31 2.810.600.38 query32 3.230.540.47 query33 3.083.063.10 query34 15.83 5.084.48 query35 4.484.534.45 query36 0.680.490.48 query37 0.090.060.06 query38 0.050.040.03 query39 0.030.020.02 query40 0.170.140.13 query41 0.080.020.02 query42 0.040.020.03 query43 0.030.040.03 Total cold run time: 104.33 s Total hot run time: 28.92 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2908422299 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2907922271 ClickBench: Total hot run time: 28.88 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 28276d2ff2bd3266d306f6edd04cb3ad8c18d66b, data reload: false query1 0.040.040.03 query2 0.120.110.10 query3 0.250.190.20 query4 1.600.190.19 query5 0.420.420.42 query6 1.160.670.66 query7 0.030.020.01 query8 0.040.030.03 query9 0.600.520.51 query10 0.570.580.57 query11 0.160.110.11 query12 0.150.110.12 query13 0.630.600.59 query14 0.800.810.80 query15 0.890.860.89 query16 0.380.390.37 query17 1.001.071.07 query18 0.220.220.21 query19 1.891.891.82 query20 0.020.010.02 query21 15.41 0.900.56 query22 0.751.190.68 query23 14.90 1.390.66 query24 7.261.780.40 query25 0.490.210.08 query26 0.480.160.13 query27 0.050.050.05 query28 9.960.920.46 query29 12.56 4.033.35 query30 0.260.100.06 query31 2.810.640.41 query32 3.230.570.48 query33 3.133.133.05 query34 15.80 5.194.51 query35 4.554.544.58 query36 0.660.510.49 query37 0.080.070.06 query38 0.060.040.04 query39 0.030.020.02 query40 0.160.130.12 query41 0.080.030.02 query42 0.030.020.02 query43 0.040.030.03 Total cold run time: 103.75 s Total hot run time: 28.88 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2907919217 TPC-DS: Total hot run time: 184357 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 28276d2ff2bd3266d306f6edd04cb3ad8c18d66b, data reload: false query1 1024510 517 510 query2 6566180918531809 query3 6763232 228 228 query4 26454 23702 23338 23338 query5 4367647 466 466 query6 293 204 187 187 query7 4627492 290 290 query8 296 235 237 235 query9 8645263126392631 query10 498 323 280 280 query11 15469 15094 14850 14850 query12 164 112 112 112 query13 1655541 428 428 query14 8718620362786203 query15 208 193 176 176 query16 7230641 467 467 query17 1215718 583 583 query18 1983403 307 307 query19 201 211 171 171 query20 124 120 121 120 query21 218 128 113 113 query22 4328422141394139 query23 33901 33120 33092 33092 query24 8552237823842378 query25 553 461 400 400 query26 1252273 155 155 query27 2751502 341 341 query28 4373211121052105 query29 806 556 473 473 query30 284 217 187 187 query31 938 860 785 785 query32 75 64 67 64 query33 554 368 330 330 query34 816 861 524 524 query35 762 817 735 735 query36 974 967 881 881 query37 110 102 82 82 query38 4168413040274027 query39 1490161914331433 query40 219 118 106 106 query41 58 58 55 55 query42 125 107 118 107 query43 514 521 493 493 query44 1347828 824 824 query45 180 173 168 168 query46 919 1043641 641 query47 1772183617241724 query48 386 418 317 317 query49 784 531 429 429 query50 644 692 416 416 query51 4139424141054105 query52 109 105 111 105 query53 226 256 188 188 query54 592 582 515 515 query55 91 91 86 86 query56 307 320 302 302 query57 1154118610771077 query58 267 253 263 253 query59 2648268926192619 query60 331 323 306 306 query61 131 128 131 128 query62 798 742 684 684 query63 225 194 192 192 query64 44261015679 679 query65 4291429742584258 query66 1153419 311 311 query67 15853 15683 15442 15442 query68 8254903 543 543 query69 475 321 279 279 query70 1224114710921092 query71 488 361 326 326 query72 5588468523452345 query73 710 592 366 366 query74 9224913488078807 query75 3918319527102710 query76 37591173757 757 query77 804 404 287 287 query78 10351 10142 93299329 query79 2688851 598 598 query80 707 538 477 477 query81 487 257 221 221 query82 446 133 97 97 query83 295 262 249 249 query84 295 109 84 84 query85 799 358 319 319 query86 399 299 280 280 query87 4467452344124412 query88 3636232423202320 query89 405 317 289 289 query90 1846217 218 217 query91 150 141 112 112 query92 84 63 58 58 query93 1882959 589 589 query94 684 436 313 313 query95 382 304 292 292 query96 506 589 288 288 query97 2744277526232623 query98 238 223 209 209 query99 1482139213041304 Total cold run time: 276511 ms Total hot run time: 184357 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2907912040 TPC-H: Total hot run time: 33779 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 28276d2ff2bd3266d306f6edd04cb3ad8c18d66b, data reload: false -- Round 1 -- q1 27051 510150995099 q2 2085277 199 199 q3 10427 1290691 691 q4 10229 990 510 510 q5 7803240123372337 q6 183 169 129 129 q7 906 755 602 602 q8 93101307987 987 q9 6815513050205020 q10 6863234218801880 q11 492 294 276 276 q12 345 347 207 207 q13 17782 370831223122 q14 225 236 217 217 q15 536 483 504 483 q16 436 428 375 375 q17 615 865 370 370 q18 7729717770957095 q19 1293961 545 545 q20 330 356 237 237 q21 3966251823922392 q22 1035104810061006 Total cold run time: 116456 ms Total hot run time: 33779 ms - Round 2, with runtime_filter_mode=off - q1 5115504950595049 q2 239 325 234 234 q3 2153267323242324 q4 1376175513461346 q5 4609445443804380 q6 221 170 126 126 q7 2042188417941794 q8 2580242024262420 q9 7246711271357112 q10 2982316727672767 q11 570 496 502 496 q12 693 780 624 624 q13 3533390032883288 q14 301 288 277 277 q15 523 477 470 470 q16 452 491 449 449 q17 1155156213641364 q18 7721751472517251 q19 809 832 851 832 q20 1933206318731873 q21 5008428542444244 q22 10731024979 979 Total cold run time: 52334 ms Total hot run time: 49699 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2907897249 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893248139 ClickBench: Total hot run time: 29.39 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit aa56fa65d7c8d03a0954883af218c79740df88e8, data reload: false query1 0.040.040.03 query2 0.110.100.12 query3 0.250.200.19 query4 1.600.200.20 query5 0.470.440.44 query6 1.130.670.66 query7 0.020.010.01 query8 0.040.030.03 query9 0.590.510.53 query10 0.570.570.57 query11 0.160.110.10 query12 0.160.120.12 query13 0.610.600.60 query14 0.800.820.82 query15 0.900.860.88 query16 0.410.400.39 query17 1.041.061.04 query18 0.220.210.22 query19 1.921.791.83 query20 0.010.020.02 query21 15.41 0.930.55 query22 0.771.200.71 query23 14.90 1.400.65 query24 6.891.660.85 query25 0.430.070.12 query26 0.660.150.14 query27 0.050.060.05 query28 9.370.890.47 query29 12.60 4.023.38 query30 0.250.090.06 query31 2.830.600.40 query32 3.230.560.47 query33 3.093.163.07 query34 15.79 5.064.52 query35 4.504.534.52 query36 0.660.490.48 query37 0.090.060.06 query38 0.040.040.03 query39 0.040.030.02 query40 0.170.140.13 query41 0.070.030.02 query42 0.030.020.03 query43 0.040.040.03 Total cold run time: 102.96 s Total hot run time: 29.39 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893235126 TPC-DS: Total hot run time: 193918 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 aa56fa65d7c8d03a0954883af218c79740df88e8, data reload: false query1 1406110410401040 query2 6221182717971797 query3 11036 454844074407 query4 53500 24384 23552 23552 query5 5352521 484 484 query6 372 204 199 199 query7 4938524 298 298 query8 334 264 255 255 query9 6358262726582627 query10 451 325 274 274 query11 15118 15088 14877 14877 query12 166 112 105 105 query13 1084542 411 411 query14 10214 635865856358 query15 206 196 176 176 query16 7107670 515 515 query17 1082754 612 612 query18 1539436 305 305 query19 200 196 167 167 query20 127 132 123 123 query21 208 122 109 109 query22 4437441343954395 query23 34494 33525 33758 33525 query24 6614248824822482 query25 493 480 401 401 query26 698 281 160 160 query27 2328519 345 345 query28 3340216621562156 query29 579 567 458 458 query30 271 218 193 193 query31 872 877 791 791 query32 72 66 63 63 query33 468 392 339 339 query34 820 878 570 570 query35 787 847 770 770 query36 973 1010918 918 query37 114 100 101 100 query38 4258425141864186 query39 1537145414581454 query40 209 125 111 111 query41 53 59 53 53 query42 133 112 110 110 query43 496 525 490 490 query44 1407862 845 845 query45 182 180 177 177 query46 912 1049678 678 query47 1841187517691769 query48 392 467 316 316 query49 689 534 445 445 query50 728 728 433 433 query51 4350428042204220 query52 111 117 98 98 query53 239 284 210 210 query54 592 583 510 510 query55 86 92 86 86 query56 317 296 312 296 query57 1243122111261126 query58 289 268 266 266 query59 2697277926892689 query60 335 319 304 304 query61 129 129 134 129 query62 743 734 681 681 query63 244 196 201 196 query64 17841017672 672 query65 4347426643524266 query66 733 407 309 309 query67 16086 15738 15678 15678 query68 7817890 536 536 query69 543 301 284 284 query70 1217108811471088 query71 508 344 307 307 query72 5935489948944894 query73 1273683 374 374 query74 8958912289268926 query75 3728321226622662 query76 41261203776 776 query77 608 394 290 290 query78 10154 10142 93699369 query79 6027817 568 568 query80 668 542 452 452 query81 493 266 222 222 query82 639 130 108 108 query83 363 262 238 238 query84 297 106 86 86 query85 791 399 325 325 query86 379 296 300 296 query87 4512442543264326 query88 3314231623392316 query89 453 328 304 304 query90 1939217 217 217 query91 139 207 119 119 query92 71 57 56 56 query93 2845966 583 583 query94 718 410 297 297 query95 381 299 293 293 query96 509 592 283 283 query97 2773277326992699 query98 231 208 206 206 query99 1438139512581258 Total cold run time: 305388 ms Total hot run time: 193918 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893201722 TPC-H: Total hot run time: 33689 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit aa56fa65d7c8d03a0954883af218c79740df88e8, data reload: false -- Round 1 -- q1 26218 523850325032 q2 2079280 186 186 q3 10386 1237704 704 q4 10219 1006526 526 q5 7504232523752325 q6 175 161 131 131 q7 911 745 634 634 q8 9344125011031103 q9 6847505949844984 q10 6868231819191919 q11 508 281 267 267 q12 358 364 211 211 q13 17775 370230443044 q14 232 228 214 214 q15 547 493 495 493 q16 424 431 373 373 q17 597 871 365 365 q18 7702704770867047 q19 1379969 582 582 q20 325 348 223 223 q21 3834316323732373 q22 10421005953 953 Total cold run time: 115274 ms Total hot run time: 33689 ms - Round 2, with runtime_filter_mode=off - q1 5114508050775077 q2 240 328 227 227 q3 2162262622742274 q4 1363178213611361 q5 4462444343954395 q6 210 174 126 126 q7 2025197317621762 q8 2606266125242524 q9 7183719769886988 q10 3071324927622762 q11 587 523 487 487 q12 675 759 652 652 q13 3489393832713271 q14 284 299 289 289 q15 531 503 480 480 q16 459 507 440 440 q17 1149156113881388 q18 7867753374677467 q19 838 820 900 820 q20 1967209719171917 q21 4719434944934349 q22 1059104910191019 Total cold run time: 52060 ms Total hot run time: 50075 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893132174 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893116578 ClickBench: Total hot run time: 28.47 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d07241050ae06d689a57ac8fb4266332e4850855, data reload: false query1 0.040.030.03 query2 0.140.100.12 query3 0.260.190.18 query4 1.580.200.10 query5 0.440.400.41 query6 1.170.650.66 query7 0.020.010.01 query8 0.040.040.04 query9 0.570.510.52 query10 0.570.580.57 query11 0.150.110.11 query12 0.150.110.12 query13 0.610.600.60 query14 0.780.810.82 query15 0.880.870.85 query16 0.400.370.38 query17 1.001.021.02 query18 0.220.210.20 query19 1.921.751.78 query20 0.010.010.01 query21 15.41 0.930.57 query22 0.761.150.59 query23 15.03 1.390.57 query24 6.611.930.51 query25 0.480.220.08 query26 0.590.160.13 query27 0.050.050.05 query28 9.800.890.46 query29 12.60 3.963.28 query30 0.250.100.07 query31 2.820.600.39 query32 3.230.540.46 query33 3.073.033.05 query34 15.82 5.104.56 query35 4.574.544.50 query36 0.670.490.48 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.160.130.13 query41 0.080.030.02 query42 0.030.020.03 query43 0.040.030.03 Total cold run time: 103.19 s Total hot run time: 28.47 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893106284 TPC-DS: Total hot run time: 189468 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 d07241050ae06d689a57ac8fb4266332e4850855, data reload: false query1 1423110010681068 query2 6257182018121812 query3 11131 462943154315 query4 55191 24566 23059 23059 query5 5057494 461 461 query6 349 217 204 204 query7 4884516 294 294 query8 326 259 248 248 query9 6123264526642645 query10 432 352 273 273 query11 15360 15034 14779 14779 query12 165 115 108 108 query13 1057532 411 411 query14 10147 640563216321 query15 201 198 187 187 query16 7062687 516 516 query17 1084761 624 624 query18 1597408 343 343 query19 196 191 176 176 query20 130 134 121 121 query21 211 127 120 120 query22 4348446542394239 query23 34385 33410 33489 33410 query24 6701240523962396 query25 479 484 421 421 query26 700 276 149 149 query27 2270501 351 351 query28 3091215921622159 query29 589 563 427 427 query30 275 223 191 191 query31 869 858 770 770 query32 76 68 70 68 query33 455 357 318 318 query34 785 872 545 545 query35 796 843 728 728 query36 944 1003904 904 query37 116 98 75 75 query38 4164425941054105 query39 1511143614791436 query40 218 132 120 120 query41 55 85 59 59 query42 122 106 110 106 query43 492 533 520 520 query44 1342853 844 844 query45 186 181 167 167 query46 897 1062663 663 query47 1888185017881788 query48 406 435 331 331 query49 713 543 441 441 query50 676 709 417 417 query51 4258418941994189 query52 108 112 97 97 query53 223 254 184 184 query54 598 580 526 526 query55 88 85 85 85 query56 313 303 308 303 query57 1232120611641164 query58 271 265 250 250 query59 2767282826352635 query60 328 345 310 310 query61 124 124 130 124 query62 804 756 673 673 query63 227 193 192 192 query64 17141020758 758 query65 4322426742464246 query66 722 397 301 301 query67 15918 15768 15513 15513 query68 6802895 530 530 query69 547 314 283 283 query70 1188108311361083 query71 552 323 304 304 query72 5576232752382327 query73 1405758 357 357 query74 8905880086548654 query75 3830320126952695 query76 42961199758 758 query77 595 373 282 282 query78 10065 10148 93379337 query79 2278818 585 585 query80 597 525 436 436 query81 487 248 215 215 query82 466 124 95 95 query83 252 257 230 230 query84 294 99 84 84 query85 781 401 313 313 query86 379 286 306 286 query87 4314441542914291 query88 3567231622912291 query89 398 314 287 287 query90 1801208 200 200 query91 139 142 112 112 query92 73 60 60 60 query93 1905934 576 576 query94 671 401 311 311 query95 370 290 289 289 query96 495 563 277 277 query97 2682272926452645 query98 235 210 206 206 query99 1379145512861286 Total cold run time: 299273 ms Total hot run time: 189468 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] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
doris-robot commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893082771 TPC-H: Total hot run time: 33478 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d07241050ae06d689a57ac8fb4266332e4850855, data reload: false -- Round 1 -- q1 25882 504949624962 q2 2084279 176 176 q3 10404 1242703 703 q4 10222 1006509 509 q5 7524234622972297 q6 175 164 135 135 q7 921 733 614 614 q8 9321123410541054 q9 7034508149964996 q10 6880231318881888 q11 479 280 273 273 q12 360 353 210 210 q13 17803 367030463046 q14 240 231 210 210 q15 524 493 490 490 q16 407 425 383 383 q17 576 845 367 367 q18 7873713571647135 q19 1555949 544 544 q20 336 332 221 221 q21 3733309923012301 q22 10711018964 964 Total cold run time: 115404 ms Total hot run time: 33478 ms - Round 2, with runtime_filter_mode=off - q1 5114521050165016 q2 244 330 229 229 q3 2127260422922292 q4 1353178313611361 q5 4382432943514329 q6 207 168 132 132 q7 2006192317771777 q8 2569255125162516 q9 7241730268896889 q10 3049316527732773 q11 582 509 493 493 q12 682 758 620 620 q13 3510388832533253 q14 287 313 286 286 q15 531 499 481 481 q16 444 472 434 434 q17 1129156313881388 q18 7816764674127412 q19 778 759 797 759 q20 1975197718331833 q21 4737443544574435 q22 1088103410641034 Total cold run time: 51851 ms Total hot run time: 49742 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2893013921 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
yx-keith commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2892801422 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement] (nereids) implement showTransactionCommand in nereids [doris]
hello-stephen commented on PR #50695: URL: https://github.com/apache/doris/pull/50695#issuecomment-2862000954 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
