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