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 2024/10/29 07:07:43 UTC

[PR] [Test](count on index) enhance count on index case retrying for statistics [doris]

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

   ## Proposed changes
   
   Fix case error as below
   ```
   Exception in inverted_index_p0/test_count_on_index.groovy(line 151):
   
   
           sql "sync"
           sql """ set enable_common_expr_pushdown = true """
           sql """set experimental_enable_nereids_planner=true;"""
           sql """set enable_fallback_to_original_planner=false;"""
           sql """analyze table ${testTable_dup} with sync""";
           // wait BE report every partition's row count
           sleep(10000)
           // case1: test duplicate table
           explain {
   ^^^^^^^^^^^^^^^^^^^^^^^^^^ERROR LINE^^^^^^^^^^^^^^^^^^^^^^^^^^
               sql("select COUNT() from ${testTable_dup} where request match 'GET'")
               contains "pushAggOp=COUNT_ON_INDEX"
           }
           qt_sql(" select COUNT(*) from ${testTable_dup} where request match 'images' ")
           sql " set enable_count_on_index_pushdown=false; "
           qt_sql(" select COUNT(*) from ${testTable_dup} where request match 'images' ")
           sql " set enable_count_on_index_pushdown=true; "
   
           // case1.1: test duplicate table with null values.
           sql " insert into ${testTable_dup} values(1683964756,null,'GET /images/hm_bg.jpg HTTP/1.0 ',null,null); "
   
   Exception:
   java.lang.IllegalStateException: Explain and check failed, expect contains 'pushAggOp=COUNT_ON_INDEX', but actual explain string is:
   ```
   
   


-- 
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] [Test](count on index) enhance count on index case retrying for statistics [doris]

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

   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] [Test](count on index) enhance count on index case retrying for statistics [doris]

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

   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [Test](count on index) enhance count on index case retrying for statistics [doris]

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

   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] [Test](count on index) enhance count on index case retrying for statistics [doris]

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

   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] [Test](count on index) enhance count on index case retrying for statistics [doris]

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


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