[CASSANDRA-17967] Guardrail: allow_filtering_custom_error_message

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.0-alpha1, 5.0
• Component/s: Feature/Guardrails
• Change Category: Semantic
• Complexity: Normal
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/9f99e72aae812b86d277883601450bc0e7bb9463

Test and Documentation Plan

PR	CI
trunk	j8 j11

• Assignee: Andres de la Peña
• Reporter: Sarma Pydipally

Authors

Andres de la Peña

Reviewers

Berenguer Blasi

• Created: 18/Oct/22 00:08
• Updated: 12/Sep/23 13:03
• Resolved: 18/Nov/22 13:14

Description

in Apache Cassandra Release Version 4.1 :
with "allow_filtering_enabled: false" option under guardrails :
regular users cannot run queries with allow filtering clause in SELECT commands. Users get following error message :
<stdin>:1:InvalidRequest: Error from server: code=2200 [Invalid query] message="Guardrail allow_filtering violated: Querying with ALLOW FILTERING is not allowed"

I propose for a new parameter in conf file : something like : allow_filtering_custom_error_message and allow cluster operators to configure custom message
so if someone runs a SELECT command along with "ALLOW FILTERING"
it should print ERROR : InvalidRequest:code=2202:message="STOP using allow_filtering clause"

so this will allow the operators to stop users from running allow filtering as well as give them to configure a custom error message.

Issue Links

• links to: PR trunk