doris icon indicating copy to clipboard operation
doris copied to clipboard

[fix](array) fix array_except/union for left const return only one row result

Open amorynan opened this issue 1 year ago • 25 comments

Proposed changes

backport : https://github.com/apache/doris/pull/36776

Issue Number: close #xxx

amorynan avatar Jun 27 '24 09:06 amorynan

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR

Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.

doris-robot avatar Jun 27 '24 09:06 doris-robot

run buildall

amorynan avatar Jun 27 '24 09:06 amorynan

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Jun 27 '24 09:06 github-actions[bot]

TeamCity be ut coverage result: Function Coverage: 37.87% (8112/21418) Line Coverage: 29.53% (66413/224873) Region Coverage: 29.00% (34225/118014) Branch Coverage: 24.86% (17565/70654) Coverage Report: http://coverage.selectdb-in.cc/coverage/13c999f7af0538da71198389ae3cdfa753ba00ee_13c999f7af0538da71198389ae3cdfa753ba00ee/report/index.html

doris-robot avatar Jun 27 '24 10:06 doris-robot

TPC-H: Total hot run time: 50009 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false

------ Round 1 ----------------------------------
q1	17524	4347	4318	4318
q2	2074	155	162	155
q3	10808	1984	1980	1980
q4	10499	1245	1358	1245
q5	8835	4121	3955	3955
q6	236	127	128	127
q7	2066	1621	1597	1597
q8	9280	2739	2714	2714
q9	10875	10467	10352	10352
q10	8643	3480	3533	3480
q11	415	247	241	241
q12	473	307	308	307
q13	18370	3968	4034	3968
q14	352	331	321	321
q15	517	459	457	457
q16	697	568	569	568
q17	1139	974	955	955
q18	7330	6856	6867	6856
q19	1788	1648	1613	1613
q20	520	306	308	306
q21	4416	4071	4057	4057
q22	534	453	437	437
Total cold run time: 117391 ms
Total hot run time: 50009 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4323	4341	4367	4341
q2	314	227	221	221
q3	4174	4158	4139	4139
q4	2740	2749	2766	2749
q5	7152	7054	7036	7036
q6	240	121	124	121
q7	3236	2868	2835	2835
q8	4364	4482	4501	4482
q9	17324	17229	17161	17161
q10	4229	4227	4282	4227
q11	732	680	675	675
q12	1048	842	872	842
q13	7306	3733	3711	3711
q14	459	437	422	422
q15	507	462	456	456
q16	734	680	668	668
q17	3832	3841	3887	3841
q18	8879	8848	8859	8848
q19	1717	1705	1690	1690
q20	2339	2129	2103	2103
q21	8482	8485	8559	8485
q22	1045	991	1001	991
Total cold run time: 85176 ms
Total hot run time: 80044 ms

doris-robot avatar Jun 27 '24 10:06 doris-robot

TPC-DS: Total hot run time: 203833 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false

