You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Aihua Xu (JIRA)" <ji...@apache.org> on 2015/04/30 17:35:06 UTC
[jira] [Updated] (HIVE-10555) Windowing function for count(*) with
preceding rows doesn't work as expected
[ 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)