[ https://issues.apache.org/jira/browse/PHOENIX-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16021416#comment-16021416 ]
Hadoop QA commented on PHOENIX-3773: ------------------------------------ {color:red}-1 overall{color}. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12869486/PHOENIX-3773.v2.patch against master branch at commit e27fae93191d9540574765065900a23bda90905f. ATTACHMENT ID: 12869486 {color:green}+1 @author{color}. The patch does not contain any @author tags. {color:red}-1 tests included{color}. The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. {color:red}-1 patch{color}. The patch command could not apply the patch. Console output: https://builds.apache.org/job/PreCommit-PHOENIX-Build/891//console This message is automatically generated. > 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.patch, PHOENIX-3773.v2.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)