[jira] [Commented] (HIVE-10142) Calculating formula based on difference between each row's value and current row's in Windowing function

["Aihua Xu (JIRA)" <ji...@apache.org>]

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

Aihua Xu commented on HIVE-10142:
---------------------------------

Value based windowing is supported in some sense, such as {{select key, value, sum(value) over (partition by key order by value range between 2 preceding and 2 following ) from small;}}, but not fully supported, like other window spec {{x preceding and y preceding}}. I will use this jira to cover missing features. HIVE-10585 will correct the behavior for string data type.

> Calculating formula based on difference between each row's value and current row's in Windowing function
> --------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-10142
>                 URL: https://issues.apache.org/jira/browse/HIVE-10142
>             Project: Hive
>          Issue Type: New Feature
>          Components: PTF-Windowing
>    Affects Versions: 1.0.0
>            Reporter: Yi Zhang
>            Assignee: Aihua Xu
>
> For analytics with windowing function, the calculation formula sometimes needs to perform over each row's value against current tow's value. The decay value is a good example, such as sums of value with a decay function based on difference of timestamp between each row and current row.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)