Tri Nguyen created CASSANDRA-15911:
--------------------------------------
Summary: Allow partition scan, querying cluster keys out of order
Key: CASSANDRA-15911
URL: https://issues.apache.org/jira/browse/CASSANDRA-15911
Project: Cassandra
Issue Type: Improvement
Reporter: Tri Nguyen
On the following table
{code:java}
CREATE TABLE actors_by_video (
video_id TIMEUUID,
actor_name TEXT,
character_name TEXT,
PRIMARY KEY ((video_id), actor_name, character_name)
);{code}
The query
{code:java}
SELECT * FROM actors_by_video
WHERE video_id = 1234abcd-1111-2222-3333-aaaabbbbcccc
AND character_name = 'The PK Father';{code}
fails with the following error:
{color:#de350b}InvalidRequest: Error from server: code=2200 [Invalid query]
message="PRIMARY KEY column "character_name" cannot be restricted as preceding
column "actor_name" is not restricted {color}
*QUESTION:*
Let's assume this is a query which doesn't occur frequently, so it is not worth
to create a new table with the proper Primary Key. However, because the scope
of the query is limited within ONE SINGLE partition key. I am willing to accept
the performance penalty incurred for that "partition scan".
Would it be possible to allow CQL to allow this query, in a similar fastion
than "ALLOW FILTERING" ? But here, to denote a scan within a partition, maybe
can we name it "ALLOW PARTITION FILTERING" ?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
