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 2021/11/22 03:48:28 UTC

[GitHub] [incubator-doris] JustinMars1 opened a new issue #7169: ERROR 1064 (HY000) Limit: -1 [Bug] 

JustinMars1 opened a new issue #7169:
URL: https://github.com/apache/incubator-doris/issues/7169


   ### 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
   
   apache/incubator-doris:build-env-1.4.1
   
   ### What's Wrong?
   
   ERROR 1064 (HY000): errCode = 2, detailMessage = Memory exceed limit. New partitioned Aggregation in spill Backend: 172.21.16.8, fragment: 67ef448d62ff4cac-999c74988410454a Used: 21566009856, Limit: -1. You can change the limit by session variable exec_mem_limit.
   but already SET exec_mem_limit = 120G;
   condition : 1. There are 800 million single tables,150GB
   SQL :  select uuid,count(1) from table_a group by uuid limit 100;
   
   
   ### What You Expected?
   
   sql get rigtht result
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   no
   
   ### Are you willing to submit PR?
   
   - [X] 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

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] morningman closed issue #7169: [Bug] ERROR 1064 (HY000) Limit: -1

Posted by GitBox <gi...@apache.org>.
morningman closed issue #7169:
URL: https://github.com/apache/incubator-doris/issues/7169


   


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