[
https://issues.apache.org/jira/browse/PHOENIX-3777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15970537#comment-15970537
]
Hadoop QA commented on PHOENIX-3777:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12863597/PHOENIX-3777.patch
against master branch at commit adf5606835f954a4e6b62d2fde8777b15cfec434.
ATTACHMENT ID: 12863597
{color:green}+1 @author{color}. The patch does not contain any @author
tags.
{color:green}+0 tests included{color}. The patch appears to be a
documentation, build,
or dev patch that doesn't require tests.
{color:green}+1 javac{color}. The applied patch does not increase the
total number of javac compiler warnings.
{color:red}-1 javadoc{color}. The javadoc tool appears to have generated
47 warning messages.
{color:green}+1 release audit{color}. The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 lineLengths{color}. The patch does not introduce lines
longer than 100
{color:green}+1 core tests{color}. The patch passed unit tests in .
Test results:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/831//testReport/
Javadoc warnings:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/831//artifact/patchprocess/patchJavadocWarnings.txt
Console output:
https://builds.apache.org/job/PreCommit-PHOENIX-Build/831//console
This message is automatically generated.
> NTH_VALUE() function with multiple where clause filters on primary key
> components with GROUP BY is returning results for first grouped set and not
> for all grouped sets
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3777
> URL: https://issues.apache.org/jira/browse/PHOENIX-3777
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Reporter: Loknath Priyatham Teja Singamsetty
> Assignee: Loknath Priyatham Teja Singamsetty
> Fix For: 4.11.0, 4.10.1
>
> Attachments: PHOENIX-3777.patch
>
>
> Here is the reproducible case. The following query is failing:
> 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 TEST.TEST
> WHERE id='00Dx000000091CU'
> AND entity_id in ('0D5x0000006ARCN','0D5x0000006AQrO')
> GROUP BY entity_id;
> Current Output:
> ============
> +-----------------+-----------------+-----------------+-----------------+-------+
> | ENTITY_ID | NTH1_USER_ID | NTH2_USER_ID | NTH3_USER_ID | COUNT |
> +-----------------+-----------------+-----------------+-----------------+-------+
> | 0D5x0000006AQrO | 005x0000000ZSX0 | 005x0000000ZSWz| 005x0000000ZSWy | 50
> |
> | 0D5x0000006ARCN | 005x0000000ZSX0 | |
>
> | 50 |
> +-----------------+-----------------+-----------------+-----------------+-------+
> Expected Output:
> ==============
> +-----------------+-----------------+-----------------+-----------------+-------+
> | ENTITY_ID | NTH1_USER_ID | NTH2_USER_ID | NTH3_USER_ID | COUNT |
> +-----------------+-----------------+-----------------+-----------------+-------+
> | 0D5x0000006AQrO | 005x0000000ZSX0 | 005x0000000ZSWz| 005x0000000ZSWy | 50
> |
> | 0D5x0000006ARCN | 005x0000000ZSX0 | 005x0000000ZSWy| 005x0000000ZSWy | 50
> |
> +-----------------+-----------------+-----------------+-----------------+-------+
> QUERY PLAN:
> ============
> CLIENT 1-CHUNK 0 ROWS 0 BYTES PARALLEL 1-WAY SKIP SCAN ON 2 KEYS OVER
> FEEDS.FEED_ENTITY_READ ['00Dx000000091CU','0D5x0000006AQrO'] -
> ['00Dx000000091CU','0D5x0000006ARCN’]
> SERVER AGGREGATE INTO ORDERED DISTINCT ROWS BY [FEED_ENTITY_ID]
> Schema:
> CREATE TABLE IF NOT EXISTS TEST.TEST
> ( ID CHAR(15) NOT NULL,
> ENTITY_ID CHAR(15) NOT NULL,
> USER_ID CHAR(15) NOT NULL,
> LAST_READ_DATE TIMESTAMP NULL,
> ENTITY_READ_ID CHAR(15)
> CONSTRAINT PKVIEW PRIMARY KEY ( ID, ENTITY_ID, USER_ID )
> ) VERSIONS=1,MULTI_TENANT=TRUE,REPLICATION_SCOPE=1
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
