You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2026/01/16 08:22:45 UTC

Re: [PR] [fix](mtmv) Fix query err when calc mv functional dependency which has variant and log more detailed info for troubleshoot a problem [doris]

doris-robot commented on PR #59933:
URL: https://github.com/apache/doris/pull/59933#issuecomment-3758731042

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 32382 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 e5a3283b4d77be1362ad984cd74e63c620bfb3f9, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17593	4279	4073	4073
   q2	2080	377	251	251
   q3	10126	1292	775	775
   q4	10235	964	325	325
   q5	7528	2150	1868	1868
   q6	188	167	137	137
   q7	919	820	655	655
   q8	9271	1609	1135	1135
   q9	4914	4638	4662	4638
   q10	6728	1850	1416	1416
   q11	538	317	295	295
   q12	714	774	615	615
   q13	17757	3866	3084	3084
   q14	302	292	280	280
   q15	571	517	517	517
   q16	689	689	633	633
   q17	696	833	524	524
   q18	6721	6600	7060	6600
   q19	1172	1076	686	686
   q20	432	397	280	280
   q21	3342	2704	2538	2538
   q22	1145	1061	1057	1057
   Total cold run time: 103661 ms
   Total hot run time: 32382 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4521	4341	4322	4322
   q2	335	424	340	340
   q3	2364	2780	2331	2331
   q4	1438	1935	1452	1452
   q5	4569	4296	4462	4296
   q6	228	172	136	136
   q7	2119	1911	1823	1823
   q8	2637	2438	2541	2438
   q9	7120	7492	7044	7044
   q10	2637	2850	2301	2301
   q11	560	470	470	470
   q12	692	737	658	658
   q13	3849	4137	3128	3128
   q14	268	288	270	270
   q15	521	491	486	486
   q16	665	667	624	624
   q17	1136	1281	1332	1281
   q18	7601	7444	7209	7209
   q19	911	833	812	812
   q20	1898	1998	1864	1864
   q21	4614	4295	4127	4127
   q22	1115	1031	984	984
   Total cold run time: 51798 ms
   Total hot run time: 48396 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