query1	950	389	380	380
query2	6529	2804	2663	2663
query3	6920	209	204	204
query4	20119	18102	17938	17938
query5	19741	6532	6491	6491
query6	282	215	222	215
query7	4162	307	311	307
query8	415	434	441	434
query9	3134	2691	2626	2626
query10	414	309	301	301
query11	11340	10708	10690	10690
query12	117	83	77	77
query13	5588	691	707	691
query14	17613	13272	13503	13272
query15	392	252	238	238
query16	6486	298	277	277
query17	1714	1457	874	874
query18	2330	408	408	408
query19	218	153	154	153
query20	77	80	79	79
query21	189	98	96	96
query22	5215	4901	4997	4901
query23	32453	32095	32083	32083
query24	7003	6547	6481	6481
query25	533	422	451	422
query26	530	163	161	161
query27	1883	302	296	296
query28	6148	2396	2337	2337
query29	2998	2819	2770	2770
query30	250	165	172	165
query31	908	740	734	734
query32	73	66	63	63
query33	417	269	255	255
query34	838	482	474	474
query35	1152	949	935	935
query36	1307	1075	1248	1075
query37	91	63	65	63
query38	3058	2900	2897	2897
query39	1378	1338	1331	1331
query40	203	95	97	95
query41	46	44	44	44
query42	86	84	82	82
query43	712	714	660	660
query44	1148	721	725	721
query45	247	234	241	234
query46	1231	968	987	968
query47	1805	1943	1687	1687
query48	1015	713	712	712
query49	625	376	377	376
query50	870	658	611	611
query51	4754	4658	4711	4658
query52	102	83	83	83
query53	448	337	323	323
query54	2660	2462	2477	2462
query55	98	75	84	75
query56	243	203	203	203
query57	1161	1119	1123	1119
query58	222	203	209	203
query59	4104	3903	3757	3757
query60	206	204	216	204
query61	98	93	95	93
query62	841	504	479	479
query63	491	340	346	340
query64	2594	1538	1502	1502
query65	3592	3584	3580	3580
query66	826	390	385	385
query67	15488	15606	15548	15548
query68	10443	661	654	654
query69	575	365	343	343
query70	2069	1648	1273	1273
query71	410	312	315	312
query72	6513	3497	3509	3497
query73	736	323	319	319
query74	6247	5884	5833	5833
query75	5418	3662	3727	3662
query76	7013	1136	1200	1136
query77	1190	258	254	254
query78	12901	11777	11704	11704
query79	7876	652	634	634
query80	949	400	399	399
query81	476	244	230	230
query82	850	96	94	94
query83	177	136	131	131
query84	264	71	68	68
query85	895	319	319	319
query86	349	298	296	296
query87	3200	3021	3054	3021
query88	4555	2305	2319	2305
query89	457	287	289	287
query90	1910	203	210	203
query91	167	137	150	137
query92	60	54	54	54
query93	6657	548	577	548
query94	696	209	208	208
query95	1125	1073	1047	1047
query96	646	323	338	323
query97	6611	6442	6447	6442
query98	186	176	166	166
query99	3001	873	954	873
Total cold run time: 315503 ms
Total hot run time: 203833 ms

doris-robot avatar Jun 27 '24 10:06 doris-robot

ClickBench: Total hot run time: 31.38 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee, data reload: false

query1	0.03	0.03	0.02
query2	0.07	0.03	0.02
query3	0.25	0.04	0.04
query4	1.80	0.06	0.07
query5	0.53	0.52	0.52
query6	1.26	0.62	0.62
query7	0.02	0.01	0.01
query8	0.03	0.03	0.02
query9	0.54	0.51	0.48
query10	0.53	0.52	0.54
query11	0.12	0.08	0.08
query12	0.12	0.09	0.09
query13	0.62	0.61	0.60
query14	0.79	0.79	0.80
query15	0.76	0.76	0.78
query16	0.37	0.39	0.37
query17	0.99	0.96	1.00
query18	0.21	0.27	0.23
query19	1.93	1.85	1.87
query20	0.01	0.01	0.01
query21	15.47	0.54	0.53
query22	2.31	1.92	1.47
query23	17.02	0.97	1.10
query24	4.67	2.13	1.71
query25	0.34	0.13	0.04
query26	0.73	0.15	0.17
query27	0.05	0.05	0.04
query28	6.64	0.75	0.77
query29	12.62	2.31	2.28
query30	0.63	0.53	0.53
query31	2.82	0.38	0.37
query32	3.39	0.50	0.50
query33	3.04	3.07	3.07
query34	15.28	4.83	4.85
query35	4.89	4.84	4.86
query36	1.06	1.02	1.03
query37	0.06	0.04	0.05
query38	0.03	0.02	0.02
query39	0.02	0.02	0.01
query40	0.16	0.13	0.14
query41	0.06	0.01	0.01
query42	0.02	0.02	0.01
query43	0.02	0.01	0.02
Total cold run time: 102.31 s
Total hot run time: 31.38 s

doris-robot avatar Jun 27 '24 10:06 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 13c999f7af0538da71198389ae3cdfa753ba00ee with default session variables
Stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select:       21.4 seconds inserted 10000000 Rows, about 467K ops/s

