You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "englefly (via GitHub)" <gi...@apache.org> on 2023/12/07 08:33:39 UTC

[PR] [opt](Nereids) improve Shape check cases [doris]

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

   ## Proposed changes
   1. fix parallel instance num when running shape check
   2. stop auto analyze when running shape check
   3. verify column stats during shape check
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## 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] [opt](Nereids) improve Shape check cases [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.6 seconds
    stream load tsv:          587 seconds loaded 74807831229 Bytes, about 121 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.0 seconds inserted 10000000 Rows, about 357K ops/s
    storage size: 17213722096 Bytes


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 43.75 seconds
    stream load tsv:          565 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.0 seconds inserted 10000000 Rows, about 357K ops/s
    storage size: 17183538614 Bytes


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.08 seconds
    stream load tsv:          568 seconds loaded 74807831229 Bytes, about 125 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          28.7 seconds inserted 10000000 Rows, about 348K ops/s
    storage size: 17183954798 Bytes


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   run pipelinex_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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.7 seconds
    stream load tsv:          563 seconds loaded 74807831229 Bytes, about 126 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.4 seconds inserted 10000000 Rows, about 352K ops/s
    storage size: 17184275923 Bytes


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 4566b18469b3bfdcab2a14c3d7c1a019dcc183bc, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4695	4427	4459	4427
   q2	367	154	159	154
   q3	1467	1290	1267	1267
   q4	1129	980	914	914
   q5	3179	3186	3151	3151
   q6	251	132	128	128
   q7	985	504	503	503
   q8	2218	2219	2180	2180
   q9	6663	6697	6672	6672
   q10	3226	3273	3245	3245
   q11	321	200	213	200
   q12	347	214	205	205
   q13	4546	3774	3806	3774
   q14	241	211	220	211
   q15	568	520	520	520
   q16	448	397	383	383
   q17	1009	596	635	596
   q18	7721	7649	8082	7649
   q19	1528	1398	1374	1374
   q20	513	343	296	296
   q21	3114	2636	2682	2636
   q22	360	297	299	297
   Total cold run time: 44896 ms
   Total hot run time: 40782 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4402	4421	4399	4399
   q2	269	164	174	164
   q3	3535	3527	3522	3522
   q4	2393	2376	2374	2374
   q5	5750	5725	5750	5725
   q6	242	120	123	120
   q7	2377	1866	1877	1866
   q8	3527	3533	3556	3533
   q9	9074	9008	9036	9008
   q10	3913	3971	3997	3971
   q11	512	379	387	379
   q12	770	593	583	583
   q13	4300	3513	3569	3513
   q14	276	258	257	257
   q15	570	528	533	528
   q16	519	488	468	468
   q17	1869	1861	1848	1848
   q18	8735	8369	8298	8298
   q19	1724	1738	1747	1738
   q20	2241	1959	1939	1939
   q21	6559	6229	6183	6183
   q22	514	415	413	413
   Total cold run time: 64071 ms
   Total hot run time: 60829 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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit 2c00484bc09bb0e5f17e8bba2ebbf7ffb5441210, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4686	4400	4398	4398
   q2	359	155	158	155
   q3	1484	1240	1238	1238
   q4	1122	913	873	873
   q5	3157	3173	3141	3141
   q6	246	127	127	127
   q7	987	494	476	476
   q8	2192	2225	2187	2187
   q9	6689	6656	6681	6656
   q10	3245	3292	3304	3292
   q11	311	189	185	185
   q12	351	208	209	208
   q13	4565	3784	3846	3784
   q14	235	214	217	214
   q15	573	521	520	520
   q16	434	392	385	385
   q17	1012	580	560	560
   q18	7173	6914	6817	6817
   q19	1507	1374	1428	1374
   q20	523	317	317	317
   q21	3050	2687	2658	2658
   q22	351	280	284	280
   Total cold run time: 44252 ms
   Total hot run time: 39845 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4329	4348	4309	4309
   q2	270	163	170	163
   q3	3530	3519	3508	3508
   q4	2382	2360	2378	2360
   q5	5734	5701	5729	5701
   q6	241	120	124	120
   q7	2383	1867	1860	1860
   q8	3527	3534	3531	3531
   q9	9015	8977	8990	8977
   q10	3910	4005	4017	4005
   q11	489	370	368	368
   q12	769	589	603	589
   q13	4323	3569	3568	3568
   q14	283	247	262	247
   q15	572	524	528	524
   q16	491	450	461	450
   q17	1887	1862	1853	1853
   q18	8612	8238	8286	8238
   q19	1738	1724	1752	1724
   q20	2256	1943	1937	1937
   q21	6516	6177	6134	6134
   q22	487	409	425	409
   Total cold run time: 63744 ms
   Total hot run time: 60575 ms
   ```
   


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit a0efc771edf13f6196a0de3aa2de76d1c2ac1db8, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4762	4492	4497	4492
   q2	365	151	181	151
   q3	1484	1233	1237	1233
   q4	1132	926	914	914
   q5	3177	3153	3183	3153
   q6	250	129	128	128
   q7	999	498	492	492
   q8	2227	2220	2203	2203
   q9	6704	6660	6699	6660
   q10	3243	3281	3334	3281
   q11	303	187	188	187
   q12	354	213	210	210
   q13	4590	3833	3838	3833
   q14	242	214	220	214
   q15	567	521	543	521
   q16	457	398	395	395
   q17	1000	621	520	520
   q18	7205	6906	6994	6906
   q19	1546	1335	1440	1335
   q20	552	339	306	306
   q21	3075	2653	2694	2653
   q22	361	295	298	295
   Total cold run time: 44595 ms
   Total hot run time: 40082 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4434	4415	4404	4404
   q2	278	171	184	171
   q3	3546	3552	3528	3528
   q4	2388	2377	2385	2377
   q5	5737	5789	5763	5763
   q6	249	120	123	120
   q7	2379	1891	1894	1891
   q8	3546	3538	3516	3516
   q9	9032	9043	9000	9000
   q10	3945	4016	4010	4010
   q11	499	398	384	384
   q12	769	601	603	601
   q13	4314	3596	3563	3563
   q14	289	267	254	254
   q15	574	530	520	520
   q16	517	478	504	478
   q17	1880	1856	1863	1856
   q18	8680	8345	8264	8264
   q19	1727	1748	1752	1748
   q20	2296	1966	1959	1959
   q21	6561	6213	6252	6213
   q22	520	462	443	443
   Total cold run time: 64160 ms
   Total hot run time: 61063 ms
   ```
   


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 8f5c2ca700ddfe6d33f2c737957784e4d63f8ed0, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4683	4446	4479	4446
   q2	362	152	156	152
   q3	1457	1225	1226	1225
   q4	1115	947	963	947
   q5	3172	3144	3144	3144
   q6	250	129	128	128
   q7	1009	487	491	487
   q8	2196	2209	2179	2179
   q9	6689	6677	6661	6661
   q10	3238	3272	3268	3268
   q11	326	192	206	192
   q12	357	214	206	206
   q13	4544	3818	3789	3789
   q14	239	214	218	214
   q15	567	517	523	517
   q16	434	382	380	380
   q17	1007	604	555	555
   q18	8385	8037	7228	7228
   q19	1515	1366	1398	1366
   q20	543	317	1575	317
   q21	3081	2613	2658	2613
   q22	347	273	279	273
   Total cold run time: 45516 ms
   Total hot run time: 40287 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4431	4394	4388	4388
   q2	264	165	167	165
   q3	3533	3524	3528	3524
   q4	2377	2364	2347	2347
   q5	5755	5752	5736	5736
   q6	241	121	120	120
   q7	2358	1849	1845	1845
   q8	3525	3522	3516	3516
   q9	9065	9005	8954	8954
   q10	3904	3985	4013	3985
   q11	503	371	385	371
   q12	764	596	594	594
   q13	4304	3545	3577	3545
   q14	289	239	256	239
   q15	563	530	517	517
   q16	497	495	455	455
   q17	1872	1854	1853	1853
   q18	8630	8215	8139	8139
   q19	1724	1742	1740	1740
   q20	2248	1961	1929	1929
   q21	6500	6131	6159	6131
   q22	503	420	416	416
   Total cold run time: 63850 ms
   Total hot run time: 60509 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] [opt](Nereids) improve Shape check cases [doris]

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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit 1aae7d30781446ebf75987fa159cbed36f60dcd7, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4700	4440	4420	4420
   q2	360	154	160	154
   q3	1443	1274	1240	1240
   q4	1114	924	887	887
   q5	3162	3151	3166	3151
   q6	243	127	128	127
   q7	979	484	491	484
   q8	2175	2174	2176	2174
   q9	6657	6632	6678	6632
   q10	3237	3290	3278	3278
   q11	309	188	181	181
   q12	351	212	202	202
   q13	4564	3820	3822	3820
   q14	239	209	220	209
   q15	564	527	526	526
   q16	446	392	387	387
   q17	996	553	595	553
   q18	7088	6915	6872	6872
   q19	1530	1358	1374	1358
   q20	503	328	286	286
   q21	3006	2615	2709	2615
   q22	357	276	279	276
   Total cold run time: 44023 ms
   Total hot run time: 39832 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4371	4321	4321	4321
   q2	269	164	173	164
   q3	3554	3531	3514	3514
   q4	2388	2375	2387	2375
   q5	5740	5759	5740	5740
   q6	240	123	118	118
   q7	2375	1861	1874	1861
   q8	3508	3501	3520	3501
   q9	9014	9035	8995	8995
   q10	3917	4005	4018	4005
   q11	482	375	361	361
   q12	770	612	593	593
   q13	4319	3605	3535	3535
   q14	286	257	266	257
   q15	564	520	527	520
   q16	526	482	460	460
   q17	1885	1843	1840	1840
   q18	8599	8083	8276	8083
   q19	1715	1747	1749	1747
   q20	2251	1942	1929	1929
   q21	6544	6180	6183	6180
   q22	494	424	416	416
   Total cold run time: 63811 ms
   Total hot run time: 60515 ms
   ```
   


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   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] [opt](Nereids) improve Shape check cases [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.57 seconds
    stream load tsv:          590 seconds loaded 74807831229 Bytes, about 120 MB/s
    stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
    stream load orc:          66 seconds loaded 1101869774 Bytes, about 15 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.4 seconds inserted 10000000 Rows, about 352K ops/s
    storage size: 17213796207 Bytes


-- 
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] [opt](Nereids) improve Shape check cases [doris]

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

   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