[ https://issues.apache.org/jira/browse/HIVE-14959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-14959: ------------------------------------------- Resolution: Fixed Fix Version/s: 2.1.1 2.2.0 Status: Resolved (was: Patch Available) Pushed to master, branch-2.1. Thanks [~ashutoshc] for the review! > Fix DISTINCT with windowing when CBO is enabled/disabled > -------------------------------------------------------- > > Key: HIVE-14959 > URL: https://issues.apache.org/jira/browse/HIVE-14959 > Project: Hive > Issue Type: Bug > Affects Versions: 2.1.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Fix For: 2.2.0, 2.1.1 > > Attachments: HIVE-14959.01.patch, HIVE-14959.patch > > > For instance, the following query with CBO off: > {code:sql} > select distinct last_value(i) over ( partition by si order by i ), > first_value(t) over ( partition by si order by i ) > from over10k limit 50; > {code} > will fail, with the following message: > {noformat} > SELECT DISTINCT not allowed in the presence of windowing functions when CBO > is off > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)