hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10142) Calculating formula based on difference between each row's value and current row's in Windowing function
Date Thu, 11 Jun 2015 13:48:01 GMT

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

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

{{x preceding and y preceding}} is supported now. I'm investigating what could be still missing.
[~zhangyii] If you have sth in mind, could you please post the queries here, I can give it
a try to see if it's already supported or missing?

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

Mime
View raw message