You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "daju233 (via GitHub)" <gi...@apache.org> on 2025/05/28 06:28:21 UTC
[PR] Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
daju233 opened a new pull request, #51318:
URL: https://github.com/apache/doris/pull/51318
…t null"
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [x] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [x] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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] Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "daju233 (via GitHub)" <gi...@apache.org>.
daju233 commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915128409
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2933465041
<details>
<summary>TPC-H: <b>Total hot run time: 33593 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 98e593659b3015a4086e19c19cdf9e1dd1ebb25f, data reload: false
------ Round 1 ----------------------------------
q1 25881 5020 4918 4918
q2 1950 271 184 184
q3 10302 1226 686 686
q4 10212 988 530 530
q5 7503 2350 2278 2278
q6 179 163 132 132
q7 885 744 611 611
q8 9303 1180 1030 1030
q9 6796 5084 5111 5084
q10 6860 2309 1901 1901
q11 494 287 274 274
q12 344 343 212 212
q13 17973 3881 3252 3252
q14 239 225 228 225
q15 563 507 494 494
q16 425 442 394 394
q17 614 863 369 369
q18 7889 7062 6998 6998
q19 1683 950 542 542
q20 331 330 224 224
q21 3727 2500 2288 2288
q22 1049 1013 967 967
Total cold run time: 115202 ms
Total hot run time: 33593 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5140 5041 5077 5041
q2 233 314 225 225
q3 2124 2665 2292 2292
q4 1328 1754 1350 1350
q5 4359 4383 4381 4381
q6 221 165 128 128
q7 2068 1938 1763 1763
q8 2566 2577 2524 2524
q9 7212 7153 6997 6997
q10 3010 3237 2757 2757
q11 592 501 497 497
q12 692 784 628 628
q13 3461 3811 3287 3287
q14 295 310 280 280
q15 517 497 478 478
q16 457 479 434 434
q17 1136 1561 1379 1379
q18 7714 7526 7471 7471
q19 798 823 1014 823
q20 2135 2030 1847 1847
q21 4749 4436 4269 4269
q22 1094 1032 1013 1013
Total cold run time: 51901 ms
Total hot run time: 49864 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2944051194
<details>
<summary>TPC-DS: <b>Total hot run time: 192052 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 171528d7d4fd6bd86398d284cba60038c6c8019d, data reload: false
query1 1402 1101 1043 1043
query2 6236 1819 1767 1767
query3 11119 4611 4622 4611
query4 53290 25431 22954 22954
query5 4933 576 457 457
query6 361 214 202 202
query7 4898 507 300 300
query8 314 243 228 228
query9 5643 2661 2657 2657
query10 398 334 271 271
query11 15121 15081 14808 14808
query12 163 107 102 102
query13 1044 557 393 393
query14 10213 6387 6417 6387
query15 197 206 194 194
query16 7083 693 514 514
query17 1096 777 617 617
query18 1563 408 319 319
query19 201 194 171 171
query20 133 128 124 124
query21 210 127 105 105
query22 4294 4387 4285 4285
query23 34257 33759 33518 33518
query24 6864 2432 2463 2432
query25 478 488 403 403
query26 681 273 152 152
query27 2329 503 340 340
query28 3253 2158 2150 2150
query29 574 560 425 425
query30 277 234 195 195
query31 877 849 806 806
query32 70 66 66 66
query33 455 369 320 320
query34 774 855 563 563
query35 790 835 781 781
query36 921 999 919 919
query37 125 103 75 75
query38 4267 4271 4262 4262
query39 1529 1453 1487 1453
query40 211 119 110 110
query41 62 61 61 61
query42 123 112 109 109
query43 512 521 504 504
query44 1301 820 830 820
query45 180 181 168 168
query46 860 1027 654 654
query47 1851 1901 1773 1773
query48 396 417 333 333
query49 675 509 432 432
query50 668 725 416 416
query51 4195 4306 4257 4257
query52 113 110 97 97
query53 241 263 201 201
query54 583 577 515 515
query55 95 83 86 83
query56 328 317 281 281
query57 1159 1232 1083 1083
query58 271 274 258 258
query59 2701 2735 2648 2648
query60 334 331 305 305
query61 126 127 146 127
query62 757 741 676 676
query63 226 199 204 199
query64 1602 1114 779 779
query65 4225 4228 4135 4135
query66 716 392 304 304
query67 15727 15562 15285 15285
query68 6756 878 526 526
query69 540 312 262 262
query70 1240 1135 1051 1051
query71 471 309 286 286
query72 5702 4694 4714 4694
query73 1292 579 358 358
query74 9274 8829 9024 8829
query75 3580 3205 2659 2659
query76 4062 1190 750 750
query77 663 370 323 323
query78 10098 10090 9267 9267
query79 2697 819 570 570
query80 621 506 434 434
query81 481 247 219 219
query82 431 126 97 97
query83 316 246 236 236
query84 299 110 91 91
query85 758 349 315 315
query86 361 322 277 277
query87 4442 4473 4293 4293
query88 3333 2268 2248 2248
query89 405 314 280 280
query90 1721 202 207 202
query91 151 134 116 116
query92 78 60 66 60
query93 2056 931 574 574
query94 704 412 313 313
query95 375 299 306 299
query96 496 612 282 282
query97 2717 2743 2672 2672
query98 231 214 213 213
query99 1437 1417 1274 1274
Total cold run time: 296459 ms
Total hot run time: 192052 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915408410
<details>
<summary>TPC-DS: <b>Total hot run time: 192819 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 a812730969c43b3fd655a0d4908057c0e5d76c10, data reload: false
query1 1450 1117 1064 1064
query2 6365 1787 1804 1787
query3 11069 4631 4504 4504
query4 54234 25297 23403 23403
query5 5045 512 473 473
query6 374 217 197 197
query7 4951 494 298 298
query8 326 254 241 241
query9 5988 2628 2623 2623
query10 447 328 279 279
query11 15054 14981 14877 14877
query12 167 121 107 107
query13 1075 517 403 403
query14 10138 6294 6278 6278
query15 208 222 207 207
query16 7090 646 493 493
query17 1092 704 577 577
query18 1535 402 307 307
query19 200 222 170 170
query20 134 133 123 123
query21 206 140 111 111
query22 4357 4327 4282 4282
query23 34457 33659 33606 33606
query24 6681 2411 2454 2411
query25 476 482 409 409
query26 708 277 151 151
query27 2245 509 349 349
query28 3811 2206 2217 2206
query29 599 599 442 442
query30 307 224 198 198
query31 863 880 807 807
query32 79 74 69 69
query33 451 371 327 327
query34 796 994 548 548
query35 870 853 782 782
query36 971 1038 943 943
query37 118 101 85 85
query38 4303 4319 4246 4246
query39 1494 1461 1461 1461
query40 219 123 110 110
query41 77 58 55 55
query42 121 110 112 110
query43 500 492 478 478
query44 1349 854 854 854
query45 181 179 173 173
query46 856 1035 654 654
query47 1850 1861 1799 1799
query48 399 460 336 336
query49 699 512 442 442
query50 663 687 405 405
query51 4222 4256 4178 4178
query52 117 108 110 108
query53 226 268 182 182
query54 588 580 523 523
query55 87 89 86 86
query56 337 325 291 291
query57 1130 1166 1115 1115
query58 272 265 266 265
query59 2631 2797 2606 2606
query60 338 316 327 316
query61 125 127 141 127
query62 714 762 657 657
query63 221 202 191 191
query64 1759 1057 685 685
query65 4337 4228 4266 4228
query66 721 390 303 303
query67 16031 15707 15316 15316
query68 7918 886 523 523
query69 542 318 278 278
query70 1233 1128 1120 1120
query71 495 327 317 317
query72 5439 4837 5081 4837
query73 1363 673 362 362
query74 8911 8820 8672 8672
query75 3794 3185 2694 2694
query76 4289 1183 747 747
query77 614 375 280 280
query78 10117 10161 9407 9407
query79 3187 787 564 564
query80 647 504 466 466
query81 483 259 218 218
query82 493 130 98 98
query83 380 255 231 231
query84 287 104 90 90
query85 799 357 312 312
query86 404 315 279 279
query87 4463 4388 4376 4376
query88 3353 2350 2308 2308
query89 421 328 280 280
query90 1966 222 213 213
query91 140 142 110 110
query92 75 66 57 57
query93 2208 950 577 577
query94 685 402 297 297
query95 379 306 299 299
query96 500 564 282 282
query97 2732 2738 2621 2621
query98 224 200 205 200
query99 1404 1404 1267 1267
Total cold run time: 301449 ms
Total hot run time: 192819 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918457896
<details>
<summary>ClickBench: <b>Total hot run time: 28.65 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 f8a486d6e49ff5353d59d21ec4bbb13519fb5db6, data reload: false
query1 0.03 0.04 0.03
query2 0.14 0.11 0.11
query3 0.26 0.20 0.19
query4 1.60 0.20 0.11
query5 0.43 0.43 0.43
query6 1.15 0.66 0.66
query7 0.02 0.02 0.02
query8 0.04 0.04 0.03
query9 0.59 0.53 0.52
query10 0.58 0.59 0.57
query11 0.15 0.11 0.11
query12 0.15 0.11 0.12
query13 0.61 0.61 0.61
query14 0.78 0.80 0.80
query15 0.88 0.86 0.85
query16 0.41 0.38 0.38
query17 1.04 1.05 1.01
query18 0.23 0.20 0.21
query19 1.90 1.80 1.83
query20 0.02 0.01 0.01
query21 15.43 0.86 0.53
query22 0.75 1.21 0.61
query23 14.99 1.40 0.63
query24 6.97 1.03 0.53
query25 0.52 0.23 0.15
query26 0.60 0.16 0.15
query27 0.06 0.05 0.04
query28 9.54 0.94 0.43
query29 12.55 4.00 3.32
query30 0.25 0.09 0.07
query31 2.84 0.60 0.39
query32 3.23 0.54 0.47
query33 2.98 3.03 3.07
query34 15.65 5.05 4.48
query35 4.56 4.50 4.49
query36 0.66 0.49 0.47
query37 0.09 0.06 0.06
query38 0.06 0.04 0.03
query39 0.04 0.02 0.02
query40 0.17 0.13 0.13
query41 0.09 0.03 0.02
query42 0.03 0.03 0.03
query43 0.04 0.03 0.02
Total cold run time: 103.11 s
Total hot run time: 28.65 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918193113
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-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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "daju233 (via GitHub)" <gi...@apache.org>.
daju233 commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2933371401
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on code in PR #51318:
URL: https://github.com/apache/doris/pull/51318#discussion_r2111680109
##########
regression-test/suites/correctness/test_isnull.groovy:
##########
@@ -0,0 +1,51 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_isnull") {
+ sql """ DROP TABLE IF EXISTS db """
+ sql """
+ CREATE TABLE IF NOT EXISTS db (
+ `id` INT NULL
+ ) ENGINE=OLAP
+ DUPLICATE KEY(`id`)
+ DISTRIBUTED BY HASH(`id`) BUCKETS 1
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1",
+ "storage_format" = "V2"
+ );
+ """
+
+ sql """ INSERT INTO db VALUES(1); """
+ sql """ INSERT INTO db VALUES(2); """
+ sql """ INSERT INTO db VALUES(3); """
+ sql """ INSERT INTO db VALUES(0); """
+ sql """ INSERT INTO db VALUES(NULL); """
+
+ qt_select1 """
+ SELECT id, id ISNULL FROM db ORDER BY id;
+ """
+ qt_select2 """
+ SELECT id, id ISNOTNULL FROM db ORDER BY id;
Review Comment:
isnull(a)、 isnull(null) / a is null , a is not null
--
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2933485038
<details>
<summary>TPC-DS: <b>Total hot run time: 195502 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 98e593659b3015a4086e19c19cdf9e1dd1ebb25f, data reload: false
query1 1438 1081 1063 1063
query2 6329 1845 1850 1845
query3 11050 4636 4557 4557
query4 53471 25258 23636 23636
query5 5023 621 487 487
query6 347 213 188 188
query7 4878 551 301 301
query8 273 229 212 212
query9 5240 2651 2657 2651
query10 433 341 271 271
query11 15202 15149 14904 14904
query12 164 114 113 113
query13 1038 554 416 416
query14 10898 6960 6906 6906
query15 215 210 189 189
query16 7161 691 513 513
query17 1119 815 637 637
query18 1575 449 320 320
query19 231 212 194 194
query20 147 129 124 124
query21 224 135 112 112
query22 4334 4422 4298 4298
query23 34632 33846 33809 33809
query24 6397 2506 2536 2506
query25 477 504 497 497
query26 719 296 165 165
query27 2204 532 360 360
query28 2939 2159 2185 2159
query29 597 620 446 446
query30 277 238 200 200
query31 893 904 788 788
query32 73 65 93 65
query33 447 386 325 325
query34 819 943 557 557
query35 862 876 804 804
query36 973 1051 912 912
query37 120 110 84 84
query38 4292 4332 4276 4276
query39 1611 1501 1487 1487
query40 221 128 112 112
query41 62 57 60 57
query42 135 118 118 118
query43 515 538 488 488
query44 1395 849 853 849
query45 190 182 176 176
query46 935 1121 676 676
query47 1820 1900 1801 1801
query48 413 453 340 340
query49 670 518 417 417
query50 716 740 418 418
query51 4327 4420 4307 4307
query52 111 112 103 103
query53 234 281 198 198
query54 614 593 537 537
query55 90 90 88 88
query56 322 341 299 299
query57 1220 1226 1121 1121
query58 283 283 275 275
query59 2663 2833 2669 2669
query60 354 350 326 326
query61 129 125 128 125
query62 842 803 708 708
query63 238 198 211 198
query64 1830 1080 683 683
query65 4345 4195 4237 4195
query66 725 456 316 316
query67 15750 15541 15355 15355
query68 7049 918 526 526
query69 540 328 279 279
query70 1268 1089 1072 1072
query71 513 322 301 301
query72 5886 4964 5029 4964
query73 1481 701 353 353
query74 9100 9258 8976 8976
query75 4124 3371 2793 2793
query76 4306 1329 832 832
query77 751 396 295 295
query78 10220 10377 9431 9431
query79 2642 871 614 614
query80 649 527 465 465
query81 487 261 236 236
query82 451 134 101 101
query83 315 266 233 233
query84 294 112 96 96
query85 783 382 328 328
query86 367 299 311 299
query87 4414 4459 4342 4342
query88 3674 2291 2330 2291
query89 427 352 304 304
query90 1823 221 215 215
query91 141 147 113 113
query92 79 63 57 57
query93 1903 976 581 581
query94 673 434 309 309
query95 378 298 299 298
query96 522 625 287 287
query97 2836 2836 2666 2666
query98 240 215 208 208
query99 1520 1515 1305 1305
Total cold run time: 300127 ms
Total hot run time: 195502 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2933500181
<details>
<summary>ClickBench: <b>Total hot run time: 29.52 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 98e593659b3015a4086e19c19cdf9e1dd1ebb25f, data reload: false
query1 0.03 0.04 0.03
query2 0.13 0.10 0.11
query3 0.25 0.20 0.19
query4 1.60 0.19 0.19
query5 0.45 0.43 0.44
query6 1.18 0.68 0.67
query7 0.02 0.01 0.02
query8 0.04 0.04 0.04
query9 0.58 0.52 0.55
query10 0.57 0.57 0.56
query11 0.16 0.11 0.10
query12 0.15 0.12 0.12
query13 0.61 0.60 0.61
query14 0.79 0.81 0.82
query15 0.87 0.85 0.88
query16 0.39 0.38 0.38
query17 1.04 1.06 1.00
query18 0.23 0.22 0.21
query19 1.92 1.78 1.83
query20 0.02 0.01 0.01
query21 15.39 0.88 0.55
query22 0.74 1.14 0.61
query23 15.11 1.41 0.62
query24 6.69 1.27 1.33
query25 0.50 0.11 0.08
query26 0.56 0.18 0.13
query27 0.05 0.05 0.04
query28 10.04 0.94 0.44
query29 12.53 4.03 3.33
query30 0.25 0.09 0.06
query31 2.81 0.62 0.39
query32 3.23 0.56 0.49
query33 3.07 3.13 3.08
query34 15.58 5.27 4.52
query35 4.54 4.53 4.51
query36 0.67 0.50 0.49
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.03 0.03 0.02
query40 0.17 0.15 0.14
query41 0.08 0.02 0.02
query42 0.03 0.02 0.03
query43 0.04 0.02 0.03
Total cold run time: 103.28 s
Total hot run time: 29.52 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2943996418
<details>
<summary>TPC-H: <b>Total hot run time: 33660 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 171528d7d4fd6bd86398d284cba60038c6c8019d, data reload: false
------ Round 1 ----------------------------------
q1 26443 5018 4999 4999
q2 1982 282 194 194
q3 10250 1235 692 692
q4 10218 991 512 512
q5 7526 2372 2269 2269
q6 184 164 133 133
q7 876 738 617 617
q8 9294 1250 1049 1049
q9 6987 5079 5024 5024
q10 6865 2348 1895 1895
q11 490 284 286 284
q12 343 348 216 216
q13 17771 3697 3068 3068
q14 231 235 208 208
q15 559 482 479 479
q16 443 433 371 371
q17 572 839 363 363
q18 7471 7227 7175 7175
q19 1689 963 570 570
q20 338 342 217 217
q21 3616 2576 2347 2347
q22 1062 1003 978 978
Total cold run time: 115210 ms
Total hot run time: 33660 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5140 5108 5097 5097
q2 230 311 227 227
q3 2175 2675 2255 2255
q4 1353 1793 1393 1393
q5 4422 4336 4411 4336
q6 220 175 135 135
q7 2014 1919 1775 1775
q8 2573 2606 2519 2519
q9 7142 7262 6974 6974
q10 3050 3202 2799 2799
q11 565 503 500 500
q12 664 786 612 612
q13 3509 3903 3324 3324
q14 273 311 285 285
q15 529 482 492 482
q16 456 478 461 461
q17 1140 1553 1354 1354
q18 7690 7507 7477 7477
q19 791 844 894 844
q20 1996 2061 1876 1876
q21 4868 4525 4454 4454
q22 1118 1074 1044 1044
Total cold run time: 51918 ms
Total hot run time: 50223 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] Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915125658
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-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] Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "daju233 (via GitHub)" <gi...@apache.org>.
daju233 commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915126570
runbuildall
--
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915525319
<details>
<summary>TPC-H: <b>Total hot run time: 33636 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 99ddb226cec516c9384e740648fa60baeb6acd0b, data reload: false
------ Round 1 ----------------------------------
q1 25924 5954 4998 4998
q2 2085 277 187 187
q3 10393 1252 685 685
q4 10238 984 535 535
q5 7520 2368 2294 2294
q6 180 162 132 132
q7 916 718 599 599
q8 9319 1250 1060 1060
q9 6739 5050 5078 5050
q10 6884 2301 1908 1908
q11 484 291 266 266
q12 339 340 210 210
q13 17789 3599 3090 3090
q14 232 222 203 203
q15 555 490 489 489
q16 410 424 378 378
q17 601 853 386 386
q18 7632 7214 7091 7091
q19 1830 950 563 563
q20 336 333 221 221
q21 3730 2486 2316 2316
q22 1039 1033 975 975
Total cold run time: 115175 ms
Total hot run time: 33636 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5117 5059 5080 5059
q2 242 321 231 231
q3 2135 2638 2300 2300
q4 1351 1729 1291 1291
q5 4415 4412 4365 4365
q6 222 169 125 125
q7 2018 1913 1773 1773
q8 2587 2607 2524 2524
q9 7246 7259 6961 6961
q10 3040 3181 2761 2761
q11 590 514 489 489
q12 684 768 621 621
q13 3467 3863 3233 3233
q14 305 297 280 280
q15 529 478 498 478
q16 436 488 428 428
q17 1161 1552 1401 1401
q18 7829 7527 7493 7493
q19 803 818 941 818
q20 2000 2003 1839 1839
q21 4807 4498 4492 4492
q22 1071 1050 1065 1050
Total cold run time: 52055 ms
Total hot run time: 50012 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #51318: [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null"
URL: https://github.com/apache/doris/pull/51318
--
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-3604473936
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915373826
<details>
<summary>TPC-H: <b>Total hot run time: 33658 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 a812730969c43b3fd655a0d4908057c0e5d76c10, data reload: false
------ Round 1 ----------------------------------
q1 25971 5114 5060 5060
q2 2088 299 183 183
q3 10472 1348 683 683
q4 10230 993 517 517
q5 7665 2432 2293 2293
q6 184 162 138 138
q7 916 702 607 607
q8 9318 1283 1029 1029
q9 6868 5112 5091 5091
q10 6865 2285 1909 1909
q11 484 300 266 266
q12 344 356 221 221
q13 17786 3628 3100 3100
q14 246 239 215 215
q15 527 479 488 479
q16 420 429 379 379
q17 608 853 368 368
q18 7587 7230 7059 7059
q19 1708 956 563 563
q20 337 344 218 218
q21 3664 2562 2336 2336
q22 1064 1031 944 944
Total cold run time: 115352 ms
Total hot run time: 33658 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5164 5072 5098 5072
q2 243 325 232 232
q3 2127 2642 2302 2302
q4 1338 1743 1325 1325
q5 4383 4379 4406 4379
q6 219 168 126 126
q7 2034 1927 1801 1801
q8 2582 2490 2547 2490
q9 7234 7281 6957 6957
q10 3019 3246 2758 2758
q11 604 509 511 509
q12 658 764 597 597
q13 3487 3862 3252 3252
q14 281 311 281 281
q15 528 501 502 501
q16 447 500 455 455
q17 1134 1497 1424 1424
q18 7867 7519 7486 7486
q19 804 787 845 787
q20 2010 2068 1841 1841
q21 4808 4444 4395 4395
q22 1088 1066 1015 1015
Total cold run time: 52059 ms
Total hot run time: 49985 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915563263
<details>
<summary>TPC-DS: <b>Total hot run time: 191854 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 99ddb226cec516c9384e740648fa60baeb6acd0b, data reload: false
query1 1408 1080 1057 1057
query2 6217 1818 1773 1773
query3 11051 4595 4565 4565
query4 55095 25457 23029 23029
query5 5180 488 447 447
query6 360 203 202 202
query7 4925 497 291 291
query8 317 254 233 233
query9 5631 2612 2599 2599
query10 415 322 277 277
query11 15014 15098 15325 15098
query12 166 114 105 105
query13 1078 521 394 394
query14 10022 6261 6319 6261
query15 206 200 179 179
query16 7138 660 484 484
query17 1100 714 588 588
query18 1563 401 310 310
query19 226 194 164 164
query20 120 119 118 118
query21 215 126 104 104
query22 4448 4426 4340 4340
query23 34275 33441 33618 33441
query24 6468 2417 2447 2417
query25 465 477 398 398
query26 699 270 154 154
query27 2309 499 336 336
query28 3449 2166 2168 2166
query29 598 573 445 445
query30 268 223 193 193
query31 859 848 807 807
query32 76 86 66 66
query33 469 376 309 309
query34 791 871 510 510
query35 786 845 741 741
query36 951 1024 908 908
query37 121 101 82 82
query38 4128 4217 4230 4217
query39 1560 1486 1436 1436
query40 218 129 116 116
query41 74 60 61 60
query42 125 117 112 112
query43 490 502 454 454
query44 1306 847 862 847
query45 183 177 175 175
query46 856 1037 665 665
query47 1850 1852 1779 1779
query48 404 445 319 319
query49 673 517 452 452
query50 650 693 406 406
query51 4220 4226 4260 4226
query52 115 105 106 105
query53 230 261 188 188
query54 574 574 508 508
query55 86 88 86 86
query56 327 324 296 296
query57 1185 1184 1091 1091
query58 279 260 262 260
query59 2708 2688 2600 2600
query60 341 333 311 311
query61 130 128 118 118
query62 709 757 637 637
query63 217 190 181 181
query64 1687 1015 682 682
query65 4304 4258 4248 4248
query66 734 402 300 300
query67 15890 15578 15410 15410
query68 7372 823 572 572
query69 560 297 268 268
query70 1198 1117 1091 1091
query71 486 332 288 288
query72 5714 4746 4843 4746
query73 1446 659 353 353
query74 8963 9076 8647 8647
query75 3715 3183 2689 2689
query76 4262 1175 733 733
query77 612 368 287 287
query78 10145 10024 9332 9332
query79 3365 817 577 577
query80 635 519 437 437
query81 476 247 216 216
query82 488 125 94 94
query83 376 253 231 231
query84 305 107 80 80
query85 802 345 310 310
query86 412 280 270 270
query87 4353 4379 4307 4307
query88 3568 2279 2259 2259
query89 412 306 289 289
query90 1889 205 210 205
query91 136 143 115 115
query92 71 63 54 54
query93 2307 934 577 577
query94 668 414 298 298
query95 372 294 286 286
query96 493 560 278 278
query97 2714 2812 2625 2625
query98 236 207 206 206
query99 1396 1396 1258 1258
Total cold run time: 300679 ms
Total hot run time: 191854 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918274569
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918424056
<details>
<summary>TPC-H: <b>Total hot run time: 33928 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 f8a486d6e49ff5353d59d21ec4bbb13519fb5db6, data reload: false
------ Round 1 ----------------------------------
q1 26400 5075 4993 4993
q2 1950 285 202 202
q3 10390 1249 701 701
q4 10236 993 510 510
q5 7709 2947 2291 2291
q6 185 162 130 130
q7 921 719 631 631
q8 9310 1300 1104 1104
q9 6791 5107 5110 5107
q10 6894 2320 1886 1886
q11 529 291 270 270
q12 348 361 221 221
q13 17762 3653 3076 3076
q14 234 225 224 224
q15 571 493 489 489
q16 445 426 378 378
q17 610 870 370 370
q18 7693 7226 7247 7226
q19 1570 976 563 563
q20 336 334 228 228
q21 3902 3127 2356 2356
q22 1060 997 972 972
Total cold run time: 115846 ms
Total hot run time: 33928 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5195 5086 5077 5077
q2 233 319 222 222
q3 2143 2640 2320 2320
q4 1343 1753 1392 1392
q5 4461 4365 4385 4365
q6 218 167 132 132
q7 2017 1882 1751 1751
q8 2589 2445 2565 2445
q9 7260 7233 6956 6956
q10 3033 3211 2785 2785
q11 579 503 492 492
q12 666 777 606 606
q13 3528 3836 3329 3329
q14 293 301 294 294
q15 537 482 479 479
q16 442 485 427 427
q17 1166 1514 1412 1412
q18 7938 7538 7431 7431
q19 830 897 1016 897
q20 1983 1974 1902 1902
q21 4828 4524 4475 4475
q22 1090 1057 1024 1024
Total cold run time: 52372 ms
Total hot run time: 50213 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918447214
<details>
<summary>TPC-DS: <b>Total hot run time: 193279 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 f8a486d6e49ff5353d59d21ec4bbb13519fb5db6, data reload: false
query1 1421 1105 1070 1070
query2 6276 1907 1903 1903
query3 11020 4318 4373 4318
query4 52497 25346 23365 23365
query5 5136 579 464 464
query6 329 209 206 206
query7 4922 502 292 292
query8 271 222 209 209
query9 5721 2659 2661 2659
query10 414 344 281 281
query11 15017 15101 14773 14773
query12 162 110 107 107
query13 1070 536 424 424
query14 10104 6324 6336 6324
query15 213 205 203 203
query16 7136 651 537 537
query17 1096 753 606 606
query18 1581 410 319 319
query19 217 204 178 178
query20 133 143 122 122
query21 210 124 107 107
query22 4421 4459 4408 4408
query23 34564 33627 33505 33505
query24 6716 2399 2422 2399
query25 477 493 413 413
query26 714 282 156 156
query27 2276 513 344 344
query28 3187 2200 2190 2190
query29 585 574 467 467
query30 290 220 193 193
query31 832 841 804 804
query32 74 63 64 63
query33 474 352 314 314
query34 785 860 525 525
query35 808 843 771 771
query36 943 989 902 902
query37 116 109 80 80
query38 4290 4266 4209 4209
query39 1539 1477 1451 1451
query40 212 120 115 115
query41 62 61 59 59
query42 135 116 114 114
query43 529 505 486 486
query44 1347 840 845 840
query45 184 177 170 170
query46 863 1038 686 686
query47 1838 1862 1845 1845
query48 426 420 328 328
query49 680 473 426 426
query50 678 693 408 408
query51 4202 4246 4225 4225
query52 114 112 107 107
query53 234 261 189 189
query54 590 614 512 512
query55 86 84 86 84
query56 312 326 300 300
query57 1152 1188 1132 1132
query58 280 266 269 266
query59 2750 2892 2823 2823
query60 341 351 329 329
query61 128 129 126 126
query62 738 751 672 672
query63 234 191 195 191
query64 1782 1067 695 695
query65 4236 4145 4129 4129
query66 732 398 311 311
query67 16191 15646 15439 15439
query68 6840 883 526 526
query69 551 324 269 269
query70 1163 1094 1035 1035
query71 504 316 297 297
query72 5810 4779 4916 4779
query73 1440 639 357 357
query74 8921 9327 8999 8999
query75 4075 3209 2727 2727
query76 4297 1196 754 754
query77 676 382 283 283
query78 10115 10057 9430 9430
query79 3978 809 576 576
query80 652 540 445 445
query81 472 255 219 219
query82 489 128 98 98
query83 304 249 236 236
query84 292 113 96 96
query85 773 345 304 304
query86 358 292 305 292
query87 4423 4396 4358 4358
query88 3448 2269 2263 2263
query89 452 330 287 287
query90 1972 203 202 202
query91 143 144 111 111
query92 71 59 58 58
query93 2661 944 584 584
query94 670 397 309 309
query95 362 287 288 287
query96 505 569 282 282
query97 2779 2765 2662 2662
query98 260 210 203 203
query99 1438 1352 1283 1283
Total cold run time: 299987 ms
Total hot run time: 193279 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915423375
<details>
<summary>ClickBench: <b>Total hot run time: 29.53 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 a812730969c43b3fd655a0d4908057c0e5d76c10, data reload: false
query1 0.03 0.04 0.03
query2 0.12 0.10 0.12
query3 0.24 0.19 0.19
query4 1.60 0.19 0.19
query5 0.46 0.46 0.46
query6 1.16 0.67 0.65
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.58 0.52 0.52
query10 0.57 0.58 0.56
query11 0.16 0.11 0.11
query12 0.16 0.12 0.12
query13 0.62 0.59 0.59
query14 0.78 0.80 0.82
query15 0.89 0.85 0.86
query16 0.37 0.37 0.40
query17 1.05 1.07 1.07
query18 0.22 0.21 0.21
query19 1.93 1.87 1.86
query20 0.02 0.01 0.01
query21 15.40 0.92 0.56
query22 0.75 1.27 0.95
query23 14.72 1.36 0.60
query24 7.48 0.97 0.93
query25 0.52 0.25 0.07
query26 0.51 0.17 0.14
query27 0.05 0.05 0.05
query28 9.77 0.89 0.43
query29 12.54 3.95 3.26
query30 0.25 0.09 0.06
query31 2.82 0.59 0.39
query32 3.22 0.55 0.47
query33 3.04 3.09 3.12
query34 15.66 5.05 4.47
query35 4.52 4.52 4.52
query36 0.66 0.50 0.48
query37 0.08 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.02
query40 0.16 0.14 0.13
query41 0.08 0.03 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 103.39 s
Total hot run time: 29.53 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2944380770
# FE UT Coverage Report
Increment line coverage `` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/51318_171528d7d4fd6bd86398d284cba60038c6c8019d/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/51318_171528d7d4fd6bd86398d284cba60038c6c8019d/fe_report/index.html)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2943843871
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915465692
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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2918193079
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-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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is no… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2915579455
<details>
<summary>ClickBench: <b>Total hot run time: 28.98 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 99ddb226cec516c9384e740648fa60baeb6acd0b, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.11 0.11
query3 0.26 0.20 0.19
query4 1.59 0.18 0.20
query5 0.47 0.45 0.44
query6 1.16 0.66 0.65
query7 0.02 0.02 0.02
query8 0.04 0.04 0.04
query9 0.58 0.52 0.51
query10 0.57 0.57 0.56
query11 0.15 0.11 0.10
query12 0.15 0.11 0.12
query13 0.61 0.61 0.59
query14 0.78 0.81 0.80
query15 0.87 0.87 0.83
query16 0.38 0.37 0.39
query17 1.08 1.03 1.04
query18 0.23 0.21 0.20
query19 1.90 1.86 1.83
query20 0.01 0.01 0.02
query21 15.39 0.92 0.56
query22 0.75 1.23 0.77
query23 14.76 1.35 0.65
query24 6.74 1.32 0.58
query25 0.48 0.19 0.13
query26 0.63 0.16 0.12
query27 0.05 0.05 0.04
query28 9.22 0.85 0.43
query29 12.62 3.98 3.30
query30 0.25 0.11 0.06
query31 2.81 0.58 0.39
query32 3.23 0.56 0.48
query33 3.06 3.08 3.08
query34 15.70 5.06 4.46
query35 4.51 4.54 4.53
query36 0.66 0.49 0.48
query37 0.09 0.07 0.06
query38 0.05 0.03 0.03
query39 0.03 0.02 0.02
query40 0.17 0.14 0.13
query41 0.08 0.03 0.03
query42 0.03 0.02 0.03
query43 0.03 0.04 0.03
Total cold run time: 102.36 s
Total hot run time: 28.98 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] [Exec](function) Do function alias “isnull/isnotnull” in spark to Doris "is null/is not null" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51318:
URL: https://github.com/apache/doris/pull/51318#issuecomment-2944075156
<details>
<summary>ClickBench: <b>Total hot run time: 28.92 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 171528d7d4fd6bd86398d284cba60038c6c8019d, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.11 0.12
query3 0.25 0.21 0.19
query4 1.59 0.20 0.11
query5 0.43 0.42 0.41
query6 1.17 0.66 0.66
query7 0.02 0.02 0.02
query8 0.04 0.04 0.03
query9 0.58 0.51 0.53
query10 0.56 0.57 0.56
query11 0.16 0.11 0.11
query12 0.15 0.12 0.12
query13 0.61 0.60 0.60
query14 0.77 0.81 0.81
query15 0.87 0.86 0.89
query16 0.38 0.38 0.38
query17 1.05 1.05 1.05
query18 0.23 0.20 0.21
query19 1.89 1.88 1.86
query20 0.02 0.01 0.01
query21 15.41 0.86 0.54
query22 0.76 1.10 0.76
query23 14.90 1.41 0.66
query24 7.01 1.23 0.45
query25 0.53 0.12 0.18
query26 0.63 0.16 0.12
query27 0.06 0.06 0.05
query28 9.92 0.95 0.44
query29 12.56 4.02 3.32
query30 0.25 0.10 0.07
query31 2.83 0.60 0.39
query32 3.24 0.55 0.47
query33 3.00 3.03 3.06
query34 15.82 5.15 4.52
query35 4.53 4.56 4.54
query36 0.69 0.50 0.48
query37 0.09 0.07 0.06
query38 0.04 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.14 0.13
query41 0.08 0.02 0.02
query42 0.04 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 103.57 s
Total hot run time: 28.92 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