doris-robot avatar Jun 27 '24 10:06 doris-robot

run buildall

amorynan avatar Jul 01 '24 02:07 amorynan

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Jul 01 '24 02:07 github-actions[bot]

TPC-H: Total hot run time: 50148 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false

------ Round 1 ----------------------------------
q1	17634	4447	4381	4381
q2	2097	159	150	150
q3	10472	1898	1960	1898
q4	10375	1242	1323	1242
q5	8553	3908	3892	3892
q6	238	163	127	127
q7	2027	1607	1564	1564
q8	9516	2726	2695	2695
q9	13900	10617	10460	10460
q10	8649	3509	3462	3462
q11	421	248	247	247
q12	471	308	313	308
q13	18363	3969	4033	3969
q14	363	323	335	323
q15	506	465	458	458
q16	667	565	568	565
q17	1129	957	963	957
q18	7340	7020	7057	7020
q19	1800	1679	1600	1600
q20	543	322	315	315
q21	4474	4083	4075	4075
q22	527	440	448	440
Total cold run time: 120065 ms
Total hot run time: 50148 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4282	4301	4311	4301
q2	322	226	224	224
q3	4139	4120	4112	4112
q4	2753	2734	2732	2732
q5	7236	7178	7112	7112
q6	240	118	122	118
q7	3229	2870	2848	2848
q8	4328	4424	4441	4424
q9	17409	17016	17149	17016
q10	4240	4240	4295	4240
q11	743	666	676	666
q12	1025	854	849	849
q13	6924	3742	3741	3741
q14	438	424	427	424
q15	518	456	463	456
q16	723	680	680	680
q17	3748	3814	3876	3814
q18	8767	8861	8881	8861
q19	1750	1622	1656	1622
q20	2360	2165	2207	2165
q21	8349	8402	8396	8396
q22	1069	956	941	941
Total cold run time: 84592 ms
Total hot run time: 79742 ms

doris-robot avatar Jul 01 '24 02:07 doris-robot

TPC-DS: Total hot run time: 204015 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false

query1	937	419	377	377
query2	6525	2891	2781	2781
query3	6927	208	197	197
query4	20231	17967	18040	17967
query5	19732	6507	6560	6507
query6	306	218	236	218
query7	4285	320	311	311
query8	417	401	373	373
query9	3136	2710	2625	2625
query10	426	311	299	299
query11	11287	10694	10656	10656
query12	122	77	77	77
query13	5600	690	695	690
query14	18092	13444	13421	13421
query15	364	244	248	244
query16	6445	299	263	263
query17	1663	1460	892	892
query18	2292	424	417	417
query19	212	157	156	156
query20	82	79	77	77
query21	188	96	98	96
query22	5153	4946	4907	4907
query23	32526	31848	31745	31745
query24	6871	6596	6538	6538
query25	543	426	436	426
query26	530	165	166	165
query27	1845	299	298	298
query28	6177	2351	2312	2312
query29	2856	2761	2852	2761
query30	243	167	177	167
query31	892	735	787	735
query32	69	63	63	63
query33	391	264	258	258
query34	843	477	477	477
query35	1158	919	923	919
query36	1191	1162	1322	1162
query37	89	61	61	61
query38	3058	2933	2917	2917
query39	1380	1315	1336	1315
query40	205	100	98	98
query41	46	44	45	44
query42	90	81	79	79
query43	737	668	714	668
query44	1147	716	720	716
query45	250	235	233	233
query46	1240	954	998	954
query47	2052	1674	1768	1674
query48	1016	743	744	743
query49	620	375	386	375
query50	890	652	622	622
query51	4763	4679	4643	4643
query52	97	74	84	74
query53	455	329	323	323
query54	2661	2460	2487	2460
query55	89	80	76	76
query56	240	227	216	216
query57	1218	1066	1126	1066
query58	220	208	211	208
query59	4276	3817	4099	3817
query60	220	189	201	189
query61	99	109	95	95
query62	839	479	470	470
query63	489	348	350	348
query64	2492	1560	1500	1500
query65	3641	3555	3530	3530
query66	759	368	390	368
query67	15885	18722	15680	15680
query68	6268	634	635	634
query69	587	373	369	369
query70	1571	1532	1360	1360
query71	426	327	320	320
query72	6611	3508	3508	3508
query73	729	329	320	320
query74	6343	5830	5863	5830
query75	4516	3750	3656	3656
query76	4075	1135	1211	1135
query77	550	275	254	254
query78	12799	11583	12302	11583
query79	6761	649	649	649
query80	2524	399	414	399
query81	533	236	230	230
query82	733	98	97	97
query83	232	135	132	132
query84	261	73	79	73
query85	1418	324	332	324
query86	365	296	331	296
query87	3199	3031	3029	3029
query88	4640	2360	2346	2346
query89	341	296	300	296
query90	1683	217	212	212
query91	178	140	151	140
query92	59	51	52	51
query93	1434	570	600	570
query94	889	211	210	210
query95	1112	1067	1069	1067
query96	636	326	344	326
query97	6546	6412	6488	6412
query98	184	172	169	169
query99	2950	880	879	879
Total cold run time: 302973 ms
Total hot run time: 204015 ms

