You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "BiteTheDDDDt (via GitHub)" <gi...@apache.org> on 2024/01/26 03:35:09 UTC

[PR] [Improvement](priv) move check priv out of analyze [doris]

BiteTheDDDDt opened a new pull request, #30403:
URL: https://github.com/apache/doris/pull/30403

   ## Proposed changes
   move check priv out of analyze
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911407016

   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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911455536

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186552 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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
   
   query1	942	337	326	326
   query2	6563	2066	1896	1896
   query3	6703	202	201	201
   query4	33437	22347	22137	22137
   query5	4450	449	367	367
   query6	245	146	150	146
   query7	4612	260	255	255
   query8	220	179	185	179
   query9	8303	2599	2586	2586
   query10	434	228	226	226
   query11	17038	15462	15542	15462
   query12	125	66	66	66
   query13	1666	385	379	379
   query14	10626	7016	7036	7016
   query15	209	181	185	181
   query16	5788	256	258	256
   query17	941	473	495	473
   query18	1800	262	249	249
   query19	171	131	131	131
   query20	73	71	67	67
   query21	193	130	134	130
   query22	4924	4753	4731	4731
   query23	31671	30637	30637	30637
   query24	11169	2830	2860	2830
   query25	554	308	306	306
   query26	870	153	144	144
   query27	2835	277	282	277
   query28	6213	1847	1832	1832
   query29	924	608	616	608
   query30	273	137	136	136
   query31	910	748	740	740
   query32	72	51	51	51
   query33	593	210	213	210
   query34	848	457	470	457
   query35	920	821	801	801
   query36	1256	1177	1202	1177
   query37	91	56	67	56
   query38	3407	3279	3214	3214
   query39	1323	1274	1256	1256
   query40	194	92	81	81
   query41	37	35	36	35
   query42	86	82	80	80
   query43	485	469	477	469
   query44	1057	691	699	691
   query45	193	176	175	175
   query46	1067	651	660	651
   query47	1648	1565	1571	1565
   query48	385	298	320	298
   query49	1092	289	292	289
   query50	688	315	314	314
   query51	5384	5260	5189	5189
   query52	97	75	77	75
   query53	324	258	259	258
   query54	244	179	190	179
   query55	83	82	75	75
   query56	173	163	156	156
   query57	974	933	946	933
   query58	174	152	154	152
   query59	2962	2715	2758	2715
   query60	204	184	182	182
   query61	86	93	89	89
   query62	595	375	358	358
   query63	286	265	262	262
   query64	4313	1813	1764	1764
   query65	3307	3288	3253	3253
   query66	1191	313	317	313
   query67	15744	15095	15186	15095
   query68	12221	532	509	509
   query69	587	297	286	286
   query70	1662	1525	1505	1505
   query71	10437	10199	10201	10199
   query72	5094	2834	2877	2834
   query73	2736	316	318	316
   query74	7681	6374	6342	6342
   query75	4894	2324	2289	2289
   query76	6347	1066	992	992
   query77	655	228	236	228
   query78	9353	8903	8538	8538
   query79	996	527	512	512
   query80	583	330	321	321
   query81	467	201	203	201
   query82	205	77	80	77
   query83	134	114	126	114
   query84	273	67	67	67
   query85	1106	360	318	318
   query86	379	374	391	374
   query87	3515	3359	3399	3359
   query88	2777	2207	2209	2207
   query89	423	370	340	340
   query90	1947	191	183	183
   query91	158	120	135	120
   query92	50	43	47	43
   query93	1591	456	452	452
   query94	1244	161	157	157
   query95	502	453	458	453
   query96	612	320	321	320
   query97	4254	4151	4154	4151
   query98	210	190	181	181
   query99	971	676	697	676
   Total cold run time: 300529 ms
   Total hot run time: 186552 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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911447148

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 39039 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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17661	5354	5374	5354
   q2	2048	145	129	129
   q3	10789	1123	1112	1112
   q4	10373	742	850	742
   q5	7757	3142	3146	3142
   q6	196	120	120	120
   q7	858	486	482	482
   q8	9256	1935	1957	1935
   q9	7210	6384	6357	6357
   q10	8194	3019	3018	3018
   q11	412	196	194	194
   q12	354	189	190	189
   q13	18001	3380	3379	3379
   q14	228	216	222	216
   q15	538	508	514	508
   q16	429	361	394	361
   q17	926	552	497	497
   q18	7552	7107	6928	6928
   q19	1552	1292	1337	1292
   q20	575	322	313	313
   q21	2785	2453	2469	2453
   q22	359	327	318	318
   Total cold run time: 108053 ms
   Total hot run time: 39039 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5485	5447	5291	5291
   q2	323	222	214	214
   q3	3384	3238	3297	3238
   q4	2096	2108	2037	2037
   q5	6054	5948	5978	5948
   q6	198	114	117	114
   q7	2368	1935	1829	1829
   q8	3254	3380	3398	3380
   q9	9160	9024	9069	9024
   q10	4078	4089	4139	4089
   q11	613	497	476	476
   q12	850	674	649	649
   q13	17864	3350	3314	3314
   q14	293	254	266	254
   q15	552	511	509	509
   q16	512	451	469	451
   q17	1879	1847	1819	1819
   q18	9605	15268	9784	9784
   q19	24703	1602	1552	1552
   q20	4609	1937	1917	1917
   q21	14648	5342	5284	5284
   q22	990	568	556	556
   Total cold run time: 113518 ms
   Total hot run time: 61729 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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911543274

   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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "BiteTheDDDDt (via GitHub)" <gi...@apache.org>.
