slim bouguerra created HIVE-20768:
-------------------------------------
Summary: Adding Tumbling Window UDF
Key: HIVE-20768
URL: https://issues.apache.org/jira/browse/HIVE-20768
Project: Hive
Issue Type: New Feature
Reporter: slim bouguerra
Assignee: slim bouguerra
Goal is to provide a UDF that truncates a timestamp to a beginning of a
tumbling window interval.
{code}
/**
* Tumbling windows are a series of fixed-sized, non-overlapping and contiguous
time intervals.
* Tumbling windows are inclusive start exclusive end.
* By default the beginning instant of fist window is Epoch 0 Thu Jan 01
00:00:00 1970 UTC.
* Optionally users may provide a different origin as a timestamp arg3.
*
* This an example of series of window with an interval of 5 seconds and origin
Epoch 0 Thu Jan 01 00:00:00 1970 UTC:
*
*
* interval 1 interval 2 interval 3
* Jan 01 00:00:00 Jan 01 00:00:05 Jan 01 00:00:10
* 0 -------------- 4 : 5 --------------- 9: 10 --------------- 14
*
* This UDF rounds timestamp agr1 to the beginning of window interval where it
belongs to.
*
*/
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
