You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/06/15 02:56:01 UTC

[GitHub] [incubator-doris] lcs559 opened a new issue, #10147: [Bug] The count result keeps changing

lcs559 opened a new issue, #10147:
URL: https://github.com/apache/incubator-doris/issues/10147

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   0.15
   
   ### What's Wrong?
   
   In the absence of any data update, the results of multiple counts are inconsistent.
   
   Details are as follows:
   
   <img width="646" alt="image" src="https://user-images.githubusercontent.com/12084559/173725841-96f33bd9-13c4-4d70-8c77-230142ab261d.png">
   
   
   ### What You Expected?
   
   83408801
   
   ### How to Reproduce?
   
   The table is unique key,data handle step:
   
   Empty table -> etl incremental insert -> delete data -> full insert - > incremental insert -> count data
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


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


[GitHub] [incubator-doris] caiconghui commented on issue #10147: [Bug] The results of multiple counts are inconsistent

Posted by GitBox <gi...@apache.org>.
caiconghui commented on issue #10147:
URL: https://github.com/apache/incubator-doris/issues/10147#issuecomment-1155938183

   is this table unique key table? 


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


[GitHub] [doris] lcs559 commented on issue #10147: [Bug] The results of multiple counts are inconsistent

Posted by GitBox <gi...@apache.org>.
lcs559 commented on issue #10147:
URL: https://github.com/apache/doris/issues/10147#issuecomment-1161032967

   The uniq model + batch delete +sequence column method , the problem has been tracked for a period of time, and the problem has not been reproduced again, indicating that it has been solved


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


[GitHub] [doris] lcs559 closed issue #10147: [Bug] The results of multiple counts are inconsistent

Posted by GitBox <gi...@apache.org>.
lcs559 closed issue #10147: [Bug] The results of multiple counts are inconsistent
URL: https://github.com/apache/doris/issues/10147


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


[GitHub] [incubator-doris] lcs559 commented on issue #10147: [Bug] The results of multiple counts are inconsistent

Posted by GitBox <gi...@apache.org>.
lcs559 commented on issue #10147:
URL: https://github.com/apache/incubator-doris/issues/10147#issuecomment-1157283078

   The **uniq model + batch delete +sequence column** method is used to solve the problem. At present, the problem has been solved, and we will observe it for a period of time


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