[
https://issues.apache.org/jira/browse/HIVE-10142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592377#comment-14592377
]
Yi Zhang commented on HIVE-10142:
---------------------------------
This request is more in the line as following decay variable definition:
Exponential rate of change can be modeled algebraically by the following
formula:
N(t)=N(0)e^(−λt)
where N is the quantity, N0 is the initial quantity, λ is the decay constant,
and t is time.
And the window function will be a summary of the value of all records in the
window relative to the current record.
> 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)
