[
https://issues.apache.org/jira/browse/HIVE-20768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gopal V updated HIVE-20768:
---------------------------
Resolution: Fixed
Fix Version/s: 4.0.0
Status: Resolved (was: Patch Available)
Pushed to master, thanks [~bslim]
> 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
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-20768.2.patch, HIVE-20768.3.patch,
> HIVE-20768.patch, HIVE-20768.patch
>
>
> 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)
