zhengshengjun commented on issue #9711:
URL:
https://github.com/apache/incubator-doris/issues/9711#issuecomment-1134113894
@BiteTheDDDDt
Thanks for pointing out this mistake, I'd thought the second parameter was
something like "time shift".
So the above cases are all right. And I looked though the code, there is a
trivial error in Hour case.
SQL: `select hour_ceil('1970-01-01 01:01:10', 1, '1970-01-01 00:01:10')
from test.flink_doris_sink limit 1`
Apache Druid's result: 1970-01-01 01:01:10
Apache Doris's result: 1970-01-01 02:01:10
the query means time are divided into pieces by hour started from
`1970-01-01 00:01:10`
( `1970-01-01 00:01:10`, `1970-01-01 01:01:10`, `1970-01-01 02:01:10`)
and 1970-01-01 01:01:10 belongs to [`1970-01-01 01:01:10`, `1970-01-01
02:01:10`], its rounded ceil will be 1970-01-01 01:01:10
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
