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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
