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