phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3773) Implement FIRST_VALUES aggregate function
Date Wed, 07 Jun 2017 19:12:18 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16041451#comment-16041451
] 

Hudson commented on PHOENIX-3773:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-master #1646 (See [https://builds.apache.org/job/Phoenix-master/1646/])
PHOENIX-3773 Support FIRST_VALUES and LAST_VALUES aggregate function to (jamestaylor: rev
9095b3ec87aef45138d62e5bbffdafee3e934d38)
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/FirstLastValueBaseClientAggregator.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/expression/function/LastValuesFunction.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/LastValuesFunctionIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/aggregator/FirstLastValueServerAggregator.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/expression/function/FirstValuesFunction.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/parse/LastValuesAggregateParseNode.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/function/LastValueFunction.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/parse/FirstValuesAggregateParseNode.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/FirstValuesFunctionIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/FirstLastNthValueDataContainer.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/function/NthValueFunction.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/function/FirstValueFunction.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/ExpressionType.java


> Implement FIRST_VALUES aggregate function
> -----------------------------------------
>
>                 Key: PHOENIX-3773
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3773
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: James Taylor
>            Assignee: Loknath Priyatham Teja Singamsetty 
>              Labels: SFDC
>             Fix For: 4.11.0
>
>         Attachments: PHOENIX-3773_4.x-HBase-0.98.patch, PHOENIX-3773_4.x-HBase-0.98_v2.patch,
PHOENIX-3773_4.x-HBase-1.1_v2.patch, PHOENIX-3773_4.x-HBase-1.2_v2.patch, PHOENIX-3773_master.patch,
PHOENIX-3773_master_v2.patch, PHOENIX-3773.patch, PHOENIX-3773.v2.patch, PHOENIX-3773.v3.patch
>
>
> Similar to FIRST_VALUE, but would allow the user to specify how many values to keep.
This could use a MinMaxPriorityQueue under the covers and be much more efficient than using
multiple NTH_VALUE calls to do the same like this:
> {code}
> SELECT entity_id,
>        NTH_VALUE(user_id,1) WITHIN GROUP (ORDER BY last_read_date DESC) as nth1_user_id,
>        NTH_VALUE(user_id,2) WITHIN GROUP (ORDER BY last_read_date DESC) as nth2_user_id,
>        NTH_VALUE(user_id,3) WITHIN GROUP (ORDER BY last_read_date DESC) as nth3_user_id,
>        count(*)
> FROM  MY_TABLE 
> WHERE tenant_id='00Dx0000000XXXX'
> AND entity_id in ('0D5x000000ABCD','0D5x000000ABCE')
> GROUP BY entity_id;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message