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] [Updated] (HIVE-10555) Windowing function to support additional ranges
Date Thu, 07 May 2015 15:00:01 GMT

     [ https://issues.apache.org/jira/browse/HIVE-10555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aihua Xu updated HIVE-10555:
----------------------------
    Description: 
Currently windowing function only supports the formats of {{x preceding and current}}, {{x
preceding and y following}}, {{current and y following}}. 

Windowing of {{x preceding and y preceding}} and {{x following and y following} doesn't work
properly.


  was:
The following windowing function always returns 0 for count(*). 

{noformat}
Table t1
key  value
1       3
1       3
1       2
select key, count(*) over (partition by key order by value rows between 1 preceding and 2
preceding) from t1;
{noformat}

Seems windowing functions have some issues when dealing with preceding window.




> Windowing function to support additional ranges
> -----------------------------------------------
>
>                 Key: HIVE-10555
>                 URL: https://issues.apache.org/jira/browse/HIVE-10555
>             Project: Hive
>          Issue Type: Improvement
>          Components: PTF-Windowing
>    Affects Versions: 1.3.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>
> Currently windowing function only supports the formats of {{x preceding and current}},
{{x preceding and y following}}, {{current and y following}}. 
> Windowing of {{x preceding and y preceding}} and {{x following and y following} doesn't
work properly.



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

Mime
View raw message