Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2999558877 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2934814969 ClickBench: Total hot run time: 29.61 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 33b38de20a9d48b3ecf31f31c0db822938adb568, data reload: false query1 0.040.040.03 query2 0.120.110.10 query3 0.250.190.19 query4 1.600.200.19 query5 0.440.460.43 query6 1.480.650.65 query7 0.030.010.01 query8 0.040.040.04 query9 0.580.520.50 query10 0.580.590.56 query11 0.160.110.11 query12 0.150.110.12 query13 0.620.600.60 query14 0.790.830.79 query15 0.890.850.87 query16 0.400.380.37 query17 1.051.041.06 query18 0.230.220.21 query19 1.861.801.82 query20 0.020.010.01 query21 15.77 0.900.55 query22 0.871.010.80 query23 15.06 1.400.59 query24 6.801.161.55 query25 0.490.200.07 query26 0.630.160.15 query27 0.050.060.05 query28 10.06 0.890.45 query29 12.63 4.033.36 query30 0.240.090.06 query31 2.820.590.39 query32 3.220.550.47 query33 3.043.103.16 query34 15.94 5.154.53 query35 4.514.494.54 query36 0.670.500.47 query37 0.080.060.07 query38 0.050.040.04 query39 0.030.030.02 query40 0.170.130.13 query41 0.080.030.03 query42 0.030.030.02 query43 0.040.040.03 Total cold run time: 104.61 s Total hot run time: 29.61 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2934751165 TPC-H: Total hot run time: 34136 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 33b38de20a9d48b3ecf31f31c0db822938adb568, data reload: false -- Round 1 -- q1 26167 505250565052 q2 1963275 180 180 q3 10404 1261677 677 q4 10235 1023536 536 q5 7738237723482348 q6 191 165 134 134 q7 926 732 613 613 q8 93071288 q9 6761514951645149 q10 6830231218921892 q11 479 287 270 270 q12 352 364 221 221 q13 17789 372531733173 q14 226 224 216 216 q15 557 489 493 489 q16 422 431 381 381 q17 604 862 361 361 q18 7541733572227222 q19 1878971 558 558 q20 333 332 215 215 q21 3735261023632363 q22 10681063975 975 Total cold run time: 115506 ms Total hot run time: 34136 ms - Round 2, with runtime_filter_mode=off - q1 5266513851765138 q2 238 319 218 218 q3 2163266223102310 q4 1348182313771377 q5 439743934393 q6 223 183 133 133 q7 1999191817811781 q8 2604257725522552 q9 7233723468766876 q10 3057321927882788 q11 581 525 503 503 q12 673 771 609 609 q13 3481395132763276 q14 287 304 290 290 q15 527 471 482 471 q16 451 507 444 444 q17 1149153714261426 q18 7846762975047504 q19 832 826 844 826 q20 1978205818481848 q21 4827453143684368 q22 1124106310431043 Total cold run time: 52331 ms Total hot run time: 50174 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2934791249 TPC-DS: Total hot run time: 193107 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 33b38de20a9d48b3ecf31f31c0db822938adb568, data reload: false query1 1402107410621062 query2 6364182618061806 query3 11154 466545974597 query4 25160 23327 23450 23327 query5 4216629 474 474 query6 332 213 205 205 query7 3998509 286 286 query8 276 219 226 219 query9 8494266926572657 query10 483 342 264 264 query11 15711 15167 14785 14785 query12 172 113 111 111 query13 1566539 414 414 query14 9328632063676320 query15 203 194 171 171 query16 7421628 470 470 query17 1205747 655 655 query18 2093424 345 345 query19 215 205 171 171 query20 129 123 121 121 query21 214 129 121 121 query22 4536456342614261 query23 34620 33921 33578 33578 query24 8445241524582415 query25 551 470 398 398 query26 1352277 156 156 query27 3096521 370 370 query28 4519222521972197 query29 689 577 462 462 query30 272 229 196 196 query31 894 857 815 815 query32 72 68 63 63 query33 562 367 319 319 query34 944 861 539 539 query35 833 856 805 805 query36 950 1007911 911 query37 120 103 77 77 query38 4283433342284228 query39 1516143914491439 query40 206 128 111 111 query41 61 56 80 56 query42 128 116 111 111 query43 497 512 498 498 query44 1335836 828 828 query45 175 178 168 168 query46 838 1029675 675 query47 1871187017971797 query48 391 440 329 329 query49 728 490 404 404 query50 666 701 415 415 query51 4281429242684268 query52 116 107 101 101 query53 230 257 188 188 query54 597 602 530 530 query55 89 85 80 80 query56 315 305 295 295 query57 1159121611721172 query58 275 266 269 266 query59 2666266026552655 query60 320 316 310 310 query61 125 122 122 122 query62 799 724 670 670 query63 228 191 182 182 query64 39571012722 722 query65 4252417742164177 query66 984 409 298 298 query67 15799 15469 15423 15423 query68 8309880 519 519 query69 468 308 269 269 query70 1186112411131113 query71 451 308 281 281 query72 5697478648824786 query73 573 579 359 359 query74 8943885591398855 query75 4092321327212721 query76 36711199762 762 query77 907 369 288 288 query78 10217 998393859385 query79 3503825 567 567 query80 657 565 450 450 query81 488 251 217 217 query82 589 124 96 96 query83 284 248 236 236 query84 295 112 87 87 query85 787 355 319 319 query86 337 297 287 287 query87 4420449043404340 query88 3669232422402240 query89 426 321 295 295 query90 1932222 206 206 query91 147 139 111 111 query92 73 61 52 52 query93 2668958 587 587 query94 692 402 318 318 query95 379 299 289 289 query96 492 557 282 282 query97 2773277726462646 query98 233 205 220 205 query99 1434140112781278 Total cold run time: 282270 ms Total hot run time: 193107 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] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2934453934 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2829293591 ClickBench: Total hot run time: 29.91 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 97464c03bc4d27df1998d43ded416add35691e93, data reload: false query1 0.040.040.02 query2 0.120.100.12 query3 0.250.190.19 query4 1.590.200.19 query5 0.600.590.60 query6 1.180.720.73 query7 0.020.020.01 query8 0.040.030.04 query9 0.570.520.51 query10 0.560.580.56 query11 0.150.110.11 query12 0.140.110.11 query13 0.620.600.60 query14 1.161.211.18 query15 0.880.850.86 query16 0.380.390.38 query17 1.021.041.07 query18 0.210.200.20 query19 1.971.821.80 query20 0.020.010.01 query21 15.40 0.890.57 query22 0.761.130.95 query23 14.68 1.380.62 query24 7.001.410.86 query25 0.490.290.06 query26 0.530.160.14 query27 0.050.050.04 query28 8.990.870.43 query29 12.78 3.983.30 query30 0.250.100.07 query31 2.810.600.39 query32 3.220.560.46 query33 3.013.133.07 query34 15.81 5.094.46 query35 4.504.554.49 query36 0.700.490.49 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.02 query43 0.040.040.03 Total cold run time: 103 s Total hot run time: 29.91 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2829289060 TPC-DS: Total hot run time: 192559 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 97464c03bc4d27df1998d43ded416add35691e93, data reload: false query1 1412108810611061 query2 6221183318551833 query3 11036 455444064406 query4 55061 25763 23512 23512 query5 5129595 467 467 query6 345 226 200 200 query7 4897504 300 300 query8 323 265 245 245 query9 5780257925852579 query10 421 314 244 244 query11 15028 14923 14816 14816 query12 161 119 100 100 query13 1034502 389 389 query14 10140 622162926221 query15 193 190 174 174 query16 7060647 489 489 query17 1078756 567 567 query18 1545401 315 315 query19 193 189 162 162 query20 130 127 125 125 query21 203 137 109 109 query22 4399455344074407 query23 34288 33354 33443 33354 query24 6675242924462429 query25 450 471 402 402 query26 667 284 172 172 query27 2166497 358 358 query28 3161218921772177 query29 566 561 426 426 query30 275 216 195 195 query31 856 854 748 748 query32 77 63 66 63 query33 462 372 320 320 query34 787 899 513 513 query35 793 847 738 738 query36 949 984 892 892 query37 111 103 86 86 query38 4203432241894189 query39 1493142814551428 query40 225 117 106 106 query41 55 58 52 52 query42 117 108 143 108 query43 488 540 475 475 query44 1335809 805 805 query45 181 177 170 170 query46 840 1031643 643 query47 1875185218131813 query48 384 429 303 303 query49 685 521 442 442 query50 677 691 429 429 query51 4197422643034226 query52 113 105 103 103 query53 236 255 188 188 query54 596 589 518 518 query55 84 81 82 81 query56 302 305 293 293 query57 1165120011121112 query58 267 262 257 257 query59 2663276325712571 query60 326 335 309 309 query61 168 130 126 126 query62 725 771 695 695 query63 227 190 206 190 query64 14961019698 698 query65 4478433342294229 query66 716 406 303 303 query67 15814 15450 15506 15450 query68 5733879 515 515 query69 530 299 263 263 query70 12221113 query71 438 304 303 303 query72 6011481648924816 query73 1267674 350 350 query74 9278916786578657 query75 3190320627782778 query76 38351196761 761 query77 533 378 280 280 query78 10132 10143 93099309 query79 2438796 568 568 query80 729 502 441 441 query81 499 260 223 223 query82 421 123 99 99 query83 251 250 231 231 query84 292 114 84 84 query85 747 412 307 307 query86 379 304 279 279 query87 4299440543384338 query88 3238225022152215 query89 391 323 278 278 query90 1612210 219 210 query91 154 156 110 110 query92 77 60 58 58 query93 2768945 584 584 query94 762 414 324 324 query95 371 305 284 284 query96 485 559 277 277 query97 3132322431173117 query98 256 214 201 201 query99 1310142012821282 Total cold run time: 296983 ms Total hot run time: 192559 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] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2829278221 TPC-H: Total hot run time: 33807 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 97464c03bc4d27df1998d43ded416add35691e93, data reload: false -- Round 1 -- q1 26205 506550265026 q2 2067273 186 186 q3 10397 1286690 690 q4 10240 1003514 514 q5 7524237323342334 q6 173 161 130 130 q7 912 742 603 603 q8 9296129210101010 q9 6870514851115111 q10 6826228318811881 q11 473 284 272 272 q12 347 353 216 216 q13 17783 368430453045 q14 220 223 209 209 q15 543 485 498 485 q16 449 456 400 400 q17 597 864 354 354 q18 7562726470907090 q19 16031086566 566 q20 321 324 213 213 q21 3955337724942494 q22 1049992 978 978 Total cold run time: 115412 ms Total hot run time: 33807 ms - Round 2, with runtime_filter_mode=off - q1 5122509755195097 q2 239 322 226 226 q3 2185266823132313 q4 1478188014601460 q5 443044104410 q6 212 174 126 126 q7 2028193917091709 q8 2596260424802480 q9 7241726370457045 q10 3028318427302730 q11 585 516 484 484 q12 752 769 635 635 q13 3460385732813281 q14 308 313 280 280 q15 515 473 469 469 q16 460 516 468 468 q17 1152149814121412 q18 7739769474597459 q19 796 798 954 798 q20 1971208718301830 q21 5227485348954853 q22 1109109210181018 Total cold run time: 52633 ms Total hot run time: 50583 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2829226770 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2817945077 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 65d32d218b08b343928d65024081315c5f52b60b, data reload: false query1 0.040.040.04 query2 0.140.100.10 query3 0.250.200.20 query4 1.590.190.20 query5 0.590.590.61 query6 1.160.720.71 query7 0.030.020.02 query8 0.040.030.03 query9 0.560.520.51 query10 0.560.570.56 query11 0.150.110.10 query12 0.140.110.11 query13 0.620.600.60 query14 1.151.171.21 query15 0.860.850.87 query16 0.390.390.38 query17 1.061.051.01 query18 0.210.210.19 query19 1.921.751.76 query20 0.020.010.01 query21 15.40 0.910.56 query22 0.741.190.72 query23 14.85 1.380.58 query24 7.860.770.65 query25 0.560.230.07 query26 0.590.160.14 query27 0.060.050.05 query28 8.990.880.42 query29 12.53 3.943.34 query30 0.260.090.07 query31 2.830.590.38 query32 3.230.540.47 query33 3.033.033.08 query34 15.49 5.034.45 query35 4.464.494.49 query36 0.670.490.50 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.160.140.14 query41 0.080.030.03 query42 0.040.020.02 query43 0.040.040.03 Total cold run time: 103.52 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2817937117 TPC-DS: Total hot run time: 185631 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 65d32d218b08b343928d65024081315c5f52b60b, data reload: false query1 1041466 505 466 query2 6574181918091809 query3 6741220 219 219 query4 26226 23872 23091 23091 query5 4323625 478 478 query6 329 205 175 175 query7 4618471 281 281 query8 294 238 222 222 query9 8602254625642546 query10 480 314 267 267 query11 15235 15086 14930 14930 query12 159 110 111 110 query13 1657490 393 393 query14 8713619561756175 query15 221 186 164 164 query16 7119646 491 491 query17 910 732 571 571 query18 1970400 311 311 query19 190 187 157 157 query20 119 114 126 114 query21 218 124 141 124 query22 4282422544224225 query23 33999 32856 33025 32856 query24 8409237223842372 query25 521 448 391 391 query26 1228265 150 150 query27 2763492 318 318 query28 4368210120942094 query29 768 533 423 423 query30 275 210 195 195 query31 882 867 740 740 query32 69 62 68 62 query33 565 358 333 333 query34 784 823 516 516 query35 794 816 726 726 query36 954 1005898 898 query37 112 98 76 76 query38 4150414841334133 query39 1439140513971397 query40 209 115 108 108 query41 63 57 87 57 query42 115 107 106 106 query43 480 484 493 484 query44 1311793 788 788 query45 182 172 171 171 query46 832 1004610 610 query47 1736179317271727 query48 363 404 293 293 query49 767 553 433 433 query50 641 669 395 395 query51 4118423041864186 query52 116 100 99 99 query53 225 255 182 182 query54 565 554 502 502 query55 83 84 81 81 query56 289 290 282 282 query57 1130116110621062 query58 261 244 253 244 query59 2618268725202520 query60 307 320 315 315 query61 147 123 126 123 query62 803 741 657 657 query63 242 181 183 181 query64 44031084752 752 query65 4392426442364236 query66 1160421 324 324 query67 15856 15313 15375 15313 query68 7830881 515 515 query69 478 300 272 272 query70 1156111310951095 query71 452 315 295 295 query72 5701471649324716 query73 733 664 334 334 query74 8847925687548754 query75 3774321026742674 query76 35591185772 772 query77 797 357 286 286 query78 10006 10176 92839283 query79 2397862 566 566 query80 620 491 434 434 query81 462 263 216 216 query82 421 136 100 100 query83 285 242 230 230 query84 297 105 87 87 query85 782 348 310 310 query86 333 301 293 293 query87 4412443943134313 query88 3420218521982185 query89 391 317 277 277 query90 1930213 215 213 query91 140 142 119 119 query92 84 60 57 57 query93 1175949 589 589 query94 675 406 285 285 query95 373 290 290 290 query96 477 558 276 276 query97 3130319930803080 query98 235 210 203 203 query99 1467142812821282 Total cold run time: 272354 ms Total hot run time: 185631 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] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2817918938 TPC-H: Total hot run time: 33960 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 65d32d218b08b343928d65024081315c5f52b60b, data reload: false -- Round 1 -- q1 26007 514750365036 q2 2061287 186 186 q3 10426 1249700 700 q4 10259 1023556 556 q5 8230242723832383 q6 193 167 133 133 q7 916 753 625 625 q8 9321130310571057 q9 6703509250925092 q10 6810228518611861 q11 487 285 267 267 q12 342 347 216 216 q13 17768 366430613061 q14 222 235 205 205 q15 527 489 485 485 q16 454 451 402 402 q17 595 856 351 351 q18 7672721771297129 q19 1428939 576 576 q20 334 348 221 221 q21 3966333524412441 q22 10221008977 977 Total cold run time: 115743 ms Total hot run time: 33960 ms - Round 2, with runtime_filter_mode=off - q1 5263510051055100 q2 242 329 232 232 q3 2168263923232323 q4 1406181914261426 q5 4557444944574449 q6 210 166 125 125 q7 1946188017141714 q8 2589260025262526 q9 7216702170877021 q10 2958315527462746 q11 593 516 493 493 q12 677 836 625 625 q13 3503391932603260 q14 296 306 265 265 q15 523 482 484 482 q16 458 510 475 475 q17 1148146714651465 q18 7732758573717371 q19 808 860 964 860 q20 2018200218571857 q21 5185477546264626 q22 10581018985 985 Total cold run time: 52554 ms Total hot run time: 50426 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2817869939 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2812382160 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2812467385 ClickBench: Total hot run time: 29 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit c47f5635f9bf9676780e1bd12f9a64a7c9e2b0e0, data reload: false query1 0.030.030.03 query2 0.120.110.11 query3 0.240.200.18 query4 1.590.190.20 query5 0.610.590.58 query6 1.190.740.72 query7 0.020.020.02 query8 0.040.030.03 query9 0.580.530.51 query10 0.570.570.56 query11 0.160.100.10 query12 0.150.100.11 query13 0.630.600.59 query14 1.161.181.17 query15 0.880.850.85 query16 0.380.390.38 query17 1.020.981.00 query18 0.210.200.19 query19 1.871.821.78 query20 0.010.010.02 query21 15.40 0.890.53 query22 0.751.270.74 query23 14.76 1.380.59 query24 6.931.970.30 query25 0.290.110.08 query26 0.630.160.15 query27 0.050.050.05 query28 9.320.890.44 query29 12.58 3.993.30 query30 0.270.090.07 query31 2.830.600.39 query32 3.230.550.47 query33 2.993.123.11 query34 15.79 5.094.46 query35 4.544.444.47 query36 0.660.500.49 query37 0.080.060.06 query38 0.050.040.03 query39 0.030.030.02 query40 0.170.140.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 102.96 s Total hot run time: 29 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2812456754 TPC-DS: Total hot run time: 185468 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 c47f5635f9bf9676780e1bd12f9a64a7c9e2b0e0, data reload: false query1 994 470 481 470 query2 6567179517461746 query3 6745212 213 212 query4 28032 23908 23703 23703 query5 4396623 462 462 query6 297 214 201 201 query7 4624488 278 278 query8 315 251 248 248 query9 8630255125672551 query10 470 301 266 266 query11 15663 15097 14878 14878 query12 160 109 104 104 query13 1643506 384 384 query14 9269615661096109 query15 192 184 166 166 query16 7217639 466 466 query17 1184686 549 549 query18 1961384 292 292 query19 180 200 155 155 query20 126 119 111 111 query21 206 119 105 105 query22 4090409741284097 query23 33850 32992 33016 32992 query24 8495239123912391 query25 557 470 429 429 query26 1252277 191 191 query27 2705494 326 326 query28 4383209620772077 query29 741 545 413 413 query30 292 205 189 189 query31 945 840 779 779 query32 71 60 63 60 query33 546 370 299 299 query34 780 871 543 543 query35 798 790 754 754 query36 939 995 918 918 query37 118 106 79 79 query38 4146403940994039 query39 1440139814081398 query40 208 129 104 104 query41 57 52 62 52 query42 124 104 102 102 query43 477 505 479 479 query44 1270806 802 802 query45 175 173 172 172 query46 829 1032622 622 query47 1762177616961696 query48 375 402 301 301 query49 800 523 407 407 query50 640 688 397 397 query51 4126413540674067 query52 104 105 102 102 query53 231 255 179 179 query54 569 573 497 497 query55 92 82 84 82 query56 292 281 289 281 query57 1143119210661066 query58 269 255 254 254 query59 2576266524912491 query60 318 307 293 293 query61 160 131 127 127 query62 886 725 651 651 query63 222 182 187 182 query64 43451009674 674 query65 4330426041904190 query66 1130410 312 312 query67 15559 15145 15351 15145 query68 7042861 513 513 query69 504 310 259 259 query70 1196117211011101 query71 420 325 292 292 query72 5195468146094609 query73 615 575 339 339 query74 8998897988238823 query75 3157316626482648 query76 32201184758 758 query77 490 377 284 284 query78 992110142 92359235 query79 1364798 556 556 query80 648 524 483 483 query81 477 270 222 222 query82 213 131 100 100 query83 261 260 242 242 query84 257 114 90 90 query85 837 418 412 412 query86 311 305 298 298 query87 4326455342184218 query88 2743217521852175 query89 384 315 277 277 query90 1778206 215 206 query91 145 148 111 111 query92 64 57 54 54 query93 974 930 569 569 query94 632 394 300 300 query95 364 284 280 280 query96 485 566 269 269 query97 3095319430983098 query98 231 213 204 204 query99 1311141312861286 Total cold run time: 269746 ms Total hot run time: 185468 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] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2812433377 TPC-H: Total hot run time: 33802 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit c47f5635f9bf9676780e1bd12f9a64a7c9e2b0e0, data reload: false -- Round 1 -- q1 26096 515450645064 q2 2076289 180 180 q3 10513 1248680 680 q4 10286 985 542 542 q5 8828239423682368 q6 182 177 137 137 q7 913 795 606 606 q8 9340126411041104 q9 6733508651135086 q10 6797230818621862 q11 496 274 269 269 q12 349 353 225 225 q13 17766 360330773077 q14 219 230 211 211 q15 533 482 497 482 q16 445 449 396 396 q17 604 861 359 359 q18 7688706769626962 q19 1367960 571 571 q20 343 325 217 217 q21 3826339724422442 q22 1021985 962 962 Total cold run time: 116421 ms Total hot run time: 33802 ms - Round 2, with runtime_filter_mode=off - q1 5172510450735073 q2 232 325 232 232 q3 2120263922842284 q4 1453184914601460 q5 4510442243474347 q6 210 165 125 125 q7 1975188517451745 q8 2583259625252525 q9 7117722571757175 q10 2978317227162716 q11 571 492 497 492 q12 691 776 604 604 q13 3456385732513251 q14 285 296 263 263 q15 519 466 470 466 q16 457 509 460 460 q17 1157160413931393 q18 7748751872817281 q19 826 821 846 821 q20 1998200118741874 q21 5213472146134613 q22 995 1005999 999 Total cold run time: 52266 ms Total hot run time: 50199 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2807059450 # BE UT Coverage Report Increment line coverage `100.00% (11/11)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/1cf00b8e287c988952d74a5d1b29522b87eb8cfd_1cf00b8e287c988952d74a5d1b29522b87eb8cfd/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/1cf00b8e287c988952d74a5d1b29522b87eb8cfd_1cf00b8e287c988952d74a5d1b29522b87eb8cfd/report/index.html) | Category | Coverage | |---|| | Function Coverage | 52.43% (14107/26908) | | Line Coverage | 41.34% (122316/295853) | | Region Coverage | 40.06% (62239/155358) | | Branch Coverage | 34.77% (31244/89862) | -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
github-actions[bot] commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2807035141 PR approved by anyone and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
github-actions[bot] commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2807035032 PR approved by at least one committer and no changes requested. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
HappenLee commented on code in PR #50074:
URL: https://github.com/apache/doris/pull/50074#discussion_r2045164079
##
be/src/vec/functions/function_cast.h:
##
@@ -289,8 +285,16 @@ struct ConvertImpl {
IsDateV2Type) {
DataTypeDateTimeV2::cast_to_date_v2(vec_from[i],
vec_to[i]);
} else {
-UInt32 scale = additions;
-vec_to[i] = ToFieldType(vec_from[i] / std::pow(10,
6 - scale));
+UInt32 to_scale = additions;
+DateV2Value value =
+binary_cast>(
+vec_from[i]);
+// scale reduce to 4, means the last 2 digits are
0.
+
static_cast(value.set_time_unit(
Review Comment:
better use bit op to speed up the 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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
HappenLee commented on code in PR #50074:
URL: https://github.com/apache/doris/pull/50074#discussion_r2045164079
##
be/src/vec/functions/function_cast.h:
##
@@ -289,8 +285,16 @@ struct ConvertImpl {
IsDateV2Type) {
DataTypeDateTimeV2::cast_to_date_v2(vec_from[i],
vec_to[i]);
} else {
-UInt32 scale = additions;
-vec_to[i] = ToFieldType(vec_from[i] / std::pow(10,
6 - scale));
+UInt32 to_scale = additions;
+DateV2Value value =
+binary_cast>(
+vec_from[i]);
+// scale reduce to 4, means the last 2 digits are
0.
+
static_cast(value.set_time_unit(
Review Comment:
better use bit op to speed up the 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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806922599 ClickBench: Total hot run time: 31.04 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 1cf00b8e287c988952d74a5d1b29522b87eb8cfd, data reload: false query1 0.040.040.02 query2 0.130.110.11 query3 0.260.200.20 query4 1.590.200.10 query5 0.580.560.55 query6 1.200.710.72 query7 0.020.020.02 query8 0.030.030.03 query9 0.580.530.51 query10 0.560.570.56 query11 0.160.100.11 query12 0.140.110.12 query13 0.610.600.60 query14 2.702.722.70 query15 0.940.860.87 query16 0.390.380.36 query17 1.071.061.06 query18 0.220.200.19 query19 2.061.821.82 query20 0.010.020.01 query21 15.37 0.900.53 query22 0.771.110.70 query23 14.95 1.400.61 query24 7.110.811.08 query25 0.460.330.09 query26 0.610.160.13 query27 0.050.050.05 query28 9.570.900.44 query29 12.54 3.983.30 query30 0.250.090.06 query31 2.820.600.39 query32 3.230.550.47 query33 3.003.123.10 query34 15.65 5.064.46 query35 4.544.494.52 query36 0.670.490.48 query37 0.090.070.06 query38 0.040.030.04 query39 0.030.020.03 query40 0.180.130.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.030.04 Total cold run time: 105.37 s Total hot run time: 31.04 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806905975 TPC-DS: Total hot run time: 185538 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 1cf00b8e287c988952d74a5d1b29522b87eb8cfd, data reload: false query1 998 477 485 477 query2 6546190918911891 query3 6756219 220 219 query4 25992 23757 22986 22986 query5 4398612 445 445 query6 287 200 188 188 query7 4614494 278 278 query8 298 238 245 238 query9 8639258526162585 query10 472 327 272 272 query11 15810 14992 14841 14841 query12 163 107 106 106 query13 1651527 411 411 query14 8646625861086108 query15 203 194 162 162 query16 7114619 458 458 query17 930 731 556 556 query18 1949404 297 297 query19 182 180 150 150 query20 116 118 114 114 query21 212 122 101 101 query22 4205413240474047 query23 33962 32897 33038 32897 query24 8494239023642364 query25 527 440 395 395 query26 1238270 155 155 query27 2741497 327 327 query28 4378239923872387 query29 756 546 411 411 query30 283 216 189 189 query31 929 847 774 774 query32 75 63 61 61 query33 550 380 316 316 query34 783 856 499 499 query35 791 805 727 727 query36 957 968 884 884 query37 118 97 75 75 query38 4209418041174117 query39 1453141014061406 query40 206 121 107 107 query41 60 54 51 51 query42 120 103 101 101 query43 505 491 473 473 query44 1299795 794 794 query45 177 170 169 169 query46 838 1021623 623 query47 1783179917321732 query48 377 411 296 296 query49 808 517 415 415 query50 675 678 395 395 query51 4229417741074107 query52 104 103 97 97 query53 224 270 193 193 query54 574 563 502 502 query55 86 82 83 82 query56 327 307 277 277 query57 1129115310891089 query58 268 255 253 253 query59 2577272425992599 query60 321 343 300 300 query61 136 133 160 133 query62 803 714 667 667 query63 216 180 189 180 query64 43831002686 686 query65 4330426542444244 query66 1160412 332 332 query67 15546 15340 15173 15173 query68 7821877 513 513 query69 474 290 265 265 query70 1167110110921092 query71 406 315 291 291 query72 5662471348094713 query73 654 627 341 341 query74 8922878589588785 query75 3512323026612661 query76 32311204764 764 query77 550 392 284 284 query78 992810313 93889388 query79 1645826 570 570 query80 585 507 443 443 query81 497 255 223 223 query82 215 129 101 101 query83 245 252 239 239 query84 294 98 85 85 query85 753 352 301 301 query86 368 296 286 286 query87 4619454343694369 query88 3044215921812159 query89 389 313 290 290 query90 1989206 210 206 query91 139 152 111 111 query92 80 65 59 59 query93 1742949 580 580 query94 676 419 287 287 query95 371 293 293 293 query96 494 556 273 273 query97 3123323631033103 query98 223 217 201 201 query99 1322140512781278 Total cold run time: 270826 ms Total hot run time: 185538 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] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
doris-robot commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806871906 TPC-H: Total hot run time: 34285 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 1cf00b8e287c988952d74a5d1b29522b87eb8cfd, data reload: false -- Round 1 -- q1 26209 524750295029 q2 2094271 183 183 q3 10400 1236725 725 q4 10231 1011526 526 q5 7997250823642364 q6 192 164 137 137 q7 926 786 620 620 q8 9334128710681068 q9 6763508851655088 q10 6822230819041904 q11 486 293 265 265 q12 342 354 219 219 q13 17761 368530723072 q14 225 228 223 223 q15 533 483 493 483 q16 653 621 587 587 q17 624 873 382 382 q18 7640727670767076 q19 1214963 565 565 q20 341 334 251 251 q21 4528341025642564 q22 10151008954 954 Total cold run time: 116330 ms Total hot run time: 34285 ms - Round 2, with runtime_filter_mode=off - q1 5108507750935077 q2 245 339 237 237 q3 2154266323232323 q4 1441189215301530 q5 4625445344054405 q6 214 165 129 129 q7 1947187817311731 q8 2618249925222499 q9 7246724771357135 q10 2977319027162716 q11 602 507 483 483 q12 705 753 579 579 q13 3506392332883288 q14 280 287 275 275 q15 535 477 484 477 q16 678 687 658 658 q17 1161160713331333 q18 7805742674237423 q19 820 804 907 804 q20 1922194318251825 q21 5208475945714571 q22 10531038995 995 Total cold run time: 52850 ms Total hot run time: 50493 ms ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806781796 run buildall -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
hello-stephen commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806771375 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
Re: [PR] [Fix](datetime) fix wrong implicit microsecond digits after reducing precision of datetime [doris]
zclllyybb commented on PR #50074: URL: https://github.com/apache/doris/pull/50074#issuecomment-2806771888 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
