You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "XieJiann (via GitHub)" <gi...@apache.org> on 2023/11/09 09:54:57 UTC

[PR] [enhancement](Nereids) add phase in shape string [doris]

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

   ## Proposed changes
   
   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] [enhancement](Nereids) add phase in shape string [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45 seconds
    stream load tsv:          552 seconds loaded 74807831229 Bytes, about 129 MB/s
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 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.9 seconds inserted 10000000 Rows, about 346K ops/s
    storage size: 17162293597 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] [enhancement](Nereids) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.2 seconds
    stream load tsv:          555 seconds loaded 74807831229 Bytes, about 128 MB/s
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.9 seconds inserted 10000000 Rows, about 346K ops/s
    storage size: 17162223639 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] [enhancement](Nereids) add phase in shape string [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit 0d5bd4dcf862fd23437869e0a239b599e95249e1, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5334	5063	5137	5063
   q2	377	178	202	178
   q3	2101	2071	2067	2067
   q4	1489	1433	1404	1404
   q5	4162	4189	4163	4163
   q6	260	134	134	134
   q7	2089	1600	1615	1600
   q8	2804	2761	2770	2761
   q9	10389	10555	10197	10197
   q10	3493	3560	3577	3560
   q11	373	260	254	254
   q12	463	294	303	294
   q13	4554	4110	4125	4110
   q14	339	296	284	284
   q15	667	555	554	554
   q16	701	622	600	600
   q17	1158	1115	1113	1113
   q18	7775	7186	7454	7186
   q19	1732	1710	1715	1710
   q20	594	381	352	352
   q21	4942	4578	4554	4554
   q22	546	432	448	432
   Total cold run time: 56342 ms
   Total hot run time: 52570 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	5112	5261	5030	5030
   q2	349	244	258	244
   q3	4113	3985	3957	3957
   q4	2779	2776	2755	2755
   q5	6528	6470	6480	6470
   q6	255	126	132	126
   q7	3170	2740	2707	2707
   q8	4789	4727	4768	4727
   q9	17742	17620	17702	17620
   q10	4102	4134	4204	4134
   q11	785	652	678	652
   q12	1013	842	803	803
   q13	4352	3882	3867	3867
   q14	380	350	358	350
   q15	624	592	569	569
   q16	766	699	735	699
   q17	3998	3906	3904	3904
   q18	9527	9401	9351	9351
   q19	1832	1784	1793	1784
   q20	2365	2054	2069	2054
   q21	8978	8866	8782	8782
   q22	930	902	872	872
   Total cold run time: 84489 ms
   Total hot run time: 81457 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) add phase in shape string [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit af83145f67aabc5a7a26966af1a6831f0d6758a0, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	5290	5102	5136	5102
   q2	367	187	194	187
   q3	2090	2050	2087	2050
   q4	1488	1436	1437	1436
   q5	4143	4185	4163	4163
   q6	259	132	131	131
   q7	2081	1615	1601	1601
   q8	2773	2762	2782	2762
   q9	10398	10384	10291	10291
   q10	3491	3579	3572	3572
   q11	376	251	261	251
   q12	468	298	307	298
   q13	4562	4119	4146	4119
   q14	322	297	296	296
   q15	661	554	572	554
   q16	703	626	597	597
   q17	1170	1105	1112	1105
   q18	7892	7394	7225	7225
   q19	1730	1715	1720	1715
   q20	595	380	346	346
   q21	4943	4628	4613	4613
   q22	541	430	450	430
   Total cold run time: 56343 ms
   Total hot run time: 52844 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4989	4944	5102	4944
   q2	329	229	253	229
   q3	4012	4076	3961	3961
   q4	2799	2756	2732	2732
   q5	6543	6532	6521	6521
   q6	247	129	125	125
   q7	3166	2752	2712	2712
   q8	4785	4763	4771	4763
   q9	17769	17742	17639	17639
   q10	4084	4152	4170	4152
   q11	775	629	660	629
   q12	1003	862	807	807
   q13	4293	3918	3893	3893
   q14	384	347	374	347
   q15	651	558	598	558
   q16	772	699	688	688
   q17	3851	3854	3884	3854
   q18	9342	9338	9113	9113
   q19	1877	1805	1808	1805
   q20	2370	2041	2041	2041
   q21	9014	8886	8939	8886
   q22	915	850	877	850
   Total cold run time: 83970 ms
   Total hot run time: 81249 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) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 45.2 seconds
    stream load tsv:          551 seconds loaded 74807831229 Bytes, about 129 MB/s
    stream load json:         20 seconds loaded 2358488459 Bytes, about 112 MB/s
    stream load orc:          65 seconds loaded 1101869774 Bytes, about 16 MB/s
    stream load parquet:          32 seconds loaded 861443392 Bytes, about 25 MB/s
    insert into select:          29.0 seconds inserted 10000000 Rows, about 344K ops/s
    storage size: 17162257975 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] [enhancement](Nereids) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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

   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) add phase in shape string [doris]

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


-- 
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