BiteTheDDDDt merged PR #30403:
URL: https://github.com/apache/doris/pull/30403


-- 
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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911458811

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.01 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 0b5fa7bc538d5e1b47ec9d270404079e2469bc76, data reload: false
   
   query1	0.03	0.02	0.02
   query2	0.06	0.02	0.02
   query3	0.22	0.05	0.06
   query4	1.68	0.07	0.07
   query5	0.52	0.53	0.53
   query6	1.24	0.63	0.64
   query7	0.02	0.01	0.01
   query8	0.04	0.02	0.02
   query9	0.54	0.49	0.50
   query10	0.55	0.56	0.56
   query11	0.12	0.09	0.09
   query12	0.11	0.10	0.09
   query13	0.61	0.61	0.60
   query14	0.77	0.80	0.81
   query15	0.79	0.77	0.76
   query16	0.40	0.37	0.37
   query17	0.99	1.01	1.00
   query18	0.23	0.25	0.24
   query19	1.86	1.75	1.76
   query20	0.02	0.01	0.01
   query21	15.40	0.58	0.57
   query22	2.44	2.31	2.00
   query23	17.55	0.90	0.79
   query24	2.49	1.84	0.92
   query25	0.33	0.29	0.14
   query26	0.55	0.14	0.13
   query27	0.05	0.05	0.05
   query28	10.32	0.78	0.76
   query29	12.49	3.27	3.18
   query30	0.54	0.46	0.49
   query31	2.77	0.34	0.35
   query32	3.44	0.49	0.48
   query33	3.24	3.20	3.25
   query34	15.83	4.29	4.34
   query35	4.34	4.31	4.27
   query36	1.12	1.06	1.08
   query37	0.06	0.05	0.05
   query38	0.05	0.02	0.02
   query39	0.02	0.02	0.02
   query40	0.15	0.13	0.13
   query41	0.07	0.01	0.02
   query42	0.02	0.01	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 104.09 s
   Total hot run time: 31.01 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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911460618

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 0b5fa7bc538d5e1b47ec9d270404079e2469bc76 with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       13.7 seconds inserted 10000000 Rows, about 729K ops/s
   ```
   


-- 
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] [Improvement](priv) move check priv out of analyze [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30403:
URL: https://github.com/apache/doris/pull/30403#issuecomment-1911583912

   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