hello-stephen commented on PR #63622: URL: https://github.com/apache/doris/pull/63622#issuecomment-4545663614
<details> <summary>TPC-H: <b>Total hot run time: 31135 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 7e8f8df1fe781d0834691c41471270666298b9cb, data reload: false ------ Round 1 ---------------------------------- orders Doris NULL NULL 0 0 0 NULL 0 NULL NULL 2023-12-26 18:27:23 2023-12-26 18:42:55 NULL utf-8 NULL NULL ============================================ q1 17718 3985 4012 3985 q2 q3 10774 1394 815 815 q4 4720 475 351 351 q5 8335 2287 2083 2083 q6 393 180 141 141 q7 954 763 652 652 q8 9384 1705 1595 1595 q9 7093 4999 4926 4926 q10 6488 2264 1884 1884 q11 450 275 242 242 q12 693 442 306 306 q13 18162 3465 2839 2839 q14 269 256 236 236 q15 q16 827 796 714 714 q17 968 906 988 906 q18 7024 5721 5493 5493 q19 1195 1263 989 989 q20 503 414 266 266 q21 5717 2558 2411 2411 q22 437 361 301 301 Total cold run time: 102104 ms Total hot run time: 31135 ms ----- Round 2, with runtime_filter_mode=off ----- 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 4337 4260 4352 4260 q2 q3 4525 4883 4368 4368 q4 2114 2238 1399 1399 q5 4434 4325 4915 4325 q6 257 203 145 145 q7 1978 1859 1616 1616 q8 2782 2201 2239 2201 q9 8127 8040 8028 8028 q10 4837 4647 q11 q12 q13 q14 q15 q16 q17 q18 q19 q20 q21 q22 Total cold run time: 28554 ms Total hot run time: 26342 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]
