doris icon indicating copy to clipboard operation
doris copied to clipboard

[feature](show) support show create user

Open lsy3993 opened this issue 5 months ago • 6 comments

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary: We can create user like this CREATE USER IF NOT EXISTS 'xxxxxxx' IDENTIFIED BY '12345' PASSWORD_EXPIRE INTERVAL 10 DAY FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 1 DAY;

But we can not show the users' create stmt, it's hard for admin or root to manage all users. So this PR supports 'show create user' in two ways:

  1. show all create user
  2. show create user xxxxxxx (show create user via userIdentity)

this is the result, it has two columns:

User Identity Create Stmt
admin CREATE USER 'admin'@'%' IDENTIFIED BY *** DEFAULT ROLE 'admin,default_role_rbac_admin@%' PASSWORD_EXPIRE NEVER PASSWORD_HISTORY NO_RESTRICTION FAILED_LOGIN_ATTEMPTS DISABLED PASSWORD_LOCK_TIME DISABLED COMMENT "ADMIN"
root CREATE USER 'root'@'%' IDENTIFIED BY *** DEFAULT ROLE 'default_role_rbac_root@%,operator' PASSWORD_EXPIRE NEVER PASSWORD_HISTORY NO_RESTRICTION FAILED_LOGIN_ATTEMPTS DISABLED PASSWORD_LOCK_TIME DISABLED COMMENT "ROOT"
xxxxxxx CREATE USER 'xxxxxxx'@'%' IDENTIFIED BY *** DEFAULT ROLE 'default_role_rbac_xxxxxxx@%' PASSWORD_EXPIRE 864000 PASSWORD_HISTORY NO_RESTRICTION FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 86400 COMMENT ""

Release note

None

Check List (For Author)

  • Test

    • [x] Regression test
    • [x] 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
  • Behavior changed:

    • [ ] No.
    • [ ] Yes.
  • Does this need documentation?

    • [ ] No.
    • [x] Yes. When this PR is merged, I will add documentation.

Check List (For Reviewer who merge this PR)

  • [ ] Confirm the release note
  • [ ] Confirm test cases
  • [ ] Confirm document
  • [ ] Add branch pick label

lsy3993 avatar Jun 18 '25 02:06 lsy3993

Thank you for your contribution to Apache Doris. Don't know what should be done next? See 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?

Thearas avatar Jun 18 '25 02:06 Thearas

run buildall

lsy3993 avatar Jun 18 '25 02:06 lsy3993

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

------ Round 1 ----------------------------------
q1	17613	5115	5025	5025
q2	1926	296	184	184
q3	10296	1382	724	724
q4	10222	1006	515	515
q5	7538	2477	2353	2353
q6	183	165	129	129
q7	900	732	612	612
q8	9306	1305	1136	1136
q9	6861	5090	5062	5062
q10	6884	2385	1967	1967
q11	467	303	287	287
q12	342	352	212	212
q13	17762	3634	3058	3058
q14	228	233	217	217
q15	548	487	483	483
q16	438	423	376	376
q17	588	869	360	360
q18	7546	7225	7105	7105
q19	1219	937	550	550
q20	344	333	220	220
q21	3868	2577	2355	2355
q22	1039	1030	987	987
Total cold run time: 106118 ms
Total hot run time: 33917 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5050	4972	5015	4972
q2	240	334	226	226
q3	2130	2682	2294	2294
q4	1355	1792	1344	1344
q5	4207	4133	4336	4133
q6	223	177	130	130
q7	2041	1928	1758	1758
q8	2580	2502	2496	2496
q9	7252	7248	7149	7149
q10	3072	3287	2854	2854
q11	588	520	479	479
q12	710	756	597	597
q13	3464	3846	3274	3274
q14	287	290	272	272
q15	525	476	469	469
q16	445	493	433	433
q17	1173	1574	1350	1350
q18	7765	7415	7573	7415
q19	838	856	959	856
q20	1985	2060	1902	1902
q21	4955	4483	4242	4242
q22	1066	1048	999	999
Total cold run time: 51951 ms
Total hot run time: 49644 ms

