[
https://issues.apache.org/jira/browse/HIVE-10702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14558571#comment-14558571
]
Ashutosh Chauhan commented on HIVE-10702:
-----------------------------------------
+1
> COUNT(*) over windowing 'x preceding and y preceding' doesn't work properly
> ---------------------------------------------------------------------------
>
> Key: HIVE-10702
> URL: https://issues.apache.org/jira/browse/HIVE-10702
> Project: Hive
> Issue Type: Sub-task
> Components: PTF-Windowing
> Reporter: Aihua Xu
> Assignee: Aihua Xu
> Attachments: HIVE-10702.patch
>
>
> Given the following query:
> {noformat}
> select ts, f, count(*) over (partition by ts order by f rows between 2
> preceding and 1 preceding) from over10k limit 100;
> {noformat}
> It returns the result
> {noformat}
> 2013-03-01 09:11:58.70307 3.17 0
> 2013-03-01 09:11:58.70307 10.89 0
> 2013-03-01 09:11:58.70307 14.54 1
> 2013-03-01 09:11:58.70307 14.78 1
> 2013-03-01 09:11:58.70307 17.85 1
> 2013-03-01 09:11:58.70307 20.61 1
> 2013-03-01 09:11:58.70307 28.69 1
> 2013-03-01 09:11:58.70307 29.22 1
> 2013-03-01 09:11:58.70307 31.17 1
> 2013-03-01 09:11:58.70307 38.35 1
> 2013-03-01 09:11:58.70307 38.61 1
> {noformat}
> Mostly it should return count 2 rather than 1.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
