and yes, you need to set the consistency level to ONE in the cassandra.yaml
if it's running in your local machine
denylist_consistency_level: ONE
On Tue, Oct 25, 2022 at 10:41 AM Cheng Wang wrote:
> Awesome! That's great to hear!
> Pls feel free to let me know if you have any questions!
>
> Th
Awesome! That's great to hear!
Pls feel free to let me know if you have any questions!
Thanks,
Cheng
On Tue, Oct 25, 2022 at 10:36 AM Aaron Ploetz wrote:
> Works!
>
> So I was running on my *local*, and all of my attempts to add to the
> denylist were failing because the denylist_consistency_le
Hi Aaron,
After reading through the code, I finally figured out the issue. So back to
your original question where you failed to run
$>run denylistKey stackoverflow weather_sensor_data "'Minneapolis,
MN',202210"
#IllegalArgumentException: Operation denylistKey with 4 parameters doesn't
exist in be
Hi Aaron,
Sorry for the late reply, was dealing with a production issue (maybe
another topic for Cassandra Summit :-)). Are you running on your local
machine? Then yes, you do need to enable the config for all the following
enable_partition_denylist: true
enable_denylist_writes: true
enable_deny
Another approach is, instead of using $$, you can put additional pair of
single quote around the 'Minneapolis, MN'
cqlsh> insert into system_distributed.partition_denylist (ks_name,
table_name, key) values ('stackoverflow', 'weather_sensor_data',
textAsBlob('''Minneapolis, MN'', 202210'));
cqlsh>
Hi Aaron,
Yes, you can directly insert into the system_distributed.partition_denylist
instead of using JMX. Jordan wrote a blog post for denylist
https://cassandra.apache.org/_/blog/Apache-Cassandra-4.1-Denylisting-Partitions.html
And the syntax error, one way around is to put $$ around like belo