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