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)