doris-robot avatar Jun 18 '25 03:06 doris-robot

TPC-DS: Total hot run time: 185115 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 a0d56aa9e31f8c482c5de0ea575b570637510eab, data reload: false

query1	993	395	401	395
query2	6541	1875	1872	1872
query3	6740	221	217	217
query4	26171	23615	22852	22852
query5	4319	607	464	464
query6	335	204	194	194
query7	4615	504	283	283
query8	288	225	241	225
query9	8613	2648	2673	2648
query10	508	330	255	255
query11	15756	15085	14799	14799
query12	168	103	103	103
query13	1638	506	419	419
query14	9587	6177	6067	6067
query15	199	191	193	191
query16	7409	617	441	441
query17	1175	729	562	562
query18	1981	401	295	295
query19	186	191	167	167
query20	121	117	115	115
query21	211	124	106	106
query22	4129	4236	3919	3919
query23	33948	33076	33108	33076
query24	8303	2362	2362	2362
query25	542	470	393	393
query26	1234	302	151	151
query27	2716	502	347	347
query28	4384	2153	2110	2110
query29	750	564	428	428
query30	282	213	191	191
query31	945	854	768	768
query32	73	61	63	61
query33	555	352	311	311
query34	800	841	540	540
query35	790	810	720	720
query36	935	980	866	866
query37	114	98	77	77
query38	4089	4094	4016	4016
query39	1466	1416	1409	1409
query40	215	123	118	118
query41	69	70	66	66
query42	133	110	114	110
query43	486	507	488	488
query44	1354	833	832	832
query45	190	180	171	171
query46	842	1035	649	649
query47	1750	1775	1725	1725
query48	387	429	306	306
query49	726	476	417	417
query50	651	672	408	408
query51	4146	4185	4145	4145
query52	102	107	100	100
query53	223	259	182	182
query54	579	576	505	505
query55	89	79	83	79
query56	322	312	278	278
query57	1187	1192	1135	1135
query58	276	258	261	258
query59	2613	2682	2581	2581
query60	333	320	291	291
query61	127	121	121	121
query62	797	733	712	712
query63	227	191	187	187
query64	4339	1001	662	662
query65	4244	4203	4172	4172
query66	1104	412	317	317
query67	15565	15445	15520	15445
query68	5081	895	532	532
query69	492	309	259	259
query70	1199	1119	1111	1111
query71	400	332	309	309
query72	5531	4680	4619	4619
query73	634	574	363	363
query74	9286	9166	8957	8957
query75	3187	3236	2675	2675
query76	3238	1182	747	747
query77	483	485	290	290
query78	10055	10317	9350	9350
query79	1819	788	599	599
query80	636	501	439	439
query81	478	261	223	223
query82	193	129	98	98
query83	250	256	236	236
query84	251	112	96	96
query85	842	352	308	308
query86	315	302	265	265
query87	4410	4434	4327	4327
query88	2887	2273	2278	2273
query89	373	315	285	285
query90	1785	204	201	201
query91	145	147	109	109
query92	65	64	65	64
query93	1069	944	575	575
query94	620	415	305	305
query95	372	286	280	280
query96	498	579	281	281
query97	2673	2762	2602	2602
query98	222	219	209	209
query99	1318	1372	1253	1253
Total cold run time: 267492 ms
Total hot run time: 185115 ms

doris-robot avatar Jun 18 '25 03:06 doris-robot

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

