Re: Denylisting with a composite partition key

2022-10-25 Thread Cheng Wang via user
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

Re: Denylisting with a composite partition key

2022-10-25 Thread Cheng Wang via user
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

Re: Denylisting with a composite partition key

2022-10-20 Thread Cheng Wang via user
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

Re: Denylisting with a composite partition key

2022-10-19 Thread Cheng Wang via user
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

Re: Denylisting with a composite partition key

2022-10-17 Thread Cheng Wang via user
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>

Re: Denylisting with a composite partition key

2022-10-17 Thread Cheng Wang via user
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