[ https://issues.apache.org/jira/browse/PHOENIX-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16039154#comment-16039154 ]
Thomas D'Silva commented on PHOENIX-3773: ----------------------------------------- I think the pre commit build always applies a patch to master. > 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_final.patch, > PHOENIX-3773_4.x-HBase-0.98.patch, PHOENIX-3773_master_final.patch, > PHOENIX-3773_master.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)