xinghuayu007 opened a new issue #5443:
URL: https://github.com/apache/incubator-doris/issues/5443
**Is your feature request related to a problem? Please describe.**
from_unxitime is a cpu-exhausted function. SQL: `select filed from table
where from_unixtime(field) > '2021-03-02'`, if there are one million rows of
data. Function from_unixtime will be called one million times, which will make
query very slow.
**Describe the solution you'd like**
SQL: `select filed from table where from_unixtime(field) > '2021-03-02'`,
we can rewrite this sql into `select filed from table where field >
1614614400`;
that means we only need to transfer '2021-03-02' into timestamp, and compare
field with this timestamp, it is no need to call function from_unixtime.
**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features
you've considered.
**Additional context**
Add any other context or screenshots about the feature request here.
----------------------------------------------------------------
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
