[HIVE-20768] Adding Tumbling Window UDF

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: TODOC
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 18/Oct/18 00:02
• Updated: 17/Nov/22 08:54
• Resolved: 21/Oct/18 18:47

Description

Goal is to provide a UDF that truncates a timestamp to a beginning of a tumbling window interval.

/**
 * 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.
 *
 */