Jesus Camacho Rodriguez created HIVE-14959:
----------------------------------------------

             Summary: Support distinct with windowing when CBO is 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


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)

Reply via email to