You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "xy720 (via GitHub)" <gi...@apache.org> on 2024/06/17 16:28:03 UTC
[PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
xy720 opened a new pull request, #36426:
URL: https://github.com/apache/doris/pull/36426
## Proposed changes
Issue Number: close #xxx
When inserting a null value using jdbc prepared statement, Fe reports the following error:
```
2024-06-18 00:01:41,381 WARN (mysql-nio-pool-0|287) [StmtExecutor.analyze():1336] Analyze failed. stmt[38, 857b9a4c512f48b5-89ee68afc32f1828]
java.lang.IllegalStateException: null
at com.google.common.base.Preconditions.checkState(Preconditions.java:496) ~[guava-32.1.2-jre.jar:?]
at org.apache.doris.analysis.Analyzer.materializeSlots(Analyzer.java:2624) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:178) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.createPlanFragments(OriginalPlanner.java:171) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.planner.OriginalPlanner.plan(OriginalPlanner.java:102) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyzeAndGenerateQueryPlan(StmtExecutor.java:1512) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:1298) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:930) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:618) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:536) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.handleExecute(MysqlConnectProcessor.java:137) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.handleExecute(MysqlConnectProcessor.java:231) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:288) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:339) ~[doris-fe.jar:1.2-SNAPSHOT]
at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
at java.lang.Thread.run(Thread.java:840) ~[?:?]
```
<!--Describe your changes.-->
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2173844840
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2175723024
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2173865775
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174061211
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174214120
<details>
<summary>TPC-H: <b>Total hot run time: 40198 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit ff30c2ab69ac3e7cf28e0e4db87c015b2ddfdae4, data reload: false
------ Round 1 ----------------------------------
q1 17626 4297 4247 4247
q2 2039 185 192 185
q3 10468 1141 1073 1073
q4 10185 729 881 729
q5 7473 2636 2633 2633
q6 223 137 136 136
q7 951 617 588 588
q8 9239 2044 2024 2024
q9 8820 6499 6444 6444
q10 8980 3707 3698 3698
q11 457 229 233 229
q12 445 222 231 222
q13 17985 2969 2972 2969
q14 271 222 230 222
q15 530 479 480 479
q16 526 378 377 377
q17 951 749 707 707
q18 7944 7380 7413 7380
q19 6643 1459 1517 1459
q20 644 308 309 308
q21 4796 3762 3935 3762
q22 385 327 333 327
Total cold run time: 117581 ms
Total hot run time: 40198 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4379 4215 4281 4215
q2 361 252 268 252
q3 2969 2998 2940 2940
q4 2010 1739 1750 1739
q5 5511 5501 5403 5403
q6 219 139 133 133
q7 2236 1858 1855 1855
q8 3280 3373 3404 3373
q9 8694 8719 8772 8719
q10 4108 3802 3765 3765
q11 580 503 517 503
q12 828 649 659 649
q13 15883 3191 3192 3191
q14 302 273 282 273
q15 537 474 504 474
q16 498 450 451 450
q17 1842 1528 1506 1506
q18 8026 8056 7705 7705
q19 1865 1682 1640 1640
q20 3792 1898 1861 1861
q21 11412 4886 4639 4639
q22 754 558 547 547
Total cold run time: 80086 ms
Total hot run time: 55832 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174863097
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174454039
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174894448
<details>
<summary>TPC-H: <b>Total hot run time: 39744 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1d75cdf5ecaa68d0e8e2824c395499208f0b28ac, data reload: false
------ Round 1 ----------------------------------
q1 18456 5485 4390 4390
q2 2614 197 198 197
q3 11605 1139 1068 1068
q4 10417 777 796 777
q5 7515 2730 2637 2637
q6 225 143 141 141
q7 965 620 611 611
q8 9236 2044 2076 2044
q9 9030 6458 6473 6458
q10 8925 3712 3732 3712
q11 446 235 238 235
q12 405 226 223 223
q13 18769 2945 2948 2945
q14 251 227 223 223
q15 509 472 479 472
q16 521 383 374 374
q17 948 722 646 646
q18 8055 7381 7455 7381
q19 5546 1534 1447 1447
q20 652 319 326 319
q21 4888 3107 3255 3107
q22 391 344 337 337
Total cold run time: 120369 ms
Total hot run time: 39744 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4372 4212 4203 4203
q2 382 257 277 257
q3 2952 2797 2675 2675
q4 1836 1600 1612 1600
q5 5212 5243 5220 5220
q6 220 129 129 129
q7 2096 1723 1651 1651
q8 3181 3309 3296 3296
q9 8265 8332 8326 8326
q10 3861 3638 3642 3638
q11 578 484 491 484
q12 792 590 593 590
q13 17525 2943 2971 2943
q14 281 266 273 266
q15 518 470 471 470
q16 484 405 420 405
q17 1762 1489 1501 1489
q18 7542 7603 7374 7374
q19 7143 1595 1523 1523
q20 1962 1768 1765 1765
q21 4821 4653 4631 4631
q22 615 545 550 545
Total cold run time: 76400 ms
Total hot run time: 53480 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2173949412
<details>
<summary>TPC-DS: <b>Total hot run time: 173857 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 7e9e39222612d1e66ba8a21767f5eac14b1c0885, data reload: false
query1 929 380 379 379
query2 7324 2295 2363 2295
query3 6626 212 212 212
query4 20861 17363 17115 17115
query5 3641 476 467 467
query6 242 150 158 150
query7 4584 300 294 294
query8 320 298 275 275
query9 8509 2400 2383 2383
query10 568 308 286 286
query11 10598 10139 10014 10014
query12 120 92 85 85
query13 1637 371 367 367
query14 10282 7642 7215 7215
query15 258 196 201 196
query16 7728 283 290 283
query17 1821 558 542 542
query18 1908 288 275 275
query19 226 163 161 161
query20 95 85 82 82
query21 209 134 129 129
query22 4481 4477 4347 4347
query23 34300 33530 33568 33530
query24 10634 2783 2877 2783
query25 572 351 360 351
query26 706 152 145 145
query27 2196 306 310 306
query28 5891 2018 2020 2018
query29 869 612 586 586
query30 219 144 149 144
query31 932 736 726 726
query32 90 50 53 50
query33 641 303 266 266
query34 858 465 466 465
query35 738 621 601 601
query36 1097 922 929 922
query37 133 67 68 67
query38 2860 2734 2714 2714
query39 849 796 812 796
query40 208 125 122 122
query41 52 50 52 50
query42 111 96 93 93
query43 593 535 562 535
query44 1071 716 725 716
query45 197 169 162 162
query46 1061 741 708 708
query47 1883 1764 1778 1764
query48 360 292 295 292
query49 852 393 426 393
query50 781 387 382 382
query51 6771 6689 6625 6625
query52 102 97 89 89
query53 354 291 283 283
query54 903 441 444 441
query55 74 73 73 73
query56 285 258 286 258
query57 1132 1083 1017 1017
query58 251 236 252 236
query59 3286 3080 3074 3074
query60 290 268 272 268
query61 93 90 92 90
query62 620 452 432 432
query63 309 289 291 289
query64 8520 2282 1762 1762
query65 3191 3107 3079 3079
query66 748 319 323 319
query67 15541 15138 14996 14996
query68 4511 525 532 525
query69 520 397 363 363
query70 1090 1142 1072 1072
query71 376 274 268 268
query72 6941 5779 5857 5779
query73 740 330 321 321
query74 5856 5492 5570 5492
query75 3322 2660 2629 2629
query76 2144 943 997 943
query77 437 284 295 284
query78 10233 10009 10080 10009
query79 2108 521 525 521
query80 1022 450 483 450
query81 583 214 217 214
query82 517 99 98 98
query83 226 161 161 161
query84 231 83 84 83
query85 1478 358 286 286
query86 485 322 329 322
query87 3284 3069 3117 3069
query88 3833 2353 2350 2350
query89 486 376 376 376
query90 1721 192 185 185
query91 125 96 106 96
query92 60 49 54 49
query93 1590 493 492 492
query94 1083 185 187 185
query95 407 313 301 301
query96 589 263 265 263
query97 3259 3043 3077 3043
query98 234 198 202 198
query99 1371 867 860 860
Total cold run time: 267053 ms
Total hot run time: 173857 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174927682
<details>
<summary>ClickBench: <b>Total hot run time: 30 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 1d75cdf5ecaa68d0e8e2824c395499208f0b28ac, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.04
query4 1.68 0.09 0.08
query5 0.50 0.49 0.48
query6 1.15 0.72 0.73
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.48
query10 0.53 0.56 0.54
query11 0.16 0.12 0.12
query12 0.14 0.12 0.12
query13 0.60 0.59 0.60
query14 0.79 0.76 0.77
query15 0.84 0.80 0.81
query16 0.37 0.35 0.37
query17 0.97 1.01 0.99
query18 0.21 0.27 0.26
query19 1.76 1.73 1.66
query20 0.02 0.01 0.01
query21 15.48 0.64 0.64
query22 4.30 7.99 1.32
query23 18.27 1.40 1.32
query24 2.14 0.21 0.22
query25 0.16 0.09 0.09
query26 0.27 0.17 0.18
query27 0.09 0.08 0.08
query28 13.23 1.02 0.98
query29 12.53 3.36 3.39
query30 0.26 0.07 0.06
query31 2.85 0.38 0.38
query32 3.30 0.48 0.46
query33 2.88 2.90 2.87
query34 16.92 4.40 4.42
query35 4.52 4.47 4.47
query36 0.65 0.48 0.47
query37 0.18 0.15 0.16
query38 0.14 0.14 0.14
query39 0.04 0.04 0.03
query40 0.17 0.14 0.15
query41 0.09 0.04 0.05
query42 0.06 0.06 0.06
query43 0.04 0.04 0.04
Total cold run time: 109.24 s
Total hot run time: 30 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2173959095
<details>
<summary>ClickBench: <b>Total hot run time: 30.94 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7e9e39222612d1e66ba8a21767f5eac14b1c0885, data reload: false
query1 0.04 0.04 0.03
query2 0.08 0.03 0.04
query3 0.22 0.06 0.05
query4 1.67 0.08 0.08
query5 0.49 0.47 0.48
query6 1.12 0.71 0.72
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.49
query10 0.54 0.55 0.55
query11 0.16 0.11 0.12
query12 0.14 0.12 0.12
query13 0.58 0.60 0.58
query14 0.77 0.77 0.78
query15 0.83 0.84 0.82
query16 0.37 0.36 0.36
query17 0.99 0.99 1.03
query18 0.21 0.25 0.21
query19 1.74 1.71 1.72
query20 0.01 0.01 0.01
query21 15.40 0.67 0.66
query22 3.35 7.40 2.39
query23 18.35 1.41 1.23
query24 2.12 0.22 0.22
query25 0.14 0.09 0.09
query26 0.26 0.17 0.18
query27 0.08 0.08 0.09
query28 13.26 1.02 1.00
query29 12.64 3.24 3.20
query30 0.26 0.06 0.07
query31 2.85 0.40 0.38
query32 3.26 0.47 0.47
query33 2.91 2.92 2.94
query34 17.30 4.49 4.44
query35 4.55 4.46 4.51
query36 0.65 0.46 0.48
query37 0.19 0.16 0.14
query38 0.15 0.14 0.15
query39 0.05 0.03 0.04
query40 0.17 0.15 0.14
query41 0.10 0.05 0.04
query42 0.05 0.04 0.04
query43 0.05 0.04 0.05
Total cold run time: 108.71 s
Total hot run time: 30.94 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174239660
<details>
<summary>ClickBench: <b>Total hot run time: 30.57 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit ff30c2ab69ac3e7cf28e0e4db87c015b2ddfdae4, data reload: false
query1 0.05 0.03 0.03
query2 0.08 0.04 0.05
query3 0.23 0.05 0.05
query4 1.68 0.07 0.07
query5 0.48 0.47 0.50
query6 1.13 0.74 0.71
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.49
query10 0.53 0.54 0.55
query11 0.16 0.12 0.12
query12 0.15 0.12 0.13
query13 0.59 0.59 0.61
query14 0.80 0.78 0.76
query15 0.83 0.81 0.83
query16 0.37 0.36 0.36
query17 0.96 0.96 0.98
query18 0.20 0.29 0.22
query19 1.83 1.73 1.70
query20 0.01 0.02 0.02
query21 15.41 0.68 0.66
query22 4.08 7.51 1.92
query23 18.34 1.44 1.37
query24 2.15 0.22 0.22
query25 0.15 0.09 0.09
query26 0.26 0.18 0.17
query27 0.08 0.08 0.08
query28 13.21 1.03 1.01
query29 12.60 3.26 3.22
query30 0.25 0.06 0.06
query31 2.86 0.39 0.38
query32 3.30 0.49 0.47
query33 2.94 2.86 2.89
query34 17.18 4.41 4.41
query35 4.46 4.49 4.57
query36 0.65 0.45 0.46
query37 0.19 0.16 0.16
query38 0.15 0.15 0.14
query39 0.04 0.03 0.04
query40 0.17 0.15 0.15
query41 0.09 0.04 0.05
query42 0.05 0.06 0.04
query43 0.05 0.04 0.04
Total cold run time: 109.35 s
Total hot run time: 30.57 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "xy720 (via GitHub)" <gi...@apache.org>.
xy720 commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174940002
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174230631
<details>
<summary>TPC-DS: <b>Total hot run time: 173475 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit ff30c2ab69ac3e7cf28e0e4db87c015b2ddfdae4, data reload: false
query1 927 381 369 369
query2 6442 2441 2267 2267
query3 6635 204 206 204
query4 19564 17428 17250 17250
query5 3622 482 473 473
query6 248 176 163 163
query7 4584 295 296 295
query8 309 283 295 283
query9 8448 2400 2394 2394
query10 579 308 290 290
query11 10706 10074 10155 10074
query12 122 92 83 83
query13 1661 397 356 356
query14 9432 7354 7106 7106
query15 241 192 182 182
query16 7145 270 258 258
query17 1023 542 538 538
query18 1907 277 285 277
query19 199 160 154 154
query20 93 86 84 84
query21 208 133 145 133
query22 4512 4023 3934 3934
query23 33590 33637 33909 33637
query24 10322 2920 2816 2816
query25 591 378 385 378
query26 720 176 161 161
query27 2328 327 323 323
query28 6045 2121 2106 2106
query29 886 673 654 654
query30 271 168 163 163
query31 976 791 745 745
query32 93 61 60 60
query33 672 290 293 290
query34 881 515 485 485
query35 744 614 645 614
query36 1107 968 999 968
query37 154 72 73 72
query38 2929 2861 2830 2830
query39 903 848 843 843
query40 218 131 130 130
query41 55 56 50 50
query42 116 107 104 104
query43 607 582 554 554
query44 1091 730 733 730
query45 194 169 184 169
query46 1071 752 724 724
query47 1840 1761 1771 1761
query48 369 304 293 293
query49 836 417 417 417
query50 760 390 389 389
query51 6713 6676 6649 6649
query52 107 97 100 97
query53 365 303 300 300
query54 898 433 437 433
query55 76 74 76 74
query56 279 259 271 259
query57 1119 1060 1036 1036
query58 241 239 243 239
query59 3445 3212 3016 3016
query60 299 275 283 275
query61 95 100 138 100
query62 611 447 453 447
query63 322 301 294 294
query64 8562 2262 1747 1747
query65 3207 3102 3081 3081
query66 845 330 332 330
query67 15527 15196 14935 14935
query68 4508 543 559 543
query69 577 425 388 388
query70 1243 1142 1079 1079
query71 372 281 277 277
query72 7015 5747 5235 5235
query73 764 324 325 324
query74 5873 5528 5519 5519
query75 3426 2663 2680 2663
query76 2159 908 954 908
query77 433 312 302 302
query78 10371 9885 9699 9699
query79 1783 514 529 514
query80 1013 478 467 467
query81 583 228 233 228
query82 1059 105 109 105
query83 260 166 162 162
query84 272 86 85 85
query85 1038 287 270 270
query86 445 309 332 309
query87 3293 3121 3098 3098
query88 3272 2362 2344 2344
query89 477 387 377 377
query90 1654 200 191 191
query91 131 105 102 102
query92 60 52 105 52
query93 2089 505 498 498
query94 1116 195 184 184
query95 397 311 312 311
query96 604 261 265 261
query97 3237 3015 3038 3015
query98 224 204 191 191
query99 1144 839 829 829
Total cold run time: 262579 ms
Total hot run time: 173475 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2174923466
<details>
<summary>TPC-DS: <b>Total hot run time: 171785 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 1d75cdf5ecaa68d0e8e2824c395499208f0b28ac, data reload: false
query1 920 376 365 365
query2 6449 2313 2284 2284
query3 6649 206 206 206
query4 19270 17403 17270 17270
query5 4160 484 474 474
query6 250 153 155 153
query7 4590 296 288 288
query8 319 304 288 288
query9 8582 2418 2410 2410
query10 592 303 286 286
query11 10543 10014 10083 10014
query12 140 92 83 83
query13 1659 361 363 361
query14 9263 7577 6256 6256
query15 226 188 196 188
query16 7952 265 257 257
query17 1915 536 534 534
query18 1959 270 272 270
query19 195 157 148 148
query20 93 82 81 81
query21 217 126 123 123
query22 4434 4103 4124 4103
query23 33743 33103 32917 32917
query24 12062 2847 2838 2838
query25 661 356 349 349
query26 1800 156 150 150
query27 3049 327 309 309
query28 7604 2061 2068 2061
query29 1136 625 603 603
query30 268 150 145 145
query31 970 718 748 718
query32 98 54 56 54
query33 775 309 301 301
query34 931 478 473 473
query35 799 637 644 637
query36 1049 954 908 908
query37 206 70 69 69
query38 2875 2695 2717 2695
query39 859 795 756 756
query40 274 125 124 124
query41 54 51 55 51
query42 124 99 98 98
query43 576 536 529 529
query44 1221 716 734 716
query45 198 167 165 165
query46 1100 715 700 700
query47 1833 1733 1765 1733
query48 378 295 295 295
query49 1209 406 400 400
query50 758 384 376 376
query51 6793 6740 6654 6654
query52 99 91 93 91
query53 356 293 296 293
query54 933 431 436 431
query55 73 76 76 76
query56 299 263 282 263
query57 1139 1050 1032 1032
query58 250 239 268 239
query59 3513 3344 3269 3269
query60 284 271 268 268
query61 92 95 90 90
query62 642 451 441 441
query63 312 291 286 286
query64 9890 2313 1709 1709
query65 3193 3176 3118 3118
query66 1371 332 323 323
query67 15417 15098 14780 14780
query68 4573 539 551 539
query69 444 303 297 297
query70 1181 1098 1151 1098
query71 399 272 265 265
query72 6985 5676 5660 5660
query73 746 326 324 324
query74 6065 5540 5532 5532
query75 3392 2683 2678 2678
query76 2616 934 852 852
query77 490 296 311 296
query78 10382 10030 9642 9642
query79 2296 524 521 521
query80 963 455 453 453
query81 593 229 220 220
query82 757 105 102 102
query83 268 190 168 168
query84 233 84 82 82
query85 1911 289 274 274
query86 499 330 322 322
query87 3239 3109 3063 3063
query88 3631 2347 2346 2346
query89 479 385 406 385
query90 1813 197 197 197
query91 132 103 100 100
query92 59 49 49 49
query93 2452 522 497 497
query94 1254 184 181 181
query95 402 328 333 328
query96 592 275 263 263
query97 3241 3067 3109 3067
query98 217 201 195 195
query99 1243 857 814 814
Total cold run time: 275190 ms
Total hot run time: 171785 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [bug](prepared statement) fix prepared statement throw exception when inserting null value [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36426:
URL: https://github.com/apache/doris/pull/36426#issuecomment-2173930919
<details>
<summary>TPC-H: <b>Total hot run time: 39908 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7e9e39222612d1e66ba8a21767f5eac14b1c0885, data reload: false
------ Round 1 ----------------------------------
q1 17612 4313 4265 4265
q2 2025 192 190 190
q3 10462 1176 1164 1164
q4 10192 803 793 793
q5 7504 2662 2616 2616
q6 220 137 136 136
q7 938 609 604 604
q8 9223 2061 2043 2043
q9 8996 6517 6458 6458
q10 8939 3715 3722 3715
q11 439 238 242 238
q12 471 238 226 226
q13 18728 2988 2979 2979
q14 265 227 215 215
q15 512 475 463 463
q16 517 385 375 375
q17 963 715 668 668
q18 7985 7321 7302 7302
q19 3556 1579 1547 1547
q20 656 322 325 322
q21 4962 3293 3260 3260
q22 381 336 329 329
Total cold run time: 115546 ms
Total hot run time: 39908 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4340 4254 4203 4203
q2 366 255 250 250
q3 2944 2791 2897 2791
q4 1981 1694 1731 1694
q5 5551 5458 5528 5458
q6 224 129 142 129
q7 2195 1818 1872 1818
q8 3290 3413 3395 3395
q9 8681 8627 8811 8627
q10 4082 3927 3685 3685
q11 601 483 491 483
q12 797 659 603 603
q13 15989 3231 3130 3130
q14 307 261 272 261
q15 514 487 490 487
q16 512 441 432 432
q17 1782 1514 1510 1510
q18 8063 7843 7781 7781
q19 1952 1552 1629 1552
q20 2906 1889 1893 1889
q21 5133 5098 4935 4935
q22 611 549 563 549
Total cold run time: 72821 ms
Total hot run time: 55662 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org