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/23 13:01:06 UTC
[GitHub] [incubator-doris] ShowMeYourHammar opened a new issue #3179:
current_date function cause slow query
ShowMeYourHammar opened a new issue #3179: current_date function cause slow query
URL: https://github.com/apache/incubator-doris/issues/3179
**Describe the bug**
current_date function cause slow query
**To Reproduce**
select
k,
count(case when time_1 >= date_sub(current_date(),14) and time_1 < date_sub(current_date(),7) then id else null end)
from db.table
group by k;
The sql above runs 1min
select
k,
count(case when time_1 >= '2020-03-09' and time_1 < '2020-03-16' then id else null end)
from db.table
group by k;
And this one runs 300ms
----------------------------------------------------------------
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 #3179: current_date function
cause slow query
Posted by GitBox <gi...@apache.org>.
imay closed issue #3179: current_date function cause slow query
URL: https://github.com/apache/incubator-doris/issues/3179
----------------------------------------------------------------
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