phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3491) OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse
Date Sat, 19 Nov 2016 01:36:58 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15678332#comment-15678332
] 

Hudson commented on PHOENIX-3491:
---------------------------------

SUCCESS: Integrated in Jenkins build Phoenix-master #1507 (See [https://builds.apache.org/job/Phoenix-master/1507/])
PHOENIX-3491 OrderBy can not be compiled out if GroupBy is not (jamestaylor: rev 9109026240ef0a0ece534f0b625a34c49be44568)
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/OrderByIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/compile/OrderPreservingTracker.java
* (edit) phoenix-core/src/test/java/org/apache/phoenix/compile/QueryCompilerTest.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/execute/AggregatePlan.java


> OrderBy can not be compiled out if GroupBy is not orderPreserving and OrderBy is reverse
> ----------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3491
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3491
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.8.0
>            Reporter: chenglei
>            Assignee: chenglei
>         Attachments: PHOENIX-3491_v1.patch, PHOENIX-3491_v2.patch
>
>
> for the following table:
> {code:borderStyle=solid}
>             CREATE TABLE ORDERBY_TEST ( 
>                     ORGANIZATION_ID INTEGER NOT NULL,
>                     CONTAINER_ID INTEGER NOT NULL,
>                     SCORE INTEGER NOT NULL,
>                     ENTITY_ID INTEGER NOT NULL,     
>                    CONSTRAINT TEST_PK PRIMARY KEY ( 
>                     ORGANIZATION_ID,
>                     CONTAINER_ID,
>                     SCORE,
>                     ENTITY_ID
>                     ));
>  {code}           
>           
> If we execute explain on the following sql: 
> {code:borderStyle=solid}           
>     SELECT ORGANIZATION_ID,SCORE FROM ORDERBY_TEST  GROUP BY ORGANIZATION_ID, SCORE ORDER
BY ORGANIZATION_ID DESC, SCORE DESC         
> {code}
> the result is :
> {code:borderStyle=solid} 
>     ----------------------------------------------------------------------+
> |                                 PLAN                                 |
> +----------------------------------------------------------------------+
> | CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER ORDERBY_TEST        |
> |     SERVER FILTER BY FIRST KEY ONLY                                  |
> |     SERVER AGGREGATE INTO DISTINCT ROWS BY [ORGANIZATION_ID, SCORE]  |
> | CLIENT MERGE SORT                                                    |
> | CLIENT SORTED BY [ORGANIZATION_ID DESC, SCORE DESC]                  |
> +----------------------------------------------------------------------+
> {code} 
> from the above explain result, we can see that the ORDER BY ORGANIZATION_ID DESC, SCORE
DESC is not  compiled out,but obviously it should be compiled out  as OrderBy.REV_ROW_KEY_ORDER_BY.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message