doris-robot avatar Jul 01 '24 02:07 doris-robot

ClickBench: Total hot run time: 30.75 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c, data reload: false

query1	0.02	0.02	0.01
query2	0.07	0.02	0.03
query3	0.26	0.05	0.04
query4	1.78	0.06	0.06
query5	0.54	0.52	0.52
query6	1.23	0.62	0.62
query7	0.02	0.01	0.01
query8	0.04	0.03	0.02
query9	0.53	0.50	0.48
query10	0.54	0.53	0.54
query11	0.12	0.08	0.09
query12	0.11	0.09	0.09
query13	0.63	0.62	0.61
query14	0.78	0.79	0.77
query15	0.77	0.77	0.76
query16	0.36	0.39	0.36
query17	1.01	1.03	0.99
query18	0.25	0.22	0.26
query19	1.94	1.81	1.85
query20	0.02	0.01	0.01
query21	15.46	0.57	0.54
query22	2.29	2.08	1.62
query23	16.39	0.95	0.98
query24	7.01	1.05	1.02
query25	0.32	0.10	0.06
query26	0.82	0.16	0.17
query27	0.05	0.05	0.03
query28	6.21	0.77	0.76
query29	12.62	2.28	2.30
query30	0.55	0.54	0.52
query31	2.81	0.40	0.37
query32	3.37	0.50	0.49
query33	3.13	3.10	3.05
query34	15.25	4.79	4.79
query35	4.88	4.85	4.84
query36	1.03	1.02	1.01
query37	0.06	0.04	0.05
query38	0.03	0.02	0.02
query39	0.01	0.01	0.02
query40	0.16	0.14	0.14
query41	0.06	0.01	0.01
query42	0.02	0.02	0.02
query43	0.02	0.01	0.02
Total cold run time: 103.57 s
Total hot run time: 30.75 s

doris-robot avatar Jul 01 '24 02:07 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 85458b9272b7dde38dc59f05754beb229ddfe97c with default session variables
Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select:       21.6 seconds inserted 10000000 Rows, about 462K ops/s

doris-robot avatar Jul 01 '24 02:07 doris-robot

TeamCity be ut coverage result: Function Coverage: 37.88% (8113/21417) Line Coverage: 29.56% (66457/224855) Region Coverage: 29.02% (34248/118005) Branch Coverage: 24.90% (17591/70652) Coverage Report: http://coverage.selectdb-in.cc/coverage/85458b9272b7dde38dc59f05754beb229ddfe97c_85458b9272b7dde38dc59f05754beb229ddfe97c/report/index.html

doris-robot avatar Jul 01 '24 03:07 doris-robot

run external

amorynan avatar Jul 01 '24 08:07 amorynan

PR approved by at least one committer and no changes requested.

