[jira] [Created] (PHOENIX-3384) Optimize RVC expressions for non leading row key columns

[James Taylor (JIRA)]

James Taylor created PHOENIX-3384:
-------------------------------------

             Summary: Optimize RVC expressions for non leading row key columns
                 Key: PHOENIX-3384
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3384
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor


See PHOENIX-3382, but we should be able to optimize the following query:
{code}
SELECT entity_id, score
FROM communities.test
WHERE organization_id = 'org1'
AND (score, entity_id) < (2, '04')
ORDER BY score DESC, entity_id DESC

CREATE TABLE COMMUNITIES.TEST (
ORGANIZATION_ID CHAR(15) NOT NULL,
SCORE DOUBLE NOT NULL,
ENTITY_ID CHAR(15) NOT NULL
CONSTRAINT TEST_PK PRIMARY KEY (
ORGANIZATION_ID,
SCORE DESC,
ENTITY_ID DESC
))
{code}



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