You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Stefan Miklosovic (Jira)" <ji...@apache.org> on 2023/12/04 15:20:00 UTC
[jira] [Comment Edited] (CASSANDRA-18796) Optionally fail when a non-partition-restricted query is issued against a storage-attached index with a backing table using LCS
[ https://issues.apache.org/jira/browse/CASSANDRA-18796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17792891#comment-17792891 ]
Stefan Miklosovic edited comment on CASSANDRA-18796 at 12/4/23 3:19 PM:
------------------------------------------------------------------------
[~adelapena] I tried to implement this but I am stuck on (1). Do you have any idea how to propagate a ClientState there?
(1) [https://github.com/apache/cassandra/pull/2961/files#diff-33dd618b19107d166661e0f5f40a04e249008468238a72d1635a6c2ed1f1cca3]
edit: It is easy to do if we give up on ClientState. In other words, this guardrail would be also effective when a super-user is executing such query. By default, a super-user is basically skipping any guardrails for now. The draft contains that too.
was (Author: smiklosovic):
[~adelapena] I tried to implement this but I am stuck on (1). Do you have any idea how to propagate a ClientState there?
(1) https://github.com/apache/cassandra/pull/2961/files#diff-33dd618b19107d166661e0f5f40a04e249008468238a72d1635a6c2ed1f1cca3
> Optionally fail when a non-partition-restricted query is issued against a storage-attached index with a backing table using LCS
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-18796
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18796
> Project: Cassandra
> Issue Type: Improvement
> Components: Feature/2i Index, Feature/SAI, Local/Compaction/LCS
> Reporter: Caleb Rackliffe
> Assignee: Stefan Miklosovic
> Priority: Normal
> Fix For: 5.0-rc, 5.x
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> With LCS, we will have potentially thousands of SSTables for a given user table. Storage-attached also means SSTable-attached, and searching thousands of attached indexes is not going to scale well at all locally, due to the sheer number of searches and amount of postings list merging involved. We should have a guardrail to prohibit this by default.
> Partition-restricted queries, the use-case SAI is broadly designed for, should be very efficient.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org