[
https://issues.apache.org/jira/browse/HIVE-7660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15400494#comment-15400494
]
Dudu Markovitz commented on HIVE-7660:
--------------------------------------
This is a syntactic sugar supported by Teradata.
e.g.
In order to get the last 3 records of each buyer:
select * from purchase qualify row_number () over (partition by buyer order by
ts desc) <= 3;
without the "qualify" it would look something like:
select * from (select *,row_number () over (partition by buyer order by ts
desc) as rn from purchase) as t where t.rn <= 3;
> Hive to support qualify analytic filtering
> ------------------------------------------
>
> Key: HIVE-7660
> URL: https://issues.apache.org/jira/browse/HIVE-7660
> Project: Hive
> Issue Type: New Feature
> Reporter: Viji
> Priority: Trivial
>
> Currently, Hive does not support qualify analytic filtering. It would be
> useful fi this feature were added in the future.
> As a workaround, since it is just a filter, we can replace it with a subquery
> and filter.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
