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/15 03:11:11 UTC

[PR] [fix](Nereids) stats estimation of lessThan [doris]

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

   ## 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] [fix](Nereids) stats estimation of lessThan [doris]

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


-- 
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] [fix](Nereids) stats estimation of lessThan [doris]

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

   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] [fix](Nereids) stats estimation of lessThan [doris]

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

   
   <details>
   <summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
   
   ```
   Tpch sf100 test result on commit a1454bf86018c7be4b27070be5e62013c8328223, data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1	4711	4455	4454	4454
   q2	362	157	155	155
   q3	1453	1262	1236	1236
   q4	1106	930	916	916
   q5	3213	3204	3204	3204
   q6	244	129	126	126
   q7	1020	484	482	482
   q8	2196	2221	2194	2194
   q9	6744	6678	6644	6644
   q10	3225	3303	3308	3303
   q11	327	199	197	197
   q12	363	208	202	202
   q13	4584	3797	3795	3795
   q14	240	210	215	210
   q15	568	525	528	525
   q16	441	384	387	384
   q17	1004	644	572	572
   q18	7039	6768	6884	6768
   q19	1557	1497	1396	1396
   q20	563	299	286	286
   q21	3066	2623	2620	2620
   q22	355	281	288	281
   Total cold run time: 44381 ms
   Total hot run time: 39950 ms
   
   run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
   q1	4392	4357	4413	4357
   q2	263	164	171	164
   q3	3522	3510	3495	3495
   q4	2393	2390	2371	2371
   q5	5746	5726	5750	5726
   q6	239	121	124	121
   q7	2374	1828	1857	1828
   q8	3526	3531	3533	3531
   q9	9068	8994	8994	8994
   q10	3919	4012	4016	4012
   q11	505	399	396	396
   q12	767	596	584	584
   q13	4311	3577	3554	3554
   q14	295	256	261	256
   q15	574	516	520	516
   q16	508	460	453	453
   q17	1866	1863	1829	1829
   q18	8474	8154	8290	8154
   q19	1750	1754	1785	1754
   q20	2250	1959	1937	1937
   q21	6519	6161	6119	6119
   q22	501	436	432	432
   Total cold run time: 63762 ms
   Total hot run time: 60583 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] [fix](Nereids) stats estimation of lessThan [doris]

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

   (From new machine)TeamCity pipeline, clickbench performance test result:
    the sum of best hot time: 44.07 seconds
    stream load tsv:          585 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:          33 seconds loaded 861443392 Bytes, about 24 MB/s
    insert into select:          28.5 seconds inserted 10000000 Rows, about 350K ops/s
    storage size: 17224350748 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] [fix](Nereids) stats estimation of lessThan [doris]

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

   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] [fix](Nereids) stats estimation of lessThan [doris]

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

   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