query1	0.03	0.03	0.03
query2	0.07	0.04	0.03
query3	0.23	0.07	0.06
query4	1.62	0.10	0.10
query5	0.42	0.42	0.41
query6	1.19	0.66	0.66
query7	0.03	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.53	0.52
query10	0.57	0.58	0.56
query11	0.16	0.10	0.11
query12	0.14	0.12	0.11
query13	0.62	0.62	0.61
query14	0.80	0.85	0.80
query15	0.90	0.85	0.86
query16	0.40	0.39	0.38
query17	1.09	1.02	1.05
query18	0.22	0.21	0.20
query19	1.95	1.85	1.78
query20	0.01	0.02	0.01
query21	15.47	0.90	0.54
query22	0.77	1.06	0.66
query23	15.07	1.42	0.64
query24	7.50	1.30	0.65
query25	0.48	0.25	0.08
query26	0.59	0.17	0.13
query27	0.07	0.06	0.05
query28	8.93	0.92	0.44
query29	12.60	3.99	3.29
query30	0.25	0.09	0.06
query31	2.83	0.59	0.40
query32	3.22	0.54	0.47
query33	3.13	3.06	3.06
query34	16.01	5.44	4.76
query35	4.80	4.85	4.85
query36	0.70	0.49	0.50
query37	0.09	0.07	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.03
query40	0.18	0.16	0.14
query41	0.09	0.03	0.03
query42	0.03	0.02	0.03
query43	0.04	0.04	0.03
Total cold run time: 103.98 s
Total hot run time: 29.2 s

doris-robot avatar Jun 18 '25 03:06 doris-robot

FE UT Coverage Report

Increment line coverage 66.67% (56/84) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 18 '25 04:06 hello-stephen

run buildall

lsy3993 avatar Jun 25 '25 07:06 lsy3993

run feut

lsy3993 avatar Jun 25 '25 08:06 lsy3993

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

------ Round 1 ----------------------------------
q1	17607	5275	5108	5108
q2	1955	299	193	193
q3	10515	1348	714	714
q4	10250	1007	529	529
q5	7721	3023	2358	2358
q6	191	168	137	137
q7	914	743	607	607
q8	9307	1286	1180	1180
q9	6747	5142	5113	5113
q10	6902	2371	1970	1970
q11	469	290	272	272
q12	355	353	230	230
q13	17753	3753	3086	3086
q14	222	238	217	217
q15	568	497	477	477
q16	431	420	372	372
q17	586	894	363	363
q18	7659	7137	7017	7017
q19	1676	944	572	572
q20	332	341	224	224
q21	3657	3214	2356	2356
q22	1071	1018	962	962
Total cold run time: 106888 ms
Total hot run time: 34057 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5246	5195	5142	5142
q2	252	329	224	224
q3	2216	2661	2321	2321
q4	1344	1795	1347	1347
q5	4359	4456	4424	4424
q6	222	178	137	137
q7	2027	1887	1811	1811
q8	2622	2665	2579	2579
q9	7042	7023	6975	6975
q10	3098	3293	2873	2873
q11	573	520	483	483
q12	685	757	650	650
q13	3566	3846	3359	3359
q14	280	309	285	285
q15	523	468	495	468
q16	448	480	460	460
q17	1131	1524	1323	1323
q18	7370	7135	7097	7097
q19	818	927	1109	927
q20	1925	2021	1817	1817
q21	4819	4435	4243	4243
q22	1073	1048	1007	1007
Total cold run time: 51639 ms
Total hot run time: 49952 ms

doris-robot avatar Jun 25 '25 08:06 doris-robot

TPC-DS: Total hot run time: 184299 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 83e0449c4444a6728175f61847df790571217eff, data reload: false

