[
https://issues.apache.org/jira/browse/HIVE-13242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197879#comment-15197879
]
Ashutosh Chauhan commented on HIVE-13242:
-----------------------------------------
Can you also add a negative test cases for:
{code}
select count(distinct last_value(i) over ( partition by si order by i )) from
over10k;
select distinct last_value(i) over ( partition by si order by i ), distinct
first_value(t) over ( partition by si order by i ) from over10k ;
{code}
and positive test for:
{code}
select distinct last_value(i) over ( partition by si order by i ),
first_value(t) over ( partition by si order by i ) from over10k ;
{code}
> DISTINCT keyword is dropped by the parser for windowing
> -------------------------------------------------------
>
> Key: HIVE-13242
> URL: https://issues.apache.org/jira/browse/HIVE-13242
> Project: Hive
> Issue Type: Bug
> Affects Versions: 2.1.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-13242.patch
>
>
> To reproduce, the following query can be used:
> {noformat}
> select distinct first_value(t) over ( partition by si order by i, b ) from
> over10k limit 100;
> {noformat}
> The distinct keyword is ignored and duplicates are produced.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
