hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dudu Markovitz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7660) Hive to support qualify analytic filtering
Date Sat, 30 Jul 2016 06:33:20 GMT

    [ 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)

Mime
View raw message