hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20768) Adding Tumbling Window UDF
Date Sun, 21 Oct 2018 18:48:00 GMT

     [ 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)

Mime
View raw message