query1	1002	383	417	383
query2	6541	1900	1844	1844
query3	6744	216	219	216
query4	26503	23266	23682	23266
query5	4467	633	447	447
query6	306	207	208	207
query7	4636	510	289	289
query8	268	230	222	222
query9	8659	2667	2677	2667
query10	504	348	268	268
query11	15750	15174	15268	15174
query12	170	112	113	112
query13	1671	556	424	424
query14	10330	6333	6381	6333
query15	214	196	172	172
query16	7268	637	488	488
query17	1197	731	580	580
query18	1998	409	315	315
query19	211	210	175	175
query20	121	115	117	115
query21	216	128	111	111
query22	4207	4171	4190	4171
query23	34105	33089	33181	33089
query24	7827	2419	2431	2419
query25	527	455	380	380
query26	1241	269	150	150
query27	2608	486	397	397
query28	4332	2156	2135	2135
query29	784	551	448	448
query30	288	227	195	195
query31	934	848	758	758
query32	73	83	66	66
query33	582	376	312	312
query34	834	868	544	544
query35	791	811	721	721
query36	952	974	877	877
query37	115	102	76	76
query38	4137	4111	4078	4078
query39	1473	1444	1432	1432
query40	213	122	107	107
query41	61	58	58	58
query42	124	110	110	110
query43	503	525	495	495
query44	1383	835	820	820
query45	189	174	166	166
query46	873	1031	625	625
query47	1748	1773	1705	1705
query48	395	438	319	319
query49	752	498	388	388
query50	665	704	406	406
query51	4187	4207	4157	4157
query52	111	110	102	102
query53	236	270	187	187
query54	595	577	505	505
query55	83	85	89	85
query56	303	299	302	299
query57	1183	1184	1128	1128
query58	285	260	250	250
query59	2623	2727	2569	2569
query60	334	322	299	299
query61	124	126	127	126
query62	798	730	671	671
query63	233	194	188	188
query64	4320	1002	718	718
query65	4275	4161	4196	4161
query66	1134	409	322	322
query67	15766	15630	15352	15352
query68	8222	905	530	530
query69	477	307	268	268
query70	1182	1157	1098	1098
query71	472	331	293	293
query72	5702	2402	5147	2402
query73	785	768	356	356
query74	9257	9138	8710	8710
query75	3752	3201	2686	2686
query76	3604	1197	803	803
query77	796	411	297	297
query78	9973	10169	9303	9303
query79	2387	825	584	584
query80	660	508	440	440
query81	476	266	231	231
query82	645	145	101	101
query83	288	254	233	233
query84	278	106	88	88
query85	772	431	314	314
query86	326	301	293	293
query87	4375	4457	4380	4380
query88	3160	2282	2269	2269
query89	387	318	280	280
query90	1955	218	215	215
query91	140	147	118	118
query92	71	69	58	58
query93	1182	965	583	583
query94	677	405	292	292
query95	370	295	289	289
query96	492	627	282	282
query97	2732	2770	2666	2666
query98	234	212	197	197
query99	1441	1379	1266	1266
Total cold run time: 275352 ms
Total hot run time: 184299 ms

doris-robot avatar Jun 25 '25 09:06 doris-robot

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

query1	0.04	0.04	0.02
query2	0.08	0.03	0.04
query3	0.24	0.07	0.07
query4	1.61	0.11	0.10
query5	0.43	0.42	0.40
query6	1.16	0.66	0.66
query7	0.03	0.01	0.02
query8	0.05	0.03	0.03
query9	0.58	0.51	0.52
query10	0.58	0.57	0.56
query11	0.15	0.11	0.10
query12	0.15	0.11	0.11
query13	0.64	0.61	0.60
query14	0.79	0.80	0.80
query15	0.89	0.85	0.87
query16	0.38	0.37	0.39
query17	1.07	1.09	1.07
query18	0.23	0.22	0.21
query19	1.96	1.84	1.84
query20	0.01	0.01	0.02
query21	15.39	0.87	0.57
query22	0.75	1.14	0.74
query23	14.88	1.39	0.64
query24	6.94	1.45	0.84
query25	0.48	0.26	0.15
query26	0.61	0.16	0.14
query27	0.06	0.06	0.05
query28	9.85	0.89	0.46
query29	12.61	3.99	3.30
query30	0.26	0.09	0.06
query31	2.82	0.59	0.41
query32	3.25	0.55	0.48
query33	3.04	3.12	3.06
query34	16.12	5.40	4.75
query35	4.84	4.83	4.79
query36	0.70	0.53	0.48
query37	0.09	0.07	0.07
query38	0.05	0.04	0.04
query39	0.04	0.03	0.03
query40	0.18	0.14	0.13
query41	0.08	0.02	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 104.19 s
Total hot run time: 29.61 s

