phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Loknath Priyatham Teja Singamsetty (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-3773) Implement FIRST_VALUES aggregate function
Date Wed, 31 May 2017 04:18:04 GMT


Loknath Priyatham Teja Singamsetty  commented on PHOENIX-3773:

[~jamestaylor] [~samarthjain]

Here is what i'm doing to create patch which is working for master and 4.x branch locally.
This used to work earlier but the precommit build is failing now while applying to master.

a) checkout to 4.x-HBase-0.98
b) git commit
c) git format-patch HEAD -1

I have also tried the instructions specified in
This is resulting in patch file with lot of commits back dated from 2014 when i run "git format-patch
--stdout origin > PHOENIX-{NUMBER}.patch"

Between on debugging further from build console output, 

+ /home/jenkins/jenkins-slave/workspace/PreCommit-PHOENIX-Build/dev/ /home/jenkins/jenkins-slave/workspace/PreCommit-PHOENIX-Build/patchprocess/patch
The patch does not appear to apply with p0 to p2
+ [[ 1 != 0 ]]
+ JIRA_COMMENT='Here are the results of testing the latest attachment
  against master branch at commit e3fc929e93715a359b4267db9f4d12706247a6a6.

Would like to know the commands part of for further debugging.

> Implement FIRST_VALUES aggregate function
> -----------------------------------------
>                 Key: PHOENIX-3773
>                 URL:
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: James Taylor
>            Assignee: Loknath Priyatham Teja Singamsetty 
>              Labels: SFDC
>             Fix For: 4.11.0
>         Attachments: PHOENIX-3733.v4.patch, 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(*)
> WHERE tenant_id='00Dx0000000XXXX'
> AND entity_id in ('0D5x000000ABCD','0D5x000000ABCE')
> GROUP BY entity_id;
> {code}

This message was sent by Atlassian JIRA

View raw message