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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34690 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 7d19f2578e11bb3ca884cb03ff8162dbcf3da4d7, 
data reload: false
   
   ------ Round 1 ----------------------------------
   q1   17695   5109    4893    4893
   q2   1990    313     206     206
   q3   10270   1288    712     712
   q4   10237   942     363     363
   q5   7512    2321    2403    2321
   q6   183     167     137     137
   q7   924     774     635     635
   q8   9361    1328    1134    1134
   q9   7211    5355    5373    5355
   q10  6892    2232    1792    1792
   q11  494     293     289     289
   q12  330     364     229     229
   q13  17795   3621    3004    3004
   q14  232     237     207     207
   q15  567     512     508     508
   q16  979     998     944     944
   q17  586     871     361     361
   q18  7369    7376    7654    7376
   q19  1208    967     550     550
   q20  349     365     236     236
   q21  4125    3379    2393    2393
   q22  1125    1145    1045    1045
   Total cold run time: 107434 ms
   Total hot run time: 34690 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   use_rf_default       false   false   0
   use_v2_rollup        false   false   0
   validate_password_policy     NONE    NONE    0
   version      5.7.99  5.7.99  0
   version_comment      doris version doris-0.0.0-b84c98ced6    doris version 
doris-0.0.0-b84c98ced6    0
   wait_timeout 28800   28800   0
   workload_group                       0
   ============================================
   show table status;
   Name Engine  Version Row_format      Rows    Avg_row_length  Data_length     
Max_data_length Index_length    Data_free       Auto_increment  Create_time     
Update_time     Check_time      Collation       Checksum        Create_options  
Comment
   revenue0     View    NULL    NULL    -1      0       0       NULL    0       
NULL    NULL    2023-12-26 18:27:24     NULL    NULL    utf-8   NULL    NULL    
   partsupp     Doris   NULL    NULL    80000000        56      4534120086      
NULL    44625495        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:44:20     NULL    utf-8   NULL    NULL    
   part Doris   NULL    NULL    20000000        37      748811035       NULL    
1935627 NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:57     NULL    
utf-8   NULL    NULL    
   nation       Doris   NULL    NULL    25      138     3473    NULL    366     
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   customer     Doris   NULL    NULL    15000000        92      1381653732      
NULL    4374759 NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:43     
NULL    utf-8   NULL    NULL    
   lineitem     Doris   NULL    NULL    600037902       33      19843441616     
NULL    61784740        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:38:59     NULL    utf-8   NULL    NULL    
   supplier     Doris   NULL    NULL    1000000 87      87519212        NULL    
194931  NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:25     NULL    
utf-8   NULL    NULL    
   region       Doris   NULL    NULL    5       240     1201    NULL    147     
NULL    NULL    2023-12-26 18:27:23     2023-12-26 18:27:24     NULL    utf-8   
NULL    NULL    
   orders       Doris   NULL    NULL    150000000       42      6422171781      
NULL    22778155        NULL    NULL    2023-12-26 18:27:23     2023-12-26 
18:42:55     NULL    utf-8   NULL    NULL    
   ============================================
   q1   5233    5160    5274    5160
   q2   305     404     322     322
   q3   2356    2811    q4      q5      q6      q7      q8      q9      q10     
q11     q12     q13     q14     q15     q16     q17     q18     q19     q20     
q21     q22     Total cold run time: 5538 ms
   Total hot run time: 5482 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to