[NIFI-4493] PutCassandraQL Option to Disable Prepared Statements

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Extensions
• Labels: cassandra putcassandraql
• Assignee: Sandish Kumar HN
• Reporter: Ben Thorner
• Created: 17/Oct/17 15:19
• Updated: 04/Mar/19 21:49

Description

Cassandra complains when using this processor to perform large numbers of changing queries. In our scenario, we are using batch statements to insert incoming data.

INFO  [ScheduledTasks:1] 2017-10-17 16:13:35,213 QueryProcessor.java:134 - 3849 prepared statements discarded in the last minute because cache limit reached (66453504 bytes)

In this scenario, I don't think it's feasible to use prepared statements, as the number of ? parameters is impractical. Could we instead have an option to disable prepared statements?