github-actions[bot] avatar Jul 01 '24 09:07 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Jul 01 '24 09:07 github-actions[bot]

run buildall

amorynan avatar Jul 01 '24 09:07 amorynan

clang-tidy review says "All clean, LGTM! :+1:"

github-actions[bot] avatar Jul 01 '24 09:07 github-actions[bot]

TPC-H: Total hot run time: 49717 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false

------ Round 1 ----------------------------------
q1	17949	4388	4364	4364
q2	2064	165	145	145
q3	10271	1896	1952	1896
q4	10361	1230	1323	1230
q5	8472	3927	3827	3827
q6	230	130	169	130
q7	2066	1627	1634	1627
q8	9608	2732	2694	2694
q9	13589	10286	10184	10184
q10	8663	3529	3507	3507
q11	412	257	249	249
q12	473	304	322	304
q13	18342	3969	4041	3969
q14	370	350	326	326
q15	520	465	464	464
q16	663	578	559	559
q17	1121	912	914	912
q18	7227	6939	6797	6797
q19	1803	1659	1653	1653
q20	532	305	306	305
q21	4430	4152	4124	4124
q22	532	455	451	451
Total cold run time: 119698 ms
Total hot run time: 49717 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4336	4312	4298	4298
q2	321	228	222	222
q3	4192	4137	4178	4137
q4	2731	2760	2741	2741
q5	7072	7038	7012	7012
q6	244	122	123	122
q7	3201	2791	2846	2791
q8	4337	4453	4457	4453
q9	16914	16817	16716	16716
q10	4219	4242	4264	4242
q11	770	681	693	681
q12	1036	850	856	850
q13	6280	3748	3725	3725
q14	451	420	425	420
q15	508	463	457	457
q16	755	695	689	689
q17	3855	3823	3761	3761
q18	8791	8822	8724	8724
q19	1726	1674	1654	1654
q20	2376	2154	2153	2153
q21	8539	8459	8418	8418
q22	1081	975	998	975
Total cold run time: 83735 ms
Total hot run time: 79241 ms

doris-robot avatar Jul 01 '24 09:07 doris-robot

TeamCity be ut coverage result: Function Coverage: 37.88% (8113/21417) Line Coverage: 29.55% (66451/224870) Region Coverage: 29.02% (34245/118017) Branch Coverage: 24.89% (17590/70662) Coverage Report: http://coverage.selectdb-in.cc/coverage/718e8ebfa893c5101d5852cc5b057f38c5a91c95_718e8ebfa893c5101d5852cc5b057f38c5a91c95/report/index.html

doris-robot avatar Jul 01 '24 09:07 doris-robot

TPC-DS: Total hot run time: 203038 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false

