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

[PR] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   
   ## 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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit fec38a30332cf15bcb0c06c2cd440feb3bbb6523, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4913	4682	4651	4651
   q2	354	161	160	160
   q3	2022	1933	1875	1875
   q4	1387	1260	1253	1253
   q5	3976	3957	4036	3957
   q6	254	134	131	131
   q7	1433	882	891	882
   q8	2771	2818	2783	2783
   q9	9945	9767	9608	9608
   q10	3481	3566	3570	3566
   q11	377	248	245	245
   q12	443	294	294	294
   q13	4577	3824	3830	3824
   q14	318	280	297	280
   q15	592	542	525	525
   q16	665	583	586	583
   q17	1146	981	954	954
   q18	7784	7382	7452	7382
   q19	1694	1689	1701	1689
   q20	588	308	285	285
   q21	4394	4048	3980	3980
   q22	480	372	369	369
   Total cold run time: 53594 ms
   Total hot run time: 49276 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4577	4597	4626	4597
   q2	338	223	240	223
   q3	4007	3990	4004	3990
   q4	2702	2686	2691	2686
   q5	9587	9629	9594	9594
   q6	246	125	126	125
   q7	3022	2462	2411	2411
   q8	4476	4493	4601	4493
   q9	13181	13027	13037	13027
   q10	4130	4201	4199	4199
   q11	721	642	693	642
   q12	974	794	811	794
   q13	4276	3556	3571	3556
   q14	383	346	352	346
   q15	592	527	519	519
   q16	730	667	669	667
   q17	3853	3967	3984	3967
   q18	9511	9036	9011	9011
   q19	1892	1772	1767	1767
   q20	2377	2052	2056	2052
   q21	8825	8478	8668	8478
   q22	912	778	799	778
   Total cold run time: 81312 ms
   Total hot run time: 77922 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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.72 seconds
    stream load tsv:          568 seconds loaded 74807831229 Bytes, about 125 MB/s
    stream load json:         18 seconds loaded 2358488459 Bytes, about 124 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:          28.9 seconds inserted 10000000 Rows, about 346K ops/s
    storage size: 17099509091 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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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

   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] [PipelineX](complex type pushdown) do not push down complex type to storage layer based on PR#25007 [doris]

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


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