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)