chenglei created PHOENIX-3491:
---------------------------------
Summary: OrderBy should be compiled out when GroupBy is not
OrderPreserving but 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
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 2-CHUNK PARALLEL 2-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 obvious it should be compiled out as
OrderBy.REV_ROW_KEY_ORDER_BY.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
