[GitHub] [incubator-doris] emerkfu commented on pull request #8299: [feature] Window funnel

[GitBox <gi...@apache.org>]

emerkfu commented on PR #8299:
URL: https://github.com/apache/incubator-doris/pull/8299#issuecomment-1120173732

   
   
   
   > > Can timestamp be in milliseconds? If the timestamp is in seconds, events that occur in the same second but different milliseconds may be miscalculated. ClickHouse's windoFunnel has such a problem.
   > 
   > could you give more details about the scene that supporting milliseconds are valuable
   
   For example, using windowFunnel to calculate a window funnel of ordered events, if two events occur in the same second in sequence, and timestamps are calculated in seconds, then the sequence of the two events may be considered to occur simultaneously because there is no millisecond precision, Eventually, the calculated results are inconsistent with the actual results.
   
   Assume event_a -> event_b -> event_c is a valid funnel sequence.
   
   event_a, 2022-05-07 10:41:00.123;
   event_b, 2022-05-07 10:41:00.234;
   event_c, 2022-05-07 10:41:01.345;
   
   This set of events is valid if timestamps are in milliseconds.
   
   If the data timestamp ignores milliseconds, then the data becomes the following：
   
   event_a, 2022-05-07 10:41:00;
   event_b, 2022-05-07 10:41:00;
   event_c, 2022-05-07 10:41:01;
   
   The order of events might be thought of as event_b -> event_a -> event_c and the result is different from the truth.
   
   
   
   
   


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org