You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Vallishp (via GitHub)" <gi...@apache.org> on 2024/10/31 05:29:42 UTC

[PR] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   ## Proposed changes
   
   Issue Number: close #42719 
   
   implement showSqlBlockRuleCommand in nereids
   
   


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41360 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 e4a730ad824ec1ec95b81067de9cfd47deb3db97, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17757	7473	7252	7252
   q2	2051	166	158	158
   q3	10676	1087	1159	1087
   q4	10367	861	824	824
   q5	7748	3116	3055	3055
   q6	234	144	143	143
   q7	1003	609	612	609
   q8	9354	1948	1970	1948
   q9	6532	6457	6497	6457
   q10	7068	2398	2401	2398
   q11	467	256	252	252
   q12	407	213	210	210
   q13	17776	3022	2966	2966
   q14	244	212	204	204
   q15	557	526	515	515
   q16	680	593	608	593
   q17	1006	552	562	552
   q18	7418	6796	6755	6755
   q19	1325	1021	1008	1008
   q20	481	182	186	182
   q21	3960	3198	3184	3184
   q22	1098	1008	1018	1008
   Total cold run time: 108209 ms
   Total hot run time: 41360 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	7264	7358	7253	7253
   q2	319	233	225	225
   q3	3057	2947	2978	2947
   q4	2073	1871	1825	1825
   q5	5753	5820	5927	5820
   q6	229	138	137	137
   q7	2283	1817	1784	1784
   q8	3425	3536	3463	3463
   q9	8925	8923	8852	8852
   q10	3620	3549	3588	3549
   q11	617	491	506	491
   q12	836	633	596	596
   q13	9518	3161	3222	3161
   q14	320	284	300	284
   q15	563	515	513	513
   q16	690	657	642	642
   q17	1852	1612	1629	1612
   q18	8474	7806	7652	7652
   q19	1720	1536	1620	1536
   q20	2115	1878	1903	1878
   q21	5494	5383	5447	5383
   q22	1149	1049	1049	1049
   Total cold run time: 70296 ms
   Total hot run time: 60652 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run build all


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run p0


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run p0


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run p0


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run p0


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.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 8e783dbfcd6429124ef09e1aa8bdf90d99b92730, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.06	0.03	0.03
   query3	0.22	0.06	0.06
   query4	1.65	0.10	0.10
   query5	0.43	0.41	0.42
   query6	1.16	0.65	0.66
   query7	0.02	0.01	0.02
   query8	0.03	0.03	0.03
   query9	0.57	0.49	0.50
   query10	0.56	0.56	0.55
   query11	0.14	0.10	0.11
   query12	0.16	0.11	0.12
   query13	0.61	0.59	0.59
   query14	2.83	2.73	2.84
   query15	0.90	0.82	0.82
   query16	0.41	0.37	0.38
   query17	0.99	1.05	1.07
   query18	0.20	0.20	0.21
   query19	1.90	1.90	2.00
   query20	0.02	0.01	0.01
   query21	15.37	0.57	0.55
   query22	2.59	2.62	1.70
   query23	17.02	0.90	0.73
   query24	3.37	0.48	0.58
   query25	0.30	0.11	0.17
   query26	0.39	0.14	0.13
   query27	0.04	0.03	0.04
   query28	11.38	1.09	1.06
   query29	12.60	3.24	3.27
   query30	0.24	0.06	0.06
   query31	2.87	0.37	0.38
   query32	3.31	0.45	0.45
   query33	2.98	3.00	3.04
   query34	16.78	4.54	4.53
   query35	4.53	4.54	4.59
   query36	0.67	0.50	0.48
   query37	0.08	0.06	0.05
   query38	0.04	0.03	0.03
   query39	0.03	0.02	0.02
   query40	0.16	0.12	0.13
   query41	0.07	0.02	0.02
   query42	0.03	0.02	0.02
   query43	0.03	0.03	0.02
   Total cold run time: 107.78 s
   Total hot run time: 31.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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 41433 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 8e783dbfcd6429124ef09e1aa8bdf90d99b92730, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17586	7360	7267	7267
   q2	2052	164	157	157
   q3	10571	1102	1133	1102
   q4	10234	861	887	861
   q5	7729	3077	3081	3077
   q6	236	146	143	143
   q7	1021	601	608	601
   q8	9342	1958	2023	1958
   q9	6611	6449	6473	6449
   q10	7112	2450	2435	2435
   q11	456	250	251	250
   q12	410	213	209	209
   q13	17779	3030	2995	2995
   q14	241	208	208	208
   q15	570	508	513	508
   q16	669	594	592	592
   q17	971	587	507	507
   q18	7271	6738	6812	6738
   q19	1337	1045	998	998
   q20	465	180	181	180
   q21	4027	3183	3254	3183
   q22	1161	1050	1015	1015
   Total cold run time: 107851 ms
   Total hot run time: 41433 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	7349	7289	7240	7240
   q2	325	223	232	223
   q3	2957	2952	2992	2952
   q4	2074	1836	1759	1759
   q5	5744	5708	5777	5708
   q6	229	140	142	140
   q7	2251	1864	1835	1835
   q8	3423	3639	3541	3541
   q9	8993	9022	8974	8974
   q10	3590	3550	3545	3545
   q11	585	480	494	480
   q12	818	663	627	627
   q13	10308	3172	3208	3172
   q14	306	272	293	272
   q15	577	523	528	523
   q16	708	653	672	653
   q17	1848	1660	1648	1648
   q18	8360	7894	7612	7612
   q19	1733	1600	1630	1600
   q20	2113	1822	1880	1822
   q21	5697	5519	5531	5519
   q22	1180	1058	1061	1058
   Total cold run time: 71168 ms
   Total hot run time: 60903 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on code in PR #42979:
