[ 
https://issues.apache.org/jira/browse/HIVE-20768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16655364#comment-16655364
 ] 

Hive QA commented on HIVE-20768:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12944450/HIVE-20768.patch

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 15097 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[show_functions] 
(batchId=79)
org.apache.hadoop.hive.ql.exec.spark.TestSparkSessionTimeout.testMultiSessionSparkSessionTimeout
 (batchId=249)
{noformat}

Test results: 
https://builds.apache.org/job/PreCommit-HIVE-Build/14545/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14545/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14545/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 2 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12944450 - PreCommit-HIVE-Build

> 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
>         Attachments: 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)

Reply via email to