query1	925	421	379	379
query2	6550	2857	2770	2770
query3	6921	204	204	204
query4	21333	18097	17972	17972
query5	19746	6564	6563	6563
query6	301	222	236	222
query7	4294	304	310	304
query8	424	464	416	416
query9	3158	2685	2607	2607
query10	428	300	296	296
query11	11332	10629	10567	10567
query12	123	75	76	75
query13	5598	673	698	673
query14	17989	13362	13378	13362
query15	359	240	245	240
query16	6426	283	266	266
query17	1700	1443	878	878
query18	2313	421	422	421
query19	201	150	149	149
query20	82	79	79	79
query21	189	102	96	96
query22	5171	4984	4906	4906
query23	32624	31814	31934	31814
query24	6872	6540	6473	6473
query25	529	449	405	405
query26	512	170	163	163
query27	1805	306	303	303
query28	6160	2350	2300	2300
query29	2876	2776	2692	2692
query30	240	161	167	161
query31	915	726	733	726
query32	73	63	63	63
query33	404	251	257	251
query34	865	471	482	471
query35	1119	934	917	917
query36	1295	1258	1301	1258
query37	92	60	61	60
query38	3148	2973	2948	2948
query39	1370	1328	1318	1318
query40	211	91	95	91
query41	46	43	45	43
query42	81	81	85	81
query43	782	663	715	663
query44	1163	730	739	730
query45	249	240	237	237
query46	1222	973	995	973
query47	2100	1719	1800	1719
query48	1012	717	727	717
query49	629	386	382	382
query50	855	571	610	571
query51	4807	4635	4617	4617
query52	88	94	76	76
query53	453	325	341	325
query54	2656	2470	2491	2470
query55	89	79	85	79
query56	234	225	209	209
query57	1142	1084	1094	1084
query58	222	194	188	188
query59	3948	3592	3944	3592
query60	209	199	195	195
query61	97	99	95	95
query62	830	521	525	521
query63	489	350	355	350
query64	2222	1527	1460	1460
query65	3653	3545	3539	3539
query66	800	376	368	368
query67	15402	15300	18284	15300
query68	9336	683	689	683
query69	559	347	332	332
query70	1570	1429	1283	1283
query71	393	304	320	304
query72	6472	3481	3470	3470
query73	749	326	327	326
query74	6265	5837	5837	5837
query75	5331	3635	3706	3635
query76	5881	1115	1153	1115
query77	1003	258	256	256
query78	12566	11683	11657	11657
query79	8835	662	643	643
query80	1059	403	404	403
query81	490	242	229	229
query82	841	96	100	96
query83	168	141	131	131
query84	261	71	69	69
query85	868	317	315	315
query86	330	333	309	309
query87	3279	3002	3034	3002
query88	4559	2306	2312	2306
query89	467	290	285	285
query90	1918	222	211	211
query91	181	141	142	141
query92	61	53	51	51
query93	6805	589	610	589
query94	704	209	213	209
query95	1104	1072	1040	1040
query96	640	330	327	327
query97	6469	6350	6333	6333
query98	184	180	168	168
query99	3001	840	986	840
Total cold run time: 314502 ms
Total hot run time: 203038 ms

doris-robot avatar Jul 01 '24 09:07 doris-robot

ClickBench: Total hot run time: 30.6 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95, data reload: false

query1	0.03	0.03	0.03
query2	0.07	0.02	0.02
query3	0.24	0.04	0.04
query4	1.81	0.07	0.07
query5	0.54	0.52	0.52
query6	1.23	0.72	0.61
query7	0.02	0.01	0.01
query8	0.03	0.02	0.03
query9	0.54	0.50	0.48
query10	0.53	0.53	0.54
query11	0.12	0.09	0.09
query12	0.11	0.08	0.09
query13	0.61	0.62	0.60
query14	0.77	0.81	0.77
query15	0.79	0.77	0.76
query16	0.37	0.37	0.37
query17	1.00	1.02	1.00
query18	0.22	0.25	0.24
query19	1.84	1.78	1.86
query20	0.02	0.01	0.01
query21	15.47	0.57	0.55
query22	2.06	2.11	1.91
query23	17.13	0.94	0.90
query24	8.34	0.86	0.60
query25	0.39	0.11	0.07
query26	0.82	0.14	0.15
query27	0.04	0.04	0.05
query28	5.41	0.80	0.73
query29	12.60	2.31	2.27
query30	0.60	0.53	0.53
query31	2.80	0.38	0.38
query32	3.38	0.51	0.49
query33	3.08	3.08	3.09
query34	15.25	4.82	4.79
query35	4.86	4.83	4.84
query36	1.04	1.01	1.01
query37	0.06	0.05	0.05
query38	0.04	0.02	0.02
query39	0.02	0.02	0.01
query40	0.16	0.14	0.15
query41	0.07	0.02	0.01
query42	0.02	0.01	0.01
query43	0.02	0.02	0.01
Total cold run time: 104.55 s
Total hot run time: 30.6 s

doris-robot avatar Jul 01 '24 09:07 doris-robot

Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'

Load test result on commit 718e8ebfa893c5101d5852cc5b057f38c5a91c95 with default session variables
Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc:          58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select:       21.5 seconds inserted 10000000 Rows, about 465K ops/s

doris-robot avatar Jul 01 '24 09:07 doris-robot

run external

amorynan avatar Jul 02 '24 07:07 amorynan