Re: [PR] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange closed pull request #51486: [Refactor](SerDe) use DataTypeSerDe to serialize column to text URL: https://github.com/apache/doris/pull/51486 -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2988756475 ClickBench: Total hot run time: 29.32 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f27214b471327336d4dcccbe67df62f1d5663033, data reload: false query1 0.030.030.03 query2 0.070.040.03 query3 0.230.070.07 query4 1.610.100.11 query5 0.440.420.40 query6 1.170.660.66 query7 0.020.020.02 query8 0.050.040.04 query9 0.580.520.52 query10 0.580.590.56 query11 0.160.110.11 query12 0.140.120.12 query13 0.650.610.62 query14 0.800.820.83 query15 0.920.860.86 query16 0.400.390.40 query17 1.051.071.09 query18 0.230.220.21 query19 2.011.931.91 query20 0.020.010.01 query21 15.40 0.920.54 query22 0.741.280.78 query23 14.74 1.390.61 query24 6.750.970.32 query25 0.340.160.16 query26 0.670.160.14 query27 0.060.050.06 query28 9.390.970.46 query29 12.54 4.003.32 query30 0.260.090.06 query31 2.830.610.40 query32 3.240.540.47 query33 3.083.143.07 query34 16.16 5.354.77 query35 4.884.794.79 query36 0.700.500.51 query37 0.090.070.07 query38 0.050.040.03 query39 0.040.030.02 query40 0.170.140.14 query41 0.080.020.02 query42 0.030.030.03 query43 0.040.040.03 Total cold run time: 103.44 s Total hot run time: 29.32 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2988748434 TPC-DS: Total hot run time: 185563 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 f27214b471327336d4dcccbe67df62f1d5663033, data reload: false query1 1008418 411 411 query2 6532189718701870 query3 6747226 223 223 query4 26362 24130 23005 23005 query5 4352641 477 477 query6 328 213 198 198 query7 4629494 288 288 query8 267 232 223 223 query9 8650258526272585 query10 488 330 268 268 query11 15869 15123 14807 14807 query12 162 115 107 107 query13 1662523 404 404 query14 9434608261116082 query15 215 190 170 170 query16 7264618 458 458 query17 1169699 577 577 query18 1984409 294 294 query19 189 192 159 159 query20 118 116 116 116 query21 218 132 106 106 query22 4049414540474047 query23 34242 32938 33089 32938 query24 8425234324032343 query25 574 462 389 389 query26 1238261 149 149 query27 2780492 333 333 query28 4378214420992099 query29 769 560 425 425 query30 282 229 194 194 query31 941 831 775 775 query32 77 69 66 66 query33 574 359 319 319 query34 783 895 529 529 query35 787 839 731 731 query36 954 1001894 894 query37 108 101 78 78 query38 4086408940344034 query39 1500142013931393 query40 220 131 120 120 query41 77 69 66 66 query42 126 115 115 115 query43 509 528 482 482 query44 1293831 838 831 query45 184 183 175 175 query46 864 1030633 633 query47 1735177317101710 query48 390 424 317 317 query49 773 498 408 408 query50 638 690 414 414 query51 4182408741144087 query52 116 113 110 110 query53 235 261 196 196 query54 599 572 519 519 query55 94 89 91 89 query56 312 335 300 300 query57 1178119411151115 query58 313 258 260 258 query59 2674275626462646 query60 328 315 312 312 query61 137 127 126 126 query62 800 736 654 654 query63 229 183 184 183 query64 43411012674 674 query65 4290415941944159 query66 1136423 316 316 query67 15779 15430 15462 15430 query68 8042903 534 534 query69 462 312 282 282 query70 1189108610891086 query71 466 348 294 294 query72 5431473746404640 query73 694 572 357 357 query74 8950892489858924 query75 3861322126962696 query76 36961188753 753 query77 783 413 284 284 query78 10270 10312 94879487 query79 2322776 604 604 query80 612 515 442 442 query81 483 262 224 224 query82 427 126 102 102 query83 280 266 250 250 query84 295 100 96 96 query85 787 349 312 312 query86 333 308 270 270 query87 4403440742894289 query88 3206237822752275 query89 388 310 296 296 query90 1961205 206 205 query91 145 142 124 124 query92 80 64 59 59 query93 1682953 604 604 query94 689 405 307 307 query95 382 300 294 294 query96 488 584 281 281 query97 2713274726422642 query98 233 203 209 203 query99 1436140613381338 Total cold run time: 274935 ms Total hot run time: 185563 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2988709548 TPC-H: Total hot run time: 34051 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f27214b471327336d4dcccbe67df62f1d5663033, data reload: false -- Round 1 -- q1 17589 519250785078 q2 1942318 214 214 q3 10298 3381744 744 q4 10236 1019520 520 q5 7597238922862286 q6 186 171 133 133 q7 879 740 609 609 q8 9330126911221122 q9 6801509552905095 q10 6879239119631963 q11 490 290 273 273 q12 350 351 219 219 q13 17811 372031473147 q14 238 238 220 220 q15 561 485 492 485 q16 428 429 377 377 q17 599 874 368 368 q18 7620728471007100 q19 1637957 567 567 q20 344 328 229 229 q21 3860319923372337 q22 10271049965 965 Total cold run time: 106702 ms Total hot run time: 34051 ms - Round 2, with runtime_filter_mode=off - q1 5161507750365036 q2 253 324 228 228 q3 2173269323142314 q4 1364177813841384 q5 4275434544024345 q6 214 170 128 128 q7 2059191117721772 q8 2592258124832483 q9 7148701971607019 q10 3066326028382838 q11 570 505 517 505 q12 726 813 630 630 q13 3537390333313331 q14 283 292 270 270 q15 516 481 469 469 q16 455 491 461 461 q17 1159141113771377 q18 7488711370307030 q19 780 787 765 765 q20 1893200018331833 q21 4678439943794379 q22 10441053972 972 Total cold run time: 51434 ms Total hot run time: 49569 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2988478887 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2987036186 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2987012066 # BE Regression && UT Coverage Report Increment line coverage `53.94% (185/343)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/51486_f27214b471327336d4dcccbe67df62f1d5663033_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/51486_f27214b471327336d4dcccbe67df62f1d5663033_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 61.16% (16098/26323) | | Line Coverage | 50.70% (151361/298570) | | Region Coverage | 48.03% (86527/180150) | | Branch Coverage | 41.55% (42516/102324) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2986967346 # BE UT Coverage Report Increment line coverage `53.94% (185/343)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/f27214b471327336d4dcccbe67df62f1d5663033_f27214b471327336d4dcccbe67df62f1d5663033/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/f27214b471327336d4dcccbe67df62f1d5663033_f27214b471327336d4dcccbe67df62f1d5663033/report/index.html) | Category | Coverage | |---|| | Function Coverage | 56.35% (15072/26748) | | Line Coverage | 45.12% (134773/298731) | | Region Coverage | 44.24% (67747/153133) | | Branch Coverage | 38.83% (34750/89500) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2986582104 TPC-DS: Total hot run time: 186214 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 f27214b471327336d4dcccbe67df62f1d5663033, data reload: false query1 1027392 414 392 query2 6523181018171810 query3 6756233 231 231 query4 26247 23290 23660 23290 query5 4361638 472 472 query6 321 216 206 206 query7 4620503 302 302 query8 283 227 222 222 query9 8619265626572656 query10 475 349 286 286 query11 15586 15076 14812 14812 query12 157 107 105 105 query13 1655529 427 427 query14 8754617461636163 query15 205 200 184 184 query16 7333644 477 477 query17 1219750 585 585 query18 2007417 324 324 query19 196 223 162 162 query20 131 127 121 121 query21 221 129 107 107 query22 4017419340174017 query23 34367 33017 33242 33017 query24 8454239124012391 query25 529 463 400 400 query26 1232270 152 152 query27 2751511 354 354 query28 4299212521092109 query29 787 566 437 437 query30 289 221 196 196 query31 912 842 782 782 query32 70 69 65 65 query33 556 370 312 312 query34 806 859 532 532 query35 795 802 755 755 query36 984 968 906 906 query37 110 98 74 74 query38 4140412941664129 query39 1473142514131413 query40 215 117 107 107 query41 64 61 62 61 query42 138 118 118 118 query43 512 493 471 471 query44 1293824 820 820 query45 186 171 168 168 query46 852 1032635 635 query47 1755182617231723 query48 392 427 316 316 query49 761 465 394 394 query50 654 675 424 424 query51 4135422741784178 query52 116 110 106 106 query53 226 247 180 180 query54 585 570 509 509 query55 87 81 82 81 query56 291 317 289 289 query57 1175121511381138 query58 295 256 259 256 query59 2519260425522552 query60 322 326 320 320 query61 129 132 136 132 query62 791 715 657 657 query63 223 193 183 183 query64 43451016683 683 query65 4283422141904190 query66 1167477 325 325 query67 15714 15667 15376 15376 query68 8794896 539 539 query69 474 311 270 270 query70 1219103911311039 query71 461 314 294 294 query72 5629478148864781 query73 744 641 356 356 query74 9227883886718671 query75 4175318627072707 query76 36111182767 767 query77 785 367 300 300 query78 10027 10188 93749374 query79 1270789 597 597 query80 625 573 465 465 query81 479 263 221 221 query82 359 130 104 104 query83 304 254 238 238 query84 297 111 96 96 query85 767 365 370 365 query86 331 322 281 281 query87 4337447843764376 query88 2848228922762276 query89 379 320 291 291 query90 2042204 206 204 query91 151 143 113 113 query92 81 63 58 58 query93 1107931 601 601 query94 675 410 313 313 query95 384 299 285 285 query96 492 568 283 283 query97 2726277526542654 query98 230 212 211 211 query99 1400140813171317 Total cold run time: 272922 ms Total hot run time: 186214 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2986562286 TPC-H: Total hot run time: 34264 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f27214b471327336d4dcccbe67df62f1d5663033, data reload: false -- Round 1 -- q1 17601 521349864986 q2 1942299 201 201 q3 10332 1401723 723 q4 10224 1027519 519 q5 7576240124162401 q6 186 163 132 132 q7 897 750 630 630 q8 93231312 q9 6859518051995180 q10 6917238619831983 q11 475 287 270 270 q12 349 358 221 221 q13 17782 363731123112 q14 244 226 216 216 q15 580 483 500 483 q16 440 443 379 379 q17 618 874 376 376 q18 7597726971167116 q19 2114981 607 607 q20 345 349 225 225 q21 3867321024172417 q22 10861045976 976 Total cold run time: 107354 ms Total hot run time: 34264 ms - Round 2, with runtime_filter_mode=off - q1 5149504750465046 q2 254 334 231 231 q3 2190266223182318 q4 1322179813351335 q5 4304423844784238 q6 218 170 127 127 q7 2040194417711771 q8 2611259924462446 q9 7183721372017201 q10 3101325928382838 q11 612 556 484 484 q12 698 762 644 644 q13 3510383732233223 q14 291 293 305 293 q15 512 483 480 480 q16 452 483 460 460 q17 1177160013591359 q18 7835737973677367 q19 839 889 1020889 q20 2008208719471947 q21 4968450342404240 q22 1084107510111011 Total cold run time: 52358 ms Total hot run time: 49948 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2986409253 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2980133864 ClickBench: Total hot run time: 29.13 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false query1 0.030.040.02 query2 0.080.030.04 query3 0.240.060.07 query4 1.600.100.10 query5 0.430.430.41 query6 1.160.670.66 query7 0.020.020.02 query8 0.040.040.04 query9 0.590.520.50 query10 0.580.580.56 query11 0.160.110.11 query12 0.150.120.11 query13 0.620.600.60 query14 0.790.820.81 query15 0.880.870.86 query16 0.390.380.39 query17 1.031.081.06 query18 0.230.210.21 query19 1.961.831.84 query20 0.010.010.01 query21 15.42 0.880.54 query22 0.741.040.66 query23 15.11 1.380.67 query24 7.301.300.43 query25 0.500.190.11 query26 0.560.160.15 query27 0.060.050.04 query28 9.920.900.45 query29 12.58 3.973.31 query30 0.250.090.07 query31 2.830.580.40 query32 3.240.540.46 query33 3.073.113.19 query34 16.13 5.344.78 query35 4.874.864.75 query36 0.690.500.48 query37 0.090.070.07 query38 0.050.040.04 query39 0.030.030.02 query40 0.170.140.14 query41 0.080.020.03 query42 0.030.030.02 query43 0.040.030.03 Total cold run time: 104.75 s Total hot run time: 29.13 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2980118282 TPC-DS: Total hot run time: 185162 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 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false query1 1009380 383 380 query2 6559182017741774 query3 6737224 215 215 query4 26825 23641 23027 23027 query5 4389640 461 461 query6 299 216 197 197 query7 4627499 277 277 query8 272 226 226 226 query9 8605258325962583 query10 486 357 273 273 query11 15359 14996 14752 14752 query12 151 105 106 105 query13 1645511 409 409 query14 8645602359685968 query15 198 189 171 171 query16 7121649 472 472 query17 918 730 581 581 query18 1984413 304 304 query19 197 196 164 164 query20 125 117 120 117 query21 212 125 110 110 query22 4198418939533953 query23 34102 33028 32974 32974 query24 8447238523952385 query25 543 455 391 391 query26 1232262 148 148 query27 2765511 348 348 query28 4317209720862086 query29 764 554 426 426 query30 288 224 200 200 query31 936 872 715 715 query32 73 60 67 60 query33 543 355 310 310 query34 802 847 528 528 query35 770 802 734 734 query36 931 972 867 867 query37 113 103 77 77 query38 4102408940314031 query39 1487141314131413 query40 216 122 104 104 query41 64 60 57 57 query42 125 106 116 106 query43 484 487 484 484 query44 1318805 816 805 query45 171 172 165 165 query46 835 998 628 628 query47 1740177317051705 query48 391 450 308 308 query49 736 499 424 424 query50 655 681 384 384 query51 4108415341824153 query52 120 109 98 98 query53 231 259 182 182 query54 591 574 502 502 query55 82 88 81 81 query56 286 317 294 294 query57 1189118711161116 query58 281 270 259 259 query59 2572261324712471 query60 346 335 320 320 query61 152 150 154 150 query62 814 763 708 708 query63 229 188 187 187 query64 44551117761 761 query65 4247416141784161 query66 1147410 307 307 query67 15876 15465 15642 15465 query68 9294895 533 533 query69 477 292 261 261 query70 12181144 query71 472 320 301 301 query72 5601489948454845 query73 755 664 358 358 query74 8855921989648964 query75 4265320626582658 query76 40511187752 752 query77 994 359 303 303 query78 998310269 93199319 query79 1717854 589 589 query80 636 537 468 468 query81 475 262 226 226 query82 214 193 96 96 query83 296 263 234 234 query84 289 112 92 92 query85 761 362 328 328 query86 331 278 283 278 query87 4376440042934293 query88 2893229423232294 query89 404 311 287 287 query90 2076212 212 212 query91 143 151 117 117 query92 72 63 61 61 query93 1154954 570 570 query94 690 406 305 305 query95 376 298 287 287 query96 494 584 284 284 query97 2710274126492649 query98 226 203 210 203 query99 1416143412871287 Total cold run time: 273951 ms Total hot run time: 185162 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2980083989 TPC-H: Total hot run time: 34107 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false -- Round 1 -- q1 17614 526150175017 q2 1933291 177 177 q3 10317 1321747 747 q4 10227 1037520 520 q5 7579239023482348 q6 185 161 132 132 q7 896 733 618 618 q8 9335134011511151 q9 6783519350825082 q10 6889238519631963 q11 481 290 278 278 q12 347 349 218 218 q13 17767 362930963096 q14 233 234 221 221 q15 566 476 484 476 q16 423 435 367 367 q17 614 870 377 377 q18 7603721372697213 q19 1221952 545 545 q20 343 347 235 235 q21 3849323023402340 q22 10581005986 986 Total cold run time: 106263 ms Total hot run time: 34107 ms - Round 2, with runtime_filter_mode=off - q1 5124508250635063 q2 242 338 220 220 q3 2137266623112311 q4 1337181013971397 q5 4252407045224070 q6 210 172 126 126 q7 2017194117361736 q8 2612252824912491 q9 7172715871467146 q10 3058322128442844 q11 587 510 518 510 q12 695 744 602 602 q13 3424389232713271 q14 267 284 274 274 q15 523 478 489 478 q16 428 493 430 430 q17 1150155513831383 q18 7612761275207520 q19 805 808 885 808 q20 2047207018591859 q21 5014449944524452 q22 10401011993 993 Total cold run time: 51753 ms Total hot run time: 49984 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
jacktengg commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2980002883 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2979951737 TPC-DS: Total hot run time: 193384 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 f372d9ee324def27fc6c2e1a0b29ddf286f12ba8, data reload: false query1 13901033991 991 query2 6132177418001774 query3 10954 449646174496 query4 54330 25486 23716 23716 query5 5101524 433 433 query6 354 210 190 190 query7 4962536 285 285 query8 295 224 215 215 query9 6069263726432637 query10 441 338 262 262 query11 15139 15001 14897 14897 query12 157 108 107 107 query13 1078532 419 419 query14 10174 636962856285 query15 213 214 182 182 query16 7124670 505 505 query17 1094763 604 604 query18 1585432 319 319 query19 210 205 175 175 query20 133 128 116 116 query21 215 123 105 105 query22 4326449143024302 query23 34177 33741 33535 33535 query24 6630252124162416 query25 475 499 417 417 query26 747 278 152 152 query27 2565523 353 353 query28 2997216821782168 query29 595 587 437 437 query30 278 229 195 195 query31 895 860 790 790 query32 78 66 66 66 query33 440 393 328 328 query34 801 865 530 530 query35 801 808 756 756 query36 939 1031895 895 query37 120 103 75 75 query38 4234423242454232 query39 1513149514831483 query40 220 120 106 106 query41 63 60 57 57 query42 129 116 114 114 query43 514 521 482 482 query44 1350839 860 839 query45 184 180 169 169 query46 848 1064674 674 query47 1836190517861786 query48 397 435 322 322 query49 678 499 429 429 query50 680 715 406 406 query51 4271432442794279 query52 109 117 107 107 query53 231 266 191 191 query54 596 589 533 533 query55 86 91 81 81 query56 307 298 298 298 query57 1198124111681168 query58 269 267 271 267 query59 2624269226492649 query60 335 318 314 314 query61 161 144 123 123 query62 758 753 669 669 query63 221 189 188 188 query64 18111028697 697 query65 4290416741994167 query66 705 401 298 298 query67 15834 15720 15543 15543 query68 6771898 522 522 query69 562 322 263 263 query70 1186109111081091 query71 511 374 300 300 query72 5754476647874766 query73 1318637 352 352 query74 9021909391339093 query75 3855319127482748 query76 43031197766 766 query77 637 380 282 282 query78 10205 10046 93519351 query79 3559820 552 552 query80 640 512 447 447 query81 513 262 224 224 query82 491 128 96 96 query83 362 250 238 238 query84 292 108 84 84 query85 853 348 302 302 query86 378 313 296 296 query87 4339439243694369 query88 3560225622782256 query89 419 312 285 285 query90 1806207 213 207 query91 143 145 110 110 query92 75 62 55 55 query93 2710946 575 575 query94 666 404 301 301 query95 374 291 299 291 query96 487 576 276 276 query97 2769277326352635 query98 243 196 199 196 query99 1437140012561256 Total cold run time: 300705 ms Total hot run time: 193384 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2979918125 TPC-H: Total hot run time: 34019 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f372d9ee324def27fc6c2e1a0b29ddf286f12ba8, data reload: false -- Round 1 -- q1 17615 519250185018 q2 1953281 169 169 q3 10400 1324789 789 q4 10228 1017543 543 q5 7599234223492342 q6 188 165 134 134 q7 931 753 649 649 q8 9327133811421142 q9 6810511152835111 q10 6883236719611961 q11 465 288 278 278 q12 345 361 218 218 q13 17797 367630723072 q14 242 237 210 210 q15 553 487 472 472 q16 435 430 375 375 q17 601 876 373 373 q18 7778706870287028 q19 1548970 571 571 q20 339 336 224 224 q21 3859316824152415 q22 10811026925 925 Total cold run time: 106977 ms Total hot run time: 34019 ms - Round 2, with runtime_filter_mode=off - q1 5132509450695069 q2 249 314 214 214 q3 2196266623072307 q4 1381177613611361 q5 4257408443974084 q6 217 177 136 136 q7 2064193617821782 q8 2632261925682568 q9 7233715471347134 q10 3078330427792779 q11 557 521 496 496 q12 677 817 627 627 q13 3654395433173317 q14 295 298 262 262 q15 533 481 481 481 q16 464 481 427 427 q17 1226160813811381 q18 7797760874697469 q19 872 838 957 838 q20 1981207719241924 q21 5028451043894389 q22 1098102610071007 Total cold run time: 52621 ms Total hot run time: 50052 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2979594500 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
jacktengg commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2979168552 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2978855922 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2974932640 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2969709664 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2965353397 ClickBench: Total hot run time: 29.53 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false query1 0.040.030.02 query2 0.120.100.10 query3 0.250.190.20 query4 1.600.190.20 query5 0.420.440.42 query6 1.180.660.66 query7 0.030.010.02 query8 0.040.040.03 query9 0.580.530.52 query10 0.580.580.57 query11 0.160.110.12 query12 0.140.110.12 query13 0.620.600.59 query14 0.780.810.80 query15 0.870.860.87 query16 0.390.400.37 query17 1.061.031.06 query18 0.230.210.22 query19 1.911.801.86 query20 0.010.020.01 query21 15.46 0.910.54 query22 0.751.220.62 query23 14.95 1.390.61 query24 6.491.361.47 query25 0.490.190.08 query26 0.510.160.14 query27 0.050.050.05 query28 10.98 0.900.44 query29 12.61 3.993.30 query30 0.260.090.06 query31 2.830.610.39 query32 3.230.540.47 query33 2.993.033.10 query34 15.74 5.134.50 query35 4.614.574.53 query36 0.670.500.50 query37 0.090.070.06 query38 0.050.030.04 query39 0.040.020.02 query40 0.170.140.13 query41 0.070.020.03 query42 0.030.030.02 query43 0.040.030.03 Total cold run time: 104.12 s Total hot run time: 29.53 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2965307668 TPC-H: Total hot run time: 34108 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false -- Round 1 -- q1 26326 507650365036 q2 1972282 180 180 q3 10377 1241730 730 q4 10248 986 535 535 q5 7618240424012401 q6 189 163 134 134 q7 908 739 608 608 q8 9313132711781178 q9 6683515151455145 q10 6958231719121912 q11 499 306 266 266 q12 347 358 217 217 q13 17775 364531393139 q14 226 240 217 217 q15 581 479 485 479 q16 430 427 372 372 q17 608 878 360 360 q18 7831720470287028 q19 21781051573 573 q20 329 344 220 220 q21 3675261623562356 q22 1071105310221022 Total cold run time: 116142 ms Total hot run time: 34108 ms - Round 2, with runtime_filter_mode=off - q1 5234506951135069 q2 243 323 220 220 q3 2144266323062306 q4 1405182414441444 q5 4498444944014401 q6 219 171 128 128 q7 2006190017151715 q8 2591265225952595 q9 7066717170707070 q10 2993315727722772 q11 577 514 488 488 q12 682 741 605 605 q13 3433391032713271 q14 269 316 275 275 q15 548 482 471 471 q16 438 494 450 450 q17 1174158713831383 q18 7620750573647364 q19 843 848 959 848 q20 1998207218771877 q21 4918440343674367 q22 1088105310281028 Total cold run time: 51987 ms Total hot run time: 50147 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2965336127 TPC-DS: Total hot run time: 185653 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 0ccea93a6c4ccbdde3163353a01f6cf3e48f39e0, data reload: false query1 1026481 501 481 query2 6571192619081908 query3 6755229 222 222 query4 26068 23679 22927 22927 query5 4353655 466 466 query6 315 232 200 200 query7 4624490 301 301 query8 270 233 213 213 query9 8609267226892672 query10 485 324 284 284 query11 15707 15029 14972 14972 query12 168 105 101 101 query13 1651544 428 428 query14 10504 617560616061 query15 205 184 175 175 query16 7463628 515 515 query17 1171708 555 555 query18 1986394 293 293 query19 188 174 157 157 query20 136 122 120 120 query21 212 120 102 102 query22 4134410140124012 query23 34040 32857 32932 32857 query24 7684236524152365 query25 520 454 395 395 query26 1225271 150 150 query27 2634466 333 333 query28 4358215521192119 query29 734 561 431 431 query30 283 218 195 195 query31 934 871 746 746 query32 73 65 63 63 query33 541 359 308 308 query34 819 814 533 533 query35 769 807 729 729 query36 963 1017873 873 query37 112 103 78 78 query38 4100416040154015 query39 1495160113961396 query40 211 119 110 110 query41 63 59 61 59 query42 146 116 113 113 query43 534 515 472 472 query44 1301859 833 833 query45 182 176 169 169 query46 828 1025627 627 query47 1781181617211721 query48 402 444 317 317 query49 763 492 425 425 query50 656 675 420 420 query51 4046422041014101 query52 119 115 106 106 query53 237 292 185 185 query54 565 566 492 492 query55 89 90 86 86 query56 305 287 286 286 query57 1191119211221122 query58 265 263 247 247 query59 2677281725712571 query60 324 314 300 300 query61 125 123 124 123 query62 808 742 645 645 query63 227 194 188 188 query64 42571046704 704 query65 4242418342094183 query66 1130408 322 322 query67 15947 15689 15433 15433 query68 8839875 533 533 query69 479 297 261 261 query70 1184109011071090 query71 459 329 309 309 query72 5474487148424842 query73 747 650 350 350 query74 9181916189358935 query75 4290320126952695 query76 37091185737 737 query77 784 365 300 300 query78 10001 10289 92819281 query79 1980842 584 584 query80 722 524 436 436 query81 460 254 220 220 query82 641 126 99 99 query83 289 264 239 239 query84 294 113 87 87 query85 804 363 315 315 query86 341 307 286 286 query87 4365442643434343 query88 2918230522822282 query89 403 334 283 283 query90 1939214 207 207 query91 142 146 113 113 query92 75 64 60 60 query93 1069932 585 585 query94 672 395 315 315 query95 378 301 286 286 query96 497 577 279 279 query97 2751277226732673 query98 220 224 210 210 query99 1464140813071307 Total cold run time: 274877 ms Total hot run time: 185653 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2965113691 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
yiguolei commented on code in PR #51486:
URL: https://github.com/apache/doris/pull/51486#discussion_r2141642033
##
be/src/vec/data_types/serde/data_type_datetimev2_serde.cpp:
##
@@ -36,6 +37,30 @@ namespace doris::vectorized {
static const int64_t micr_to_nano_second = 1000;
#include "common/compile_check_begin.h"
+Status DataTypeDateTimeV2SerDe::serialize_column_to_text(const IColumn&
column, int64_t row_num,
+ BufferWritable& bw)
const {
+DataTypeSerDe::write_left_quotation(bw);
+UInt64 int_val = assert_cast(column).get_element(row_num);
Review Comment:
这个函数接口是单个元素到stream 里，我们这个assert cast，默认是要检查类型是否一样的，会不会性能很差？
--
This is an automated message from the Apache Git Service.
To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2961198876 # BE Regression && UT Coverage Report Increment line coverage `81.10% (236/291)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/51486_29372635c193fff8a7d7ae8d87c9ce9ecb697e04_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/51486_29372635c193fff8a7d7ae8d87c9ce9ecb697e04_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 79.71% (20999/26345) | | Line Coverage | 72.69% (216917/298426) | | Region Coverage | 70.87% (127780/180302) | | Branch Coverage | 64.58% (66150/102424) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2960201658 # BE UT Coverage Report Increment line coverage `63.92% (186/291)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/29372635c193fff8a7d7ae8d87c9ce9ecb697e04_29372635c193fff8a7d7ae8d87c9ce9ecb697e04/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/29372635c193fff8a7d7ae8d87c9ce9ecb697e04_29372635c193fff8a7d7ae8d87c9ce9ecb697e04/report/index.html) | Category | Coverage | |---|| | Function Coverage | 56.41% (15098/26767) | | Line Coverage | 45.16% (134847/298595) | | Region Coverage | 44.25% (67820/153269) | | Branch Coverage | 38.80% (34763/89594) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2959910734 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2958716815 ClickBench: Total hot run time: 29.13 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 29372635c193fff8a7d7ae8d87c9ce9ecb697e04, data reload: false query1 0.040.040.03 query2 0.120.110.10 query3 0.260.200.20 query4 1.590.200.21 query5 0.440.410.44 query6 1.160.660.68 query7 0.020.020.01 query8 0.040.030.03 query9 0.580.510.51 query10 0.560.590.57 query11 0.160.110.10 query12 0.150.120.11 query13 0.610.600.60 query14 0.830.850.82 query15 0.870.860.85 query16 0.370.370.37 query17 1.031.041.00 query18 0.220.210.20 query19 1.931.841.80 query20 0.010.020.02 query21 15.41 0.880.56 query22 0.751.140.74 query23 14.84 1.390.68 query24 6.732.400.62 query25 0.510.190.13 query26 0.520.170.15 query27 0.060.050.04 query28 9.630.860.45 query29 12.96 4.023.35 query30 0.250.090.06 query31 2.840.610.39 query32 3.240.560.48 query33 2.993.063.09 query34 15.83 5.174.52 query35 4.564.534.50 query36 0.660.500.49 query37 0.090.070.06 query38 0.050.040.03 query39 0.030.030.02 query40 0.170.140.14 query41 0.080.020.02 query42 0.030.030.02 query43 0.040.040.03 Total cold run time: 103.26 s Total hot run time: 29.13 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2958692527 TPC-DS: Total hot run time: 192303 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 29372635c193fff8a7d7ae8d87c9ce9ecb697e04, data reload: false query1 1418108610651065 query2 6257191018971897 query3 11174 476446354635 query4 25164 23854 22916 22916 query5 4980650 495 495 query6 315 209 208 208 query7 3999528 285 285 query8 279 221 214 214 query9 8511264226172617 query10 498 336 280 280 query11 16047 15074 14743 14743 query12 157 111 104 104 query13 1549509 406 406 query14 9251622561376137 query15 196 190 188 188 query16 7608637 489 489 query17 1128730 619 619 query18 2028448 317 317 query19 198 196 180 180 query20 132 123 124 123 query21 210 126 106 106 query22 4404443543784378 query23 34524 33782 33598 33598 query24 8372239824232398 query25 508 458 404 404 query26 730 274 156 156 query27 2851514 343 343 query28 4601223721532153 query29 631 572 437 437 query30 299 235 192 192 query31 898 865 789 789 query32 71 64 66 64 query33 532 373 331 331 query34 815 879 554 554 query35 842 839 772 772 query36 982 986 922 922 query37 112 100 81 81 query38 4222428441754175 query39 1521144014951440 query40 211 122 109 109 query41 63 60 61 60 query42 132 118 112 112 query43 531 524 484 484 query44 1348856 839 839 query45 182 179 177 177 query46 843 1031645 645 query47 1812188217861786 query48 396 434 324 324 query49 685 518 436 436 query50 682 686 416 416 query51 4289429842424242 query52 116 113 101 101 query53 229 259 191 191 query54 591 601 528 528 query55 94 91 91 91 query56 335 331 313 313 query57 1218125211651165 query58 283 282 278 278 query59 2763278826832683 query60 339 360 325 325 query61 152 153 148 148 query62 813 745 670 670 query63 221 190 195 190 query64 30131046700 700 query65 4339423343024233 query66 801 486 320 320 query67 16124 15479 15367 15367 query68 9131893 525 525 query69 493 312 266 266 query70 1179109510591059 query71 473 325 299 299 query72 5732463947054639 query73 703 572 349 349 query74 9219890287518751 query75 4275319827022702 query76 37171196756 756 query77 786 373 278 278 query78 10105 10259 94389438 query79 2040781 572 572 query80 581 501 432 432 query81 493 260 218 218 query82 485 123 91 91 query83 255 252 230 230 query84 250 103 80 80 query85 783 339 311 311 query86 382 304 293 293 query87 4386445443684368 query88 3639226522462246 query89 399 314 284 284 query90 1850207 207 207 query91 144 147 113 113 query92 75 64 55 55 query93 1678933 582 582 query94 656 421 308 308 query95 379 292 282 282 query96 492 553 279 279 query97 2746273326372637 query98 232 218 230 218 query99 1436141012911291 Total cold run time: 279813 ms Total hot run time: 192303 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2958628727 TPC-H: Total hot run time: 33809 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 29372635c193fff8a7d7ae8d87c9ce9ecb697e04, data reload: false -- Round 1 -- q1 26476 510749994999 q2 1957282 188 188 q3 10383 1266682 682 q4 10222 990 540 540 q5 7571236023372337 q6 185 159 131 131 q7 884 717 636 636 q8 9313124010781078 q9 6709509850895089 q10 6868232118921892 q11 491 285 277 277 q12 344 344 220 220 q13 17782 373331343134 q14 239 226 205 205 q15 575 479 480 479 q16 430 425 371 371 q17 599 862 358 358 q18 7752718171427142 q19 1900969 561 561 q20 344 340 218 218 q21 3688255922902290 q22 10511022982 982 Total cold run time: 115763 ms Total hot run time: 33809 ms - Round 2, with runtime_filter_mode=off - q1 5184507250645064 q2 237 314 223 223 q3 2165264722812281 q4 1412179213741374 q5 4443437644314376 q6 222 169 132 132 q7 2061193217501750 q8 2599256325022502 q9 7155715269826982 q10 2933319527732773 q11 605 512 502 502 q12 701 780 661 661 q13 3479390933343334 q14 289 323 265 265 q15 539 485 473 473 q16 442 475 464 464 q17 1157154313541354 q18 7856766174247424 q19 784 828 862 828 q20 2008208819781978 q21 4798436643864366 q22 1082109610221022 Total cold run time: 52151 ms Total hot run time: 50128 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2958229463 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955929711 # BE Regression && UT Coverage Report Increment line coverage `64.26% (187/291)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/51486_f56048818377f7fc4bfb015a546376880dc2e9a1_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/51486_f56048818377f7fc4bfb015a546376880dc2e9a1_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 79.72% (20992/26332) | | Line Coverage | 72.69% (216861/298331) | | Region Coverage | 70.89% (12/180240) | | Branch Coverage | 64.60% (66126/102366) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955402595 ClickBench: Total hot run time: 29.12 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit f56048818377f7fc4bfb015a546376880dc2e9a1, data reload: false query1 0.030.040.03 query2 0.120.100.12 query3 0.250.200.19 query4 1.590.200.20 query5 0.470.440.44 query6 1.180.660.66 query7 0.020.020.02 query8 0.040.040.04 query9 0.580.550.51 query10 0.570.580.58 query11 0.160.110.11 query12 0.140.120.12 query13 0.610.590.61 query14 0.800.810.80 query15 0.870.860.87 query16 0.380.370.38 query17 1.041.081.03 query18 0.230.210.21 query19 1.911.881.82 query20 0.020.010.01 query21 15.39 0.880.54 query22 0.761.230.68 query23 14.86 1.350.64 query24 7.650.900.96 query25 0.410.160.05 query26 0.620.170.14 query27 0.050.040.05 query28 9.140.880.42 query29 12.56 4.033.34 query30 0.260.100.06 query31 2.810.620.39 query32 3.230.550.47 query33 3.003.033.04 query34 15.88 5.094.43 query35 4.504.554.50 query36 0.680.500.48 query37 0.080.060.06 query38 0.050.040.04 query39 0.030.020.02 query40 0.180.150.13 query41 0.080.030.02 query42 0.040.030.02 query43 0.030.030.03 Total cold run time: 103.3 s Total hot run time: 29.12 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955390956 TPC-DS: Total hot run time: 185795 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 f56048818377f7fc4bfb015a546376880dc2e9a1, data reload: false query1 999 471 489 471 query2 6560184418501844 query3 6760229 216 216 query4 26307 23852 23073 23073 query5 4395612 479 479 query6 311 202 198 198 query7 4641493 282 282 query8 264 228 218 218 query9 8624263026252625 query10 506 363 275 275 query11 15861 15260 15195 15195 query12 153 109 105 105 query13 1660501 407 407 query14 9285603661086036 query15 203 183 160 160 query16 7227641 502 502 query17 1167696 552 552 query18 1963420 300 300 query19 185 182 153 153 query20 120 118 121 118 query21 221 122 138 122 query22 4031402239883988 query23 34110 33167 33103 33103 query24 8402235223572352 query25 536 466 398 398 query26 1234269 151 151 query27 2751505 346 346 query28 4354213221122112 query29 779 544 435 435 query30 281 219 188 188 query31 950 828 766 766 query32 72 66 62 62 query33 553 358 319 319 query34 798 859 530 530 query35 768 799 727 727 query36 963 975 878 878 query37 110 109 77 77 query38 4094419140984098 query39 1488142314051405 query40 212 124 114 114 query41 68 65 75 65 query42 134 112 116 112 query43 510 516 492 492 query44 1302825 830 825 query45 184 175 170 170 query46 831 1023631 631 query47 1782181917441744 query48 388 440 333 333 query49 771 519 388 388 query50 645 666 393 393 query51 4087413040454045 query52 112 112 100 100 query53 221 247 176 176 query54 574 561 491 491 query55 82 86 84 84 query56 308 321 301 301 query57 1170120711241124 query58 262 256 256 256 query59 2629274125482548 query60 340 311 306 306 query61 122 121 124 121 query62 820 723 639 639 query63 223 184 183 183 query64 4345999 669 669 query65 4253411441894114 query66 1168400 311 311 query67 16000 15382 15635 15382 query68 7817872 533 533 query69 462 304 262 262 query70 1193112611471126 query71 431 326 302 302 query72 5715462545774577 query73 619 566 350 350 query74 8785924689988998 query75 3735320926942694 query76 34391275830 830 query77 791 378 301 301 query78 994110195 92559255 query79 2690810 583 583 query80 660 524 461 461 query81 503 257 229 229 query82 474 127 98 98 query83 257 250 236 236 query84 256 120 92 92 query85 825 349 322 322 query86 390 274 289 274 query87 4461436342904290 query88 3802231723202317 query89 380 319 288 288 query90 1887218 216 216 query91 142 139 113 113 query92 76 61 60 60 query93 2226952 588 588 query94 678 410 309 309 query95 375 297 288 288 query96 495 589 286 286 query97 2669273526652665 query98 239 217 205 205 query99 1392145112641264 Total cold run time: 275034 ms Total hot run time: 185795 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955387380 # BE UT Coverage Report Increment line coverage `16.84% (49/291)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/f56048818377f7fc4bfb015a546376880dc2e9a1_f56048818377f7fc4bfb015a546376880dc2e9a1/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/f56048818377f7fc4bfb015a546376880dc2e9a1_f56048818377f7fc4bfb015a546376880dc2e9a1/report/index.html) | Category | Coverage | |---|| | Function Coverage | 56.33% (15071/26753) | | Line Coverage | 45.12% (134680/298477) | | Region Coverage | 44.23% (67762/153215) | | Branch Coverage | 38.81% (34749/89542) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955364762 TPC-H: Total hot run time: 33693 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit f56048818377f7fc4bfb015a546376880dc2e9a1, data reload: false -- Round 1 -- q1 26281 500149704970 q2 1960288 183 183 q3 10402 1249725 725 q4 10249 1017513 513 q5 7671240722852285 q6 183 163 129 129 q7 875 744 614 614 q8 9310134310411041 q9 6715510850765076 q10 6845231918921892 q11 505 288 282 282 q12 343 350 220 220 q13 17759 367830633063 q14 227 222 212 212 q15 551 501 509 501 q16 426 430 369 369 q17 606 862 368 368 q18 8067714671277127 q19 1921965 565 565 q20 327 352 229 229 q21 3796315423622362 q22 1048998 967 967 Total cold run time: 116067 ms Total hot run time: 33693 ms - Round 2, with runtime_filter_mode=off - q1 5156505450595054 q2 242 317 221 221 q3 2219268023102310 q4 1364182714291429 q5 4579441943984398 q6 216 170 127 127 q7 2009192017061706 q8 2642255625452545 q9 7115709771297097 q10 2982320927862786 q11 582 504 501 501 q12 685 753 643 643 q13 3388383132283228 q14 276 319 270 270 q15 544 505 506 505 q16 434 491 435 435 q17 1149162713951395 q18 7801758574927492 q19 815 832 869 832 q20 1944206019251925 q21 4863424943344249 q22 10761026961 961 Total cold run time: 52081 ms Total hot run time: 50109 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2955086209 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2953546597 # BE Regression && UT Coverage Report Increment line coverage `63.89% (184/288)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/51486_aef7fc50e35587ee4abfa3913d5f0ca4567e0e04_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/51486_aef7fc50e35587ee4abfa3913d5f0ca4567e0e04_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage | 79.55% (20947/26331) | | Line Coverage | 72.68% (216804/298311) | | Region Coverage | 70.83% (127636/180202) | | Branch Coverage | 64.54% (66065/102368) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2953536188 # BE UT Coverage Report Increment line coverage `15.97% (46/288)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/aef7fc50e35587ee4abfa3913d5f0ca4567e0e04_aef7fc50e35587ee4abfa3913d5f0ca4567e0e04/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/aef7fc50e35587ee4abfa3913d5f0ca4567e0e04_aef7fc50e35587ee4abfa3913d5f0ca4567e0e04/report/index.html) | Category | Coverage | |---|| | Function Coverage | 56.33% (15070/26752) | | Line Coverage | 45.12% (134665/298461) | | Region Coverage | 44.24% (67775/153200) | | Branch Coverage | 38.80% (34745/89538) | -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2953432187 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2952646291 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2949817710 ClickBench: Total hot run time: 28.86 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit aef7fc50e35587ee4abfa3913d5f0ca4567e0e04, data reload: false query1 0.040.040.03 query2 0.120.110.10 query3 0.250.190.20 query4 1.590.190.12 query5 0.430.410.43 query6 1.150.650.66 query7 0.030.010.01 query8 0.040.040.03 query9 0.580.510.51 query10 0.580.570.57 query11 0.160.100.10 query12 0.150.110.11 query13 0.610.600.59 query14 0.800.820.81 query15 0.880.860.85 query16 0.390.380.37 query17 0.991.061.06 query18 0.220.210.20 query19 1.881.791.79 query20 0.010.010.02 query21 15.40 0.890.57 query22 0.771.220.65 query23 14.96 1.350.63 query24 7.211.220.78 query25 0.540.120.17 query26 0.600.160.14 query27 0.050.050.05 query28 8.990.890.44 query29 12.60 3.983.26 query30 0.260.100.06 query31 2.820.590.38 query32 3.230.540.46 query33 3.153.083.08 query34 15.64 5.084.46 query35 4.484.554.47 query36 0.670.510.47 query37 0.090.070.06 query38 0.050.040.04 query39 0.040.030.02 query40 0.170.140.14 query41 0.080.030.02 query42 0.030.030.02 query43 0.040.030.03 Total cold run time: 102.77 s Total hot run time: 28.86 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2949805795 TPC-DS: Total hot run time: 186047 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 aef7fc50e35587ee4abfa3913d5f0ca4567e0e04, data reload: false query1 1016481 502 481 query2 6608186117871787 query3 6756224 217 217 query4 26072 23581 23264 23264 query5 4354604 444 444 query6 321 196 198 196 query7 4616496 296 296 query8 253 221 206 206 query9 8609262626162616 query10 498 347 279 279 query11 15931 15055 15221 15055 query12 160 107 107 107 query13 1655532 401 401 query14 8853615261716152 query15 203 197 174 174 query16 7164655 513 513 query17 1209721 574 574 query18 1971417 304 304 query19 200 191 179 179 query20 125 118 118 118 query21 217 122 118 118 query22 4000412241134113 query23 34145 32997 33029 32997 query24 8536241023722372 query25 527 469 393 393 query26 1231271 148 148 query27 2739499 341 341 query28 4355214521202120 query29 777 571 428 428 query30 284 221 184 184 query31 916 842 758 758 query32 76 66 64 64 query33 550 383 335 335 query34 790 850 542 542 query35 774 813 725 725 query36 934 998 862 862 query37 115 101 77 77 query38 4189411940304030 query39 1506137814111378 query40 217 119 104 104 query41 63 60 59 59 query42 134 107 104 104 query43 486 501 469 469 query44 1325836 831 831 query45 192 181 175 175 query46 848 1026612 612 query47 1791182917171717 query48 400 414 310 310 query49 737 498 396 396 query50 656 669 392 392 query51 4157408841564088 query52 114 106 101 101 query53 228 250 185 185 query54 579 593 499 499 query55 87 85 80 80 query56 324 306 274 274 query57 1156114510711071 query58 265 260 248 248 query59 2694264325762576 query60 327 317 307 307 query61 136 126 121 121 query62 822 736 656 656 query63 226 182 188 182 query64 43481033680 680 query65 4229413841384138 query66 1157423 328 328 query67 15711 15672 15379 15379 query68 8321903 521 521 query69 479 312 273 273 query70 1210107111211071 query71 471 326 309 309 query72 5377471048154710 query73 735 641 352 352 query74 9137916491729164 query75 3830320027032703 query76 36481182732 732 query77 783 370 282 282 query78 10026 10250 92899289 query79 2137842 576 576 query80 589 524 529 524 query81 485 262 217 217 query82 465 125 99 99 query83 255 246 240 240 query84 252 104 95 95 query85 779 366 318 318 query86 394 297 278 278 query87 4386445943314331 query88 3655230722912291 query89 390 322 280 280 query90 1880214 218 214 query91 154 141 111 111 query92 76 62 63 62 query93 1601981 581 581 query94 669 417 312 312 query95 370 287 297 287 query96 499 573 282 282 query97 2737271326392639 query98 236 211 201 201 query99 1423139712731273 Total cold run time: 274093 ms Total hot run time: 186047 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to
Re: [PR] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2949779982 TPC-H: Total hot run time: 33963 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit aef7fc50e35587ee4abfa3913d5f0ca4567e0e04, data reload: false -- Round 1 -- q1 26539 563651245124 q2 1962303 191 191 q3 10413 1285722 722 q4 10241 995 524 524 q5 7683241422892289 q6 182 166 133 133 q7 891 728 612 612 q8 9326130511441144 q9 6833512450915091 q10 6877232118911891 q11 490 317 279 279 q12 352 362 216 216 q13 17761 367831083108 q14 238 230 208 208 q15 566 482 493 482 q16 438 435 369 369 q17 620 865 388 388 q18 7820729070117011 q19 1525969 586 586 q20 350 339 223 223 q21 3841320824042404 q22 10291031968 968 Total cold run time: 115977 ms Total hot run time: 33963 ms - Round 2, with runtime_filter_mode=off - q1 5486505250915052 q2 247 315 225 225 q3 2171261423042304 q4 1375185615521552 q5 4536442443604360 q6 210 169 123 123 q7 2037195617791779 q8 2576259525242524 q9 7158716471737164 q10 2980318227322732 q11 589 522 495 495 q12 699 782 616 616 q13 3532390832483248 q14 276 303 266 266 q15 531 481 477 477 q16 442 491 450 450 q17 1163161513231323 q18 7679754074377437 q19 809 868 962 868 q20 1992209418551855 q21 4749435043574350 q22 10551016976 976 Total cold run time: 52292 ms Total hot run time: 50176 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2949462656 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2944944728 run beut -- This is an automated message from the Apache Git Service. To 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2944253742 ClickBench: Total hot run time: 29.37 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit b28a51835ab3d456f0553e72836364f5d67d5fbf, data reload: false query1 0.050.040.03 query2 0.110.110.12 query3 0.260.190.20 query4 1.590.200.19 query5 0.440.460.44 query6 1.150.680.66 query7 0.020.020.01 query8 0.050.040.04 query9 0.600.520.51 query10 0.570.590.57 query11 0.150.110.11 query12 0.150.110.12 query13 0.620.590.60 query14 0.800.820.78 query15 0.880.850.88 query16 0.390.370.39 query17 1.041.011.02 query18 0.220.200.20 query19 1.891.901.79 query20 0.010.010.01 query21 15.40 0.910.55 query22 0.751.340.81 query23 14.72 1.380.60 query24 7.401.540.92 query25 0.470.250.15 query26 0.560.170.13 query27 0.050.050.05 query28 9.320.920.44 query29 12.65 4.053.35 query30 0.250.090.06 query31 2.820.600.39 query32 3.230.540.48 query33 2.983.093.10 query34 15.79 5.094.48 query35 4.544.504.50 query36 0.660.510.48 query37 0.090.060.07 query38 0.050.040.04 query39 0.030.020.02 query40 0.160.130.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 103.07 s Total hot run time: 29.37 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2944225532 TPC-DS: Total hot run time: 192673 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 b28a51835ab3d456f0553e72836364f5d67d5fbf, data reload: false query1 1429108910491049 query2 6239190818631863 query3 10987 447645454476 query4 53858 26321 23514 23514 query5 4906585 457 457 query6 382 236 203 203 query7 4909520 295 295 query8 296 235 215 215 query9 5538265826512651 query10 432 334 279 279 query11 15101 15321 14810 14810 query12 157 119 106 106 query13 1046528 405 405 query14 10191 639263096309 query15 213 217 214 214 query16 7159648 508 508 query17 1103769 571 571 query18 1533424 314 314 query19 192 189 167 167 query20 137 128 122 122 query21 241 125 108 108 query22 4367447843104310 query23 34298 33512 33622 33512 query24 6888241024252410 query25 459 467 430 430 query26 711 286 155 155 query27 2274519 341 341 query28 3049220321562156 query29 579 569 424 424 query30 275 215 191 191 query31 831 855 813 813 query32 73 65 66 65 query33 454 368 322 322 query34 778 866 542 542 query35 813 867 753 753 query36 968 1019916 916 query37 109 114 84 84 query38 4228437242134213 query39 1507146715011467 query40 221 121 116 116 query41 59 56 55 55 query42 129 110 106 106 query43 526 511 492 492 query44 1322829 837 829 query45 184 172 174 172 query46 851 1034663 663 query47 1849188018051805 query48 386 425 317 317 query49 680 497 395 395 query50 665 704 415 415 query51 4330423442484234 query52 113 114 104 104 query53 225 265 186 186 query54 576 572 518 518 query55 84 86 89 86 query56 303 322 288 288 query57 1147120511281128 query58 264 253 252 252 query59 2778286527822782 query60 332 327 306 306 query61 126 120 125 120 query62 728 740 666 666 query63 240 194 194 194 query64 18091089702 702 query65 4218414541634145 query66 710 407 306 306 query67 16101 15561 15341 15341 query68 7248881 514 514 query69 546 313 275 275 query70 1213112411291124 query71 507 316 306 306 query72 6011478047114711 query73 1472621 353 353 query74 9307879489128794 query75 4020318726952695 query76 42021190744 744 query77 739 361 340 340 query78 10011 10208 93409340 query79 2618802 585 585 query80 604 512 433 433 query81 490 254 225 225 query82 440 125 95 95 query83 293 256 226 226 query84 296 105 92 92 query85 862 354 324 324 query86 362 298 282 282 query87 4358442743394339 query88 3573224422362236 query89 406 306 284 284 query90 1850210 199 199 query91 140 140 111 111 query92 77 61 58 58 query93 1964922 566 566 query94 673 416 304 304 query95 374 291 290 290 query96 494 572 280 280 query97 2731275426252625 query98 232 202 199 199 query99 1431140412611261 Total cold run time: 299210 ms Total hot run time: 192673 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
doris-robot commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2944168957 TPC-H: Total hot run time: 33720 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit b28a51835ab3d456f0553e72836364f5d67d5fbf, data reload: false -- Round 1 -- q1 26260 507049984998 q2 1965281 175 175 q3 10430 1255675 675 q4 10221 1003497 497 q5 7651232923712329 q6 182 162 131 131 q7 924 740 614 614 q8 9316132411581158 q9 6790502850615028 q10 6880232318991899 q11 490 290 286 286 q12 345 356 208 208 q13 17768 366330653065 q14 235 234 210 210 q15 571 481 490 481 q16 438 438 375 375 q17 602 858 368 368 q18 7553716371507150 q19 23741371557 557 q20 330 331 219 219 q21 3647312823222322 q22 10261020975 975 Total cold run time: 115998 ms Total hot run time: 33720 ms - Round 2, with runtime_filter_mode=off - q1 5231504450435043 q2 231 316 232 232 q3 2100262722592259 q4 1344178213361336 q5 4499438044284380 q6 221 165 129 129 q7 2026195117311731 q8 2598261225302530 q9 7267725769766976 q10 3017319227802780 q11 573 522 500 500 q12 679 800 633 633 q13 3540388331963196 q14 281 313 291 291 q15 528 475 471 471 q16 461 501 427 427 q17 1136160313291329 q18 7728760374697469 q19 805 785 830 785 q20 1999214018361836 q21 4846452743834383 q22 1098106110171017 Total cold run time: 52208 ms Total hot run time: 49733 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2943718956 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2942622707 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2942182178 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
Mryange commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2939451904 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] [Refactor](SerDe) use DataTypeSerDe to serialize column to text [doris]
hello-stephen commented on PR #51486: URL: https://github.com/apache/doris/pull/51486#issuecomment-2939451598 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]