doris-robot avatar Jun 25 '25 09:06 doris-robot

PR approved by anyone and no changes requested.

github-actions[bot] avatar Jun 26 '25 02:06 github-actions[bot]

run buildall

lsy3993 avatar Jun 26 '25 06:06 lsy3993

run compile

lsy3993 avatar Jun 26 '25 06:06 lsy3993

run performance

lsy3993 avatar Jun 26 '25 06:06 lsy3993

FE UT Coverage Report

Increment line coverage 55.88% (38/68) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Jun 26 '25 07:06 hello-stephen

run p0

lsy3993 avatar Jun 26 '25 08:06 lsy3993

run p0

lsy3993 avatar Jun 26 '25 09:06 lsy3993

run performance

lsy3993 avatar Jun 26 '25 09:06 lsy3993

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

------ Round 1 ----------------------------------
q1	17632	5186	5031	5031
q2	1935	284	199	199
q3	10282	1264	717	717
q4	10232	1010	510	510
q5	7647	2390	2258	2258
q6	184	161	129	129
q7	884	734	612	612
q8	9308	1209	1095	1095
q9	7287	5099	5072	5072
q10	6867	2370	1980	1980
q11	478	301	273	273
q12	361	351	220	220
q13	17769	3619	3042	3042
q14	228	225	216	216
q15	545	484	496	484
q16	432	416	385	385
q17	593	832	371	371
q18	7553	7092	7138	7092
q19	1307	943	581	581
q20	338	362	219	219
q21	3792	3125	2327	2327
q22	1040	1018	964	964
Total cold run time: 106694 ms
Total hot run time: 33777 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5070	5052	5011	5011
q2	243	325	218	218
q3	2179	2629	2273	2273
q4	1418	1773	1370	1370
q5	4181	4300	4334	4300
q6	206	166	123	123
q7	1980	1933	1813	1813
q8	2642	2538	2488	2488
q9	7209	7082	7121	7082
q10	3118	3223	2830	2830
q11	586	509	492	492
q12	689	787	631	631
q13	3505	4021	3283	3283
q14	290	297	282	282
q15	508	470	479	470
q16	452	478	438	438
q17	1172	1518	1380	1380
q18	7403	7216	7225	7216
q19	787	793	825	793
q20	2016	2007	1870	1870
q21	4789	4224	4213	4213
q22	1020	1020	1012	1012
Total cold run time: 51463 ms
Total hot run time: 49588 ms

doris-robot avatar Jun 26 '25 10:06 doris-robot

run p0

lsy3993 avatar Jun 26 '25 10:06 lsy3993

TPC-DS: Total hot run time: 184749 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 4ef6e686e01865cfcd270852773bd6a729d367ea, data reload: false

