[ https://issues.apache.org/jira/browse/HIVE-12574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Shelukhin updated HIVE-12574: ------------------------------------ Fix Version/s: (was: 2.0.0) (was: 1.3.0) Removing the fixed version from an uncommitted JIRA while unassigning the JIRAs from 2.0 release. Please set Target Version, if needed. > windowing function returns incorrect result when the window size is larger > than the partition size > -------------------------------------------------------------------------------------------------- > > Key: HIVE-12574 > URL: https://issues.apache.org/jira/browse/HIVE-12574 > Project: Hive > Issue Type: Sub-task > Components: PTF-Windowing > Affects Versions: 2.0.0 > Reporter: Aihua Xu > Assignee: Aihua Xu > Attachments: HIVE-12574.patch > > > In PTF windowing, when the partition is small and the window size is larger > than the partition size, we are seeing incorrect result. It happens for max, > min, first_value, last_value and sum functions. > {noformat} > CREATE TABLE sdy1( > ord int, > type string); > {noformat} > The data is: > {noformat} > 2 a > 3 a > 1 a > {noformat} > The result is as follows for the query {{select ord, min(ord) over (partition > by type order by ord rows between 1 preceding and 7 following)}} > {noformat} > 1 1 > 2 1 > 3 1 > {noformat} > The expected result is: > {noformat} > 1 1 > 2 1 > 3 2 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)