[ https://issues.apache.org/jira/browse/HIVE-10555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aihua Xu updated HIVE-10555: ---------------------------- Description: 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. was: The following windowing function always returns 0 for count(*). {noformat} 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 for count(*) with preceding rows doesn't work as expected > ---------------------------------------------------------------------------- > > Key: HIVE-10555 > URL: https://issues.apache.org/jira/browse/HIVE-10555 > Project: Hive > Issue Type: Bug > Components: PTF-Windowing > Affects Versions: 1.3.0 > Reporter: Aihua Xu > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)