query1	1009	385	391	385
query2	6556	1760	1760	1760
query3	6742	212	216	212
query4	26530	23501	22972	22972
query5	4335	569	430	430
query6	305	206	209	206
query7	4622	491	293	293
query8	299	233	209	209
query9	8606	2617	2618	2617
query10	475	346	258	258
query11	15489	15099	15040	15040
query12	173	107	112	107
query13	1654	531	417	417
query14	9373	5580	5607	5580
query15	207	179	168	168
query16	7605	627	454	454
query17	1227	692	563	563
query18	1992	388	299	299
query19	221	185	156	156
query20	122	117	112	112
query21	210	123	109	109
query22	4087	4136	4078	4078
query23	34097	32978	33228	32978
query24	8437	2322	2373	2322
query25	529	459	410	410
query26	1238	263	149	149
query27	2745	505	344	344
query28	4332	2116	2114	2114
query29	721	550	429	429
query30	285	216	183	183
query31	938	848	733	733
query32	74	63	68	63
query33	568	357	313	313
query34	793	831	519	519
query35	807	808	741	741
query36	942	974	890	890
query37	103	100	71	71
query38	4122	4090	4120	4090
query39	1522	1461	1429	1429
query40	218	116	102	102
query41	60	54	52	52
query42	122	107	103	103
query43	515	528	497	497
query44	1306	835	825	825
query45	183	171	161	161
query46	835	1018	619	619
query47	1756	1817	1737	1737
query48	376	399	298	298
query49	735	491	381	381
query50	624	682	419	419
query51	4075	4224	4104	4104
query52	116	105	99	99
query53	221	244	188	188
query54	564	559	487	487
query55	82	82	85	82
query56	286	300	281	281
query57	1202	1189	1118	1118
query58	260	246	257	246
query59	2595	2712	2545	2545
query60	316	316	304	304
query61	124	122	134	122
query62	788	723	637	637
query63	220	191	193	191
query64	4241	1088	750	750
query65	4253	4156	4154	4154
query66	1097	422	372	372
query67	15739	15539	15481	15481
query68	8047	898	538	538
query69	458	300	263	263
query70	1162	1063	1058	1058
query71	464	311	298	298
query72	5631	4721	4803	4721
query73	721	610	348	348
query74	8941	9108	8764	8764
query75	3849	3169	2679	2679
query76	3687	1140	714	714
query77	803	358	291	291
query78	10160	10127	9258	9258
query79	2372	841	588	588
query80	684	509	455	455
query81	490	263	226	226
query82	467	128	98	98
query83	252	252	229	229
query84	255	110	85	85
query85	789	361	323	323
query86	386	311	290	290
query87	4438	4461	4436	4436
query88	3642	2309	2316	2309
query89	379	318	286	286
query90	1867	216	209	209
query91	139	140	111	111
query92	79	62	54	54
query93	1849	958	600	600
query94	680	394	292	292
query95	383	297	290	290
query96	496	567	276	276
query97	2767	2708	2660	2660
query98	231	203	205	203
query99	1454	1403	1239	1239
Total cold run time: 275023 ms
Total hot run time: 184749 ms

doris-robot avatar Jun 26 '25 10:06 doris-robot

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

query1	0.05	0.04	0.04
query2	0.08	0.04	0.05
query3	0.25	0.08	0.08
query4	1.62	0.11	0.11
query5	0.42	0.43	0.42
query6	1.16	0.66	0.67
query7	0.04	0.01	0.01
query8	0.05	0.04	0.04
query9	0.61	0.52	0.52
query10	0.57	0.56	0.57
query11	0.15	0.12	0.11
query12	0.16	0.12	0.12
query13	0.64	0.61	0.62
query14	0.81	0.82	0.81
query15	0.91	0.88	0.88
query16	0.40	0.39	0.40
query17	1.04	1.04	1.09
query18	0.23	0.22	0.22
query19	1.94	1.88	1.91
query20	0.02	0.02	0.01
query21	15.42	0.91	0.58
query22	0.76	1.13	0.70
query23	14.95	1.38	0.64
query24	7.49	1.29	0.44
query25	0.52	0.25	0.07
query26	0.73	0.17	0.14
query27	0.07	0.06	0.05
query28	9.09	0.92	0.44
query29	12.54	4.06	3.32
query30	0.25	0.10	0.06
query31	2.84	0.59	0.40
query32	3.24	0.56	0.48
query33	3.07	3.09	3.19
query34	16.04	5.41	4.79
query35	4.87	4.82	4.86
query36	0.70	0.51	0.48
query37	0.10	0.07	0.07
query38	0.05	0.05	0.04
query39	0.03	0.03	0.03
query40	0.19	0.15	0.14
query41	0.08	0.03	0.02
query42	0.03	0.02	0.03
query43	0.04	0.03	0.02
Total cold run time: 104.25 s
Total hot run time: 29.39 s

doris-robot avatar Jun 26 '25 10:06 doris-robot

run p0

lsy3993 avatar Jun 26 '25 12:06 lsy3993

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

github-actions[bot] avatar Jun 27 '25 01:06 github-actions[bot]