[
https://issues.apache.org/jira/browse/HIVE-7744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Harish Butani updated HIVE-7744:
--------------------------------
Attachment: HIVE-7744.1.patch
> In Windowing Streaming mode Avg and Sum give incorrect results when Wdw size
> is same as partition size
> ------------------------------------------------------------------------------------------------------
>
> Key: HIVE-7744
> URL: https://issues.apache.org/jira/browse/HIVE-7744
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Harish Butani
> Assignee: Harish Butani
> Attachments: HIVE-7744.1.patch
>
>
> For e.g. following query:
> {code}
> select p_retailprice, avg(p_retailprice) over (partition by p_mfgr order by
> p_name rows between current row and 6 following),
> sum(p_retailprice) over (partition by p_mfgr order by p_name rows between
> current row and 6 following)
> from part
> where p_mfgr='Manufacturer#1'
> {code}
> returns
> {code}
> 1173.15 1458.2883333333336 8749.730000000001
> 1173.15 1458.2883333333336 8749.730000000001
> 1753.76 1458.2883333333336 8749.730000000001
> 1602.59 1458.2883333333336 8749.730000000001
> 1414.42 1458.2883333333336 8749.730000000001
> 1632.66 1458.2883333333336 8749.730000000001
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
