Query filter - Cassandra

Parameters

None of the parameters are required. 

The parameters that can take multiple values can be separated by commas or by newlines.

Query patterns

A list of strings or regular expressions that should match the CQL query being executed or prepared. These can be comma-separated, or separated by new lines.

Include prepared statements

If this option is selected, then requests of type Prepare (for prepared statements) will be included. 

Note that, unlike Query requests, Prepare requests do not result in the immediate execution of the CQL: that is done only by an Execute request.

Client IPs

A list of IP addresses (IP4 and/or IP6) and/or regular expressions for IP addresses.

Example: 

12.34.56.78
1234:5678:90ab::01
regex:98\.76\..*
regex:9876:5432:.*

Users

A list of user names and/or regular expressions for user names. If specified, only queries executed by these users will cause execution of the filter.

Example: rewrite a query

A common use of this filter is to tweak one or more specific queries to affect how a Cassandra client behaves, without having to change the client's code.

In this example, the client sends a query that turns out to be inefficient, so we catch the request before it gets to the server and modify the query.

Query patterns: select * from acct.Orders where dept = ?

Include prepared statements: checked

Users: regex: es_.*

The code might look like:

log.info("Tweaking query");
context.packet.query = "select * from acct.Orders where dept = ? limit 100;