Tanuj Khurana created PHOENIX-7694:
--------------------------------------
Summary: Key explosion when a descending sort order column is part
of a composite PK
Key: PHOENIX-7694
URL: https://issues.apache.org/jira/browse/PHOENIX-7694
Project: Phoenix
Issue Type: Improvement
Affects Versions: 5.2.1, 5.2.0, 5.3.0
Reporter: Tanuj Khurana
Using a PK column with DESC sort order causes a combinatorial explosion of keys
generated when using skip scan.
{code:java}
CREATE TABLE IF NOT EXISTS FOO (ID CHAR(15) NOT NULL, CREATED_DATE DATE NOT
NULL, ENTITY_ID CHAR(15) NOT NULL, CREATED_BY VARCHAR, DATA VARCHAR CONSTRAINT
PK PRIMARY KEY (ID, CREATED_DATE DESC, ENTITY_ID)) {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