URL: https://github.com/apache/doris/pull/42979#discussion_r1843150004


##########
fe/fe-core/src/main/java/org/apache/doris/blockrule/SqlBlockRuleMgr.java:
##########
@@ -90,6 +91,21 @@ public List<SqlBlockRule> getSqlBlockRule(ShowSqlBlockRuleStmt stmt) throws Anal
         return Lists.newArrayList(nameToSqlBlockRuleMap.values());
     }
 
+    /**
+     * Get SqlBlockRule by show command.
+     **/
+    public List<SqlBlockRule> getSqlBlockRule(ShowSqlBlockRuleCommand cmd) throws AnalysisException {

Review Comment:
   better to use String as parameter and change the old code to call the new function to remove duplicate code
   ```suggestion
       public List<SqlBlockRule> getSqlBlockRule(String ruleName) throws AnalysisException {
   ```



-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.24 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 e4a730ad824ec1ec95b81067de9cfd47deb3db97, data reload: false
   
   query1	0.03	0.03	0.03
   query2	0.07	0.02	0.03
   query3	0.23	0.07	0.07
   query4	1.65	0.10	0.10
   query5	0.40	0.39	0.40
   query6	1.17	0.65	0.65
   query7	0.02	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.58	0.50	0.49
   query10	0.56	0.54	0.58
   query11	0.14	0.10	0.11
   query12	0.13	0.10	0.10
   query13	0.62	0.59	0.60
   query14	2.70	2.73	2.74
   query15	0.90	0.83	0.82
   query16	0.39	0.39	0.37
   query17	1.06	1.00	1.01
   query18	0.20	0.19	0.19
   query19	1.98	1.80	1.90
   query20	0.01	0.01	0.02
   query21	15.38	0.59	0.59
   query22	2.41	1.76	1.60
   query23	16.94	1.15	0.82
   query24	3.22	2.32	0.13
   query25	0.18	0.06	0.05
   query26	0.41	0.14	0.13
   query27	0.04	0.05	0.04
   query28	10.37	1.08	1.06
   query29	12.56	3.19	3.16
   query30	0.24	0.06	0.05
   query31	2.89	0.38	0.36
   query32	3.29	0.46	0.45
   query33	2.97	3.00	3.07
   query34	17.14	4.46	4.46
   query35	4.47	4.54	4.56
   query36	0.68	0.47	0.50
   query37	0.08	0.05	0.05
   query38	0.05	0.03	0.03
   query39	0.03	0.02	0.02
   query40	0.16	0.13	0.12
   query41	0.08	0.02	0.02
   query42	0.03	0.02	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 106.54 s
   Total hot run time: 31.24 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40886 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 3ff2c070f9b1f737c107f63816ea5b58b47d2265, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17562	7398	7256	7256
   q2	2045	171	180	171
   q3	10767	1064	1163	1064
   q4	10513	906	822	822
   q5	7777	3078	3059	3059
   q6	241	141	146	141
   q7	1009	612	586	586
   q8	9345	1873	1990	1873
   q9	6585	6403	6393	6393
   q10	7081	2442	2427	2427
   q11	477	265	258	258
   q12	409	219	214	214
   q13	17772	3025	2978	2978
   q14	244	211	211	211
   q15	570	513	526	513
   q16	658	581	582	581
   q17	978	505	561	505
   q18	7339	6738	6635	6635
   q19	1331	1065	964	964
   q20	475	183	177	177
   q21	3982	3296	3074	3074
   q22	1147	984	1005	984
   Total cold run time: 108307 ms
   Total hot run time: 40886 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	7322	7220	7238	7220
   q2	323	226	230	226
   q3	2938	2958	2929	2929
   q4	2041	1807	1817	1807
   q5	5714	5799	5779	5779
   q6	232	147	147	147
   q7	2239	1850	1788	1788
   q8	3359	3507	3436	3436
   q9	8928	8955	8886	8886
   q10	3570	3547	3548	3547
   q11	596	504	506	504
   q12	806	665	642	642
   q13	10376	3180	3167	3167
   q14	304	277	274	274
   q15	575	520	513	513
   q16	676	638	656	638
   q17	1876	1668	1634	1634
   q18	8348	7742	7674	7674
   q19	1704	1692	1416	1416
   q20	2143	1905	1916	1905
   q21	5667	5404	5367	5367
   q22	1131	1035	1047	1035
   Total cold run time: 70868 ms
   Total hot run time: 60534 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run p0


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 32.66 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 3ff2c070f9b1f737c107f63816ea5b58b47d2265, data reload: false
   
   query1	0.03	0.03	0.03
   query2	0.07	0.03	0.03
   query3	0.24	0.07	0.07
   query4	1.63	0.11	0.10
   query5	0.42	0.39	0.41
   query6	1.15	0.68	0.65
   query7	0.02	0.01	0.02
   query8	0.04	0.03	0.03
   query9	0.57	0.50	0.49
   query10	0.54	0.54	0.56
   query11	0.15	0.11	0.11
   query12	0.14	0.12	0.11
   query13	0.60	0.59	0.60
   query14	2.82	2.88	2.73
   query15	0.90	0.82	0.82
   query16	0.38	0.38	0.38
   query17	1.08	1.00	1.04
   query18	0.21	0.20	0.20
   query19	1.89	1.88	1.92
   query20	0.01	0.01	0.02
   query21	15.35	0.59	0.57
   query22	2.60	2.54	1.75
   query23	17.05	0.84	0.85
   query24	3.56	1.79	1.24
   query25	0.24	0.05	0.13
   query26	0.57	0.14	0.13
   query27	0.04	0.03	0.04
   query28	9.69	1.09	1.07
   query29	12.56	3.27	3.27
   query30	0.25	0.05	0.05
   query31	2.89	0.39	0.37
   query32	3.28	0.45	0.46
   query33	2.98	3.02	3.10
   query34	17.07	4.47	4.45
   query35	4.53	4.44	4.43
   query36	0.65	0.48	0.48
   query37	0.09	0.06	0.06
   query38	0.05	0.03	0.04
   query39	0.03	0.02	0.02
   query40	0.16	0.11	0.12
   query41	0.08	0.03	0.02
   query42	0.04	0.02	0.02
   query43	0.03	0.04	0.03
   Total cold run time: 106.68 s
   Total hot run time: 32.66 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on code in PR #42979:
URL: https://github.com/apache/doris/pull/42979#discussion_r1823823450


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowSqlBlockRuleCommand.java:
##########
@@ -0,0 +1,81 @@
+// 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.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.ShowSqlBlockRuleStmt;
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.blockrule.SqlBlockRule;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.Lists;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+
+/**
+ * show sql block rule command
+ */
+public class ShowSqlBlockRuleCommand extends Command implements NoForward {
+    public static final Logger LOG = LogManager.getLogger(ShowSqlBlockRuleCommand.class);
+    private String ruleName; // optional
+
+    /**
+     * constructor
+     */
+    public ShowSqlBlockRuleCommand(String ruleName) {
+        super(PlanType.SHOW_BLOCK_RULE_COMMAND);
+        this.ruleName = ruleName;
+    }
+
+    public String getRuleName() {
+        return ruleName;
+    }
+
+    @Override
+    public void run(ConnectContext ctx, StmtExecutor executor) throws Exception {
+        // check auth
+        if (!Env.getCurrentEnv().getAccessManager().checkGlobalPriv(ConnectContext.get(), PrivPredicate.ADMIN)) {
+            ErrorReport.reportAnalysisException(ErrorCode.ERR_SPECIFIC_ACCESS_DENIED_ERROR, "ADMIN");
+        }
+        ShowSqlBlockRuleStmt showStmt = new ShowSqlBlockRuleStmt(ruleName);
+        List<List<String>> rows = Lists.newArrayList();
+        List<SqlBlockRule> sqlBlockRules = Env.getCurrentEnv().getSqlBlockRuleMgr().getSqlBlockRule(showStmt);

Review Comment:
   pls add a new getSqlBlockRule function without dependence of ShowSqlBlockRuleStmt



-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 196780 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 8e783dbfcd6429124ef09e1aa8bdf90d99b92730, data reload: false
   
   query1	1248	1002	976	976
   query2	6257	1984	1999	1984
   query3	11644	4764	4821	4764
   query4	33758	23782	23556	23556
   query5	4793	457	437	437
   query6	273	185	171	171
   query7	4000	293	295	293
   query8	288	225	225	225
   query9	9569	2623	2613	2613
   query10	472	257	260	257
   query11	18176	15088	15181	15088
   query12	145	105	98	98
   query13	1559	427	396	396
   query14	8609	7406	7532	7406
   query15	287	185	186	185
   query16	8158	488	512	488
   query17	1562	596	585	585
   query18	2153	320	302	302
   query19	364	163	160	160
   query20	121	116	118	116
   query21	204	108	106	106
   query22	4961	4654	4718	4654
   query23	35528	33921	34097	33921
   query24	11000	2722	2813	2722
   query25	557	393	406	393
   query26	754	160	157	157
   query27	2255	287	277	277
   query28	7430	2426	2410	2410
   query29	655	416	411	411
   query30	264	168	160	160
   query31	1013	779	771	771
   query32	96	56	56	56
   query33	759	261	272	261
   query34	937	517	516	516
   query35	1036	885	889	885
   query36	1094	944	937	937
   query37	127	76	76	76
   query38	4446	4265	4333	4265
   query39	1455	1399	1395	1395
   query40	206	98	96	96
   query41	46	46	48	46
   query42	109	95	97	95
   query43	523	484	471	471
   query44	1229	800	802	800
   query45	182	168	163	163
   query46	1132	700	682	682
   query47	1996	1819	1868	1819
   query48	425	322	319	319
   query49	891	387	393	387
   query50	807	380	396	380
   query51	7207	6934	6950	6934
   query52	96	86	87	86
   query53	249	179	180	179
   query54	1092	388	389	388
   query55	74	72	74	72
   query56	249	238	235	235
   query57	1242	1184	1155	1155
   query58	225	205	197	197
   query59	3132	3123	2921	2921
   query60	259	239	245	239
   query61	103	98	99	98
   query62	847	683	665	665
   query63	209	183	183	183
   query64	3832	623	639	623
   query65	3262	3215	3274	3215
   query66	814	333	298	298
   query67	16003	15612	15690	15612
   query68	4532	542	533	533
   query69	422	251	263	251
   query70	1185	1139	1147	1139
   query71	323	259	253	253
   query72	6047	4041	3935	3935
   query73	764	349	351	349
   query74	10251	9018	8950	8950
   query75	3440	2660	2665	2660
   query76	2662	1075	1059	1059
   query77	369	283	263	263
   query78	10873	9734	9598	9598
   query79	1107	572	585	572
   query80	677	413	432	413
   query81	511	248	240	240
   query82	1280	114	117	114
   query83	161	149	139	139
   query84	240	68	66	66
   query85	887	313	286	286
   query86	320	272	298	272
   query87	4782	4584	4754	4584
   query88	3174	2196	2158	2158
   query89	430	301	293	293
   query90	1948	185	181	181
   query91	131	96	97	96
   query92	56	47	47	47
   query93	1073	538	528	528
   query94	707	283	287	283
   query95	351	251	249	249
   query96	617	279	283	279
   query97	2865	2675	2699	2675
   query98	221	198	198	198
   query99	1510	1310	1286	1286
   Total cold run time: 298364 ms
   Total hot run time: 196780 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

Posted by "Vallishp (via GitHub)" <gi...@apache.org>.
Vallishp commented on code in PR #42979:
URL: https://github.com/apache/doris/pull/42979#discussion_r1824011062


##########
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/ShowSqlBlockRuleCommand.java:
##########
@@ -0,0 +1,81 @@
+// 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.
+
+package org.apache.doris.nereids.trees.plans.commands;
+
+import org.apache.doris.analysis.ShowSqlBlockRuleStmt;
+import org.apache.doris.analysis.StmtType;
+import org.apache.doris.blockrule.SqlBlockRule;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.ErrorReport;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.trees.plans.PlanType;
+import org.apache.doris.nereids.trees.plans.visitor.PlanVisitor;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.qe.ShowResultSet;
+import org.apache.doris.qe.StmtExecutor;
+
+import com.google.common.collect.Lists;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+
+/**
+ * show sql block rule command
+ */
+public class ShowSqlBlockRuleCommand extends Command implements NoForward {
+    public static final Logger LOG = LogManager.getLogger(ShowSqlBlockRuleCommand.class);
+    private String ruleName; // optional
+
+    /**
+     * constructor
+     */
+    public ShowSqlBlockRuleCommand(String ruleName) {
+        super(PlanType.SHOW_BLOCK_RULE_COMMAND);
+        this.ruleName = ruleName;
+    }
+
+    public String getRuleName() {
+        return ruleName;
+    }
+
+    @Override
+    public void run(ConnectContext ctx, StmtExecutor executor) throws Exception {
+        // check auth
+        if (!Env.getCurrentEnv().getAccessManager().checkGlobalPriv(ConnectContext.get(), PrivPredicate.ADMIN)) {
+            ErrorReport.reportAnalysisException(ErrorCode.ERR_SPECIFIC_ACCESS_DENIED_ERROR, "ADMIN");
+        }
+        ShowSqlBlockRuleStmt showStmt = new ShowSqlBlockRuleStmt(ruleName);
+        List<List<String>> rows = Lists.newArrayList();
+        List<SqlBlockRule> sqlBlockRules = Env.getCurrentEnv().getSqlBlockRuleMgr().getSqlBlockRule(showStmt);

Review Comment:
   thanks. updated.



-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 195637 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 e4a730ad824ec1ec95b81067de9cfd47deb3db97, data reload: false
   
   query1	1204	889	916	889
   query2	6246	2027	2046	2027
   query3	10775	3987	3919	3919
   query4	68041	29074	23696	23696
   query5	4912	473	444	444
   query6	409	195	175	175
   query7	5677	300	298	298
   query8	298	227	220	220
   query9	9309	2744	2733	2733
   query10	446	254	240	240
   query11	17703	15518	15816	15518
   query12	157	108	111	108
   query13	1564	434	430	430
   query14	10602	7206	7114	7114
   query15	196	175	178	175
   query16	7066	437	464	437
   query17	1023	554	551	551
   query18	1781	285	289	285
   query19	199	146	149	146
   query20	114	109	108	108
   query21	205	101	99	99
   query22	4557	4419	4399	4399
   query23	34550	33997	33869	33869
   query24	6053	2694	2738	2694
   query25	502	388	389	388
   query26	658	156	154	154
   query27	1709	290	284	284
   query28	4273	2466	2445	2445
   query29	685	431	431	431
   query30	239	164	154	154
   query31	969	812	770	770
   query32	67	53	53	53
   query33	400	263	268	263
   query34	898	514	521	514
   query35	883	729	726	726
   query36	1048	951	937	937
   query37	125	75	70	70
   query38	4359	4279	4212	4212
   query39	1499	1463	1431	1431
   query40	201	101	100	100
   query41	49	44	45	44
   query42	107	96	98	96
   query43	537	497	492	492
   query44	1159	808	813	808
   query45	184	163	164	163
   query46	1134	711	685	685
   query47	1976	1853	1917	1853
   query48	429	316	330	316
   query49	739	425	403	403
   query50	809	393	405	393
   query51	7252	7226	6999	6999
   query52	101	91	92	91
   query53	253	188	207	188
   query54	515	395	408	395
   query55	76	72	75	72
   query56	244	227	231	227
   query57	1294	1201	1160	1160
   query58	201	201	201	201
   query59	3196	3094	2930	2930
   query60	280	247	237	237
   query61	103	100	104	100
   query62	784	687	664	664
   query63	214	191	180	180
   query64	1374	614	589	589
   query65	3291	3183	3180	3180
   query66	738	304	292	292
   query67	15876	15480	15718	15480
   query68	3067	605	607	605
   query69	408	255	248	248
   query70	1202	1148	1127	1127
   query71	373	255	255	255
   query72	6095	3954	3915	3915
   query73	766	363	357	357
   query74	10009	8952	9006	8952
   query75	3366	2645	2673	2645
   query76	1512	1083	1106	1083
   query77	479	291	264	264
   query78	10358	9419	9332	9332
   query79	1211	598	607	598
   query80	804	409	431	409
   query81	510	236	241	236
   query82	1354	117	116	116
   query83	160	139	135	135
   query84	281	68	68	68
   query85	833	277	283	277
   query86	324	298	294	294
   query87	4778	4761	4661	4661
   query88	3460	2218	2167	2167
   query89	410	299	284	284
   query90	2027	195	184	184
   query91	134	95	99	95
   query92	58	48	54	48
   query93	1322	535	550	535
   query94	773	283	286	283
   query95	339	244	240	240
   query96	604	275	288	275
   query97	2912	2675	2753	2675
   query98	225	219	213	213
   query99	1626	1320	1317	1317
   Total cold run time: 316297 ms
   Total hot run time: 195637 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 195818 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 3ff2c070f9b1f737c107f63816ea5b58b47d2265, data reload: false
   
   query1	1212	942	901	901
   query2	6255	2049	2057	2049
   query3	10835	3971	4098	3971
   query4	68411	28344	23487	23487
   query5	4983	456	448	448
   query6	393	182	175	175
   query7	5605	296	291	291
   query8	301	223	214	214
   query9	9244	2662	2624	2624
   query10	450	256	257	256
   query11	17458	15380	15861	15380
   query12	159	101	99	99
   query13	1569	437	438	437
   query14	10100	7648	6982	6982
   query15	209	186	177	177
   query16	7059	442	485	442
   query17	1021	548	565	548
   query18	1762	301	294	294
   query19	189	149	146	146
   query20	113	113	112	112
   query21	201	103	104	103
   query22	4426	4364	4191	4191
   query23	34699	34752	34154	34154
   query24	5981	2775	2778	2775
   query25	516	402	391	391
   query26	646	157	157	157
   query27	1688	288	296	288
   query28	4140	2434	2400	2400
   query29	704	432	437	432
   query30	231	154	154	154
   query31	985	812	818	812
   query32	66	55	57	55
   query33	423	263	273	263
   query34	908	502	513	502
   query35	854	725	740	725
   query36	1076	952	948	948
   query37	115	73	73	73
   query38	4366	4267	4228	4228
   query39	1461	1449	1444	1444
   query40	201	98	101	98
   query41	48	44	49	44
   query42	107	99	96	96
   query43	560	491	487	487
   query44	1209	825	836	825
   query45	181	163	170	163
   query46	1121	694	702	694
   query47	1976	1826	1834	1826
   query48	406	314	327	314
   query49	750	413	388	388
   query50	795	404	389	389
   query51	7310	7136	7054	7054
   query52	99	90	85	85
   query53	248	177	179	177
   query54	506	403	399	399
   query55	74	75	79	75
   query56	252	229	222	222
   query57	1302	1172	1159	1159
   query58	210	194	198	194
   query59	3272	2888	2919	2888
   query60	275	242	241	241
   query61	121	111	107	107
   query62	772	664	686	664
   query63	214	188	185	185
   query64	1353	640	627	627
   query65	3280	3214	3236	3214
   query66	698	301	297	297
   query67	15960	15720	15623	15623
   query68	3816	591	590	590
   query69	419	260	245	245
   query70	1177	1148	1142	1142
   query71	350	249	249	249
   query72	6178	4102	3991	3991
   query73	763	360	359	359
   query74	9985	9001	9050	9001
   query75	3377	2644	2700	2644
   query76	1714	1193	1210	1193
   query77	462	282	273	273
   query78	10355	9519	9386	9386
   query79	2148	587	594	587
   query80	1413	414	416	414
   query81	536	239	245	239
   query82	1289	111	114	111
   query83	248	141	158	141
   query84	279	74	72	72
   query85	1004	298	289	289
   query86	393	299	300	299
   query87	4930	4623	4653	4623
   query88	3583	2182	2163	2163
   query89	413	284	287	284
   query90	1960	187	184	184
   query91	133	100	105	100
   query92	66	47	49	47
   query93	2905	556	546	546
   query94	883	299	280	280
   query95	341	247	243	243
   query96	627	293	286	286
   query97	2899	2694	2686	2686
   query98	210	203	200	200
   query99	1619	1331	1288	1288
   Total cold run time: 320589 ms
   Total hot run time: 195818 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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   run external


-- 
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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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] [Enhancement] (nereids)implement showSqlBlockRuleCommand in nereids [doris]

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

   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