hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-10555) Windowing function for count(*) with preceding rows doesn't work as expected
Date Thu, 30 Apr 2015 15:28:06 GMT
Aihua Xu created HIVE-10555:
-------------------------------

             Summary: 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}
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)

Mime
View raw message