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 2020/03/20 15:59:16 UTC
[GitHub] [incubator-doris] wyb opened a new issue #3170: [Bug] memory exceed
limit when group by varchar columns
wyb opened a new issue #3170: [Bug] memory exceed limit when group by varchar columns
URL: https://github.com/apache/incubator-doris/issues/3170
4 backends, 32G memory per backend
Errors happen when execute two SQLs concurrently.
ERROR 1064 (HY000): errCode = 2, detailMessage = Memory exceed limit. New partitioned aggregation, while getting rows in streaming. Backend: 172.18.206.190, fragment: 5943ed36d4d24746-98837f1e5d257668 Used: 26422635638, Limit: 26416034611. You can change the limit by session variable exec_mem_limit.
Group by columns type:
dim1.c_name VARCHAR(300)
dim1.c_code VARCHAR(270)
dim_date.year_month_sk BIGINT
t1.type_desc VARCHAR(50)
t1.type VARCHAR(2)
SQL:
```sql
SELECT dim1.c_name, dim1.c_code, dim_date.year_month_sk, dim_date.year_month_sk, t1.type_desc
, t1.type, SUM(t1.v1), SUM(t1.v2)
FROM t1
JOIN dim1 ON dim1.code = t1.code
LEFT JOIN dim_date ON dim_date.date_sid = t1.d_date
GROUP BY dim1.c_name, dim1.c_code, dim_date.year_month_sk, t1.type_desc, t1.type
ORDER BY 1 ASC
LIMIT 20
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] imay closed issue #3170: [Bug] memory exceed
limit when group by varchar columns
Posted by GitBox <gi...@apache.org>.
imay closed issue #3170: [Bug] memory exceed limit when group by varchar columns
URL: https://github.com/apache/incubator-doris/issues/3170
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org