Jesus Camacho Rodriguez created HIVE-14959:

             Summary: Support distinct with windowing when CBO is disabled
                 Key: HIVE-14959
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez

For instance, the following query with CBO off:

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;

will fail, with the following message:

SELECT DISTINCT not allowed in the presence of windowing functions when CBO is 

This message was sent by Atlassian JIRA

Reply via email to