Skip to content

Instantly share code, notes, and snippets.

@smiklosovic
Last active October 17, 2025 16:36
Show Gist options
  • Select an option

  • Save smiklosovic/d20972e0b6846eb181ac95e2282814d4 to your computer and use it in GitHub Desktop.

Select an option

Save smiklosovic/d20972e0b6846eb181ac95e2282814d4 to your computer and use it in GitHub Desktop.
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:16 $ ./bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042
[cqlsh 6.3.0 | Cassandra 5.1-SNAPSHOT | CQL spec 3.4.8 | Native protocol v5]
Use HELP for help.
cassandra@cqlsh> CREATE KEYSPACE ks WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
cassandra@cqlsh> CREATE TABLE ks.tb (id int primary key, val text) WITH compression = {'class': 'ZstdDictionaryCompressor'};
cassandra@cqlsh> INSERT INTO ks.tb (id , val ) VALUES ( 1, 'abcd');
cassandra@cqlsh> exit
.✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:29 $ ./bin/nodetool disableautocompaction
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:29 $ ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:29 $ ./bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042
[cqlsh 6.3.0 | Cassandra 5.1-SNAPSHOT | CQL spec 3.4.8 | Native protocol v5]
Use HELP for help.
cassandra@cqlsh> INSERT INTO ks.tb (id , val ) VALUES ( 2, 'abcd');
cassandra@cqlsh> exit
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042
[cqlsh 6.3.0 | Cassandra 5.1-SNAPSHOT | CQL spec 3.4.8 | Native protocol v5]
Use HELP for help.
cassandra@cqlsh> INSERT INTO ks.tb (id , val ) VALUES ( 3, 'abcd');
cassandra@cqlsh> exit
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/cqlsh
Connected to Test Cluster at 127.0.0.1:9042
[cqlsh 6.3.0 | Cassandra 5.1-SNAPSHOT | CQL spec 3.4.8 | Native protocol v5]
Use HELP for help.
cassandra@cqlsh> exit
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/cqlsh -e 'INSERT INTO ks.tb (id , val ) VALUES ( 4, 'abcd');'; ./bin/nodetool flush
<stdin>:1:SyntaxException: line 1:42 rule insertValue failed predicate: {isParsingTxn}? (... ) VALUES ( 4, [abcd]);)
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ^C
✘-INT ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:30 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 4, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 5, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 6, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 7, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 8, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/nodetool traincompressiondictionary ks tb
Starting compression dictionary training for ks.tb...
Training from existing SSTables (flushing first if needed)
Sampling from existing SSTables and training.
Status: FAILED | Samples: 8 | Size: 0.00 MiB | Elapsed: 1s0s
Training failed for ks.tb
Reason: Insufficient samples for training: 8 (minimum required: 10)
✘-1 ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 9, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/nodetool traincompressiondictionary ks tb
Starting compression dictionary training for ks.tb...
Training from existing SSTables (flushing first if needed)
Sampling from existing SSTables and training.
Status: FAILED | Samples: 9 | Size: 0.00 MiB | Elapsed: 0s
Training failed for ks.tb
Reason: Insufficient samples for training: 9 (minimum required: 10)
✘-1 ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 10, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/nodetool traincompressiondictionary ks tb
Starting compression dictionary training for ks.tb...
Training from existing SSTables (flushing first if needed)
Sampling from existing SSTables and training.
Status: FAILED | Samples: 10 | Size: 0.00 MiB | Elapsed: 1s0s
Training failed for ks.tb
Reason: Failed to train Zstd dictionary: nb of samples too low
✘-1 ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
✘-1 ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:31 $ ./bin/cqlsh -e "INSERT INTO ks.tb (id , val ) VALUES ( 11, 'abcd');"; ./bin/nodetool flush
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:35 $ ls -la data/data/ks/tb-1b255f4def2540a60000000000000005/pa-*-Data.db | wc -l
11
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
18:35 $ ./bin/nodetool traincompressiondictionary ks tb
Starting compression dictionary training for ks.tb...
Training from existing SSTables (flushing first if needed)
Sampling from existing SSTables and training.
Status: COMPLETED | Samples: 11 | Size: 0.00 MiB | Elapsed: 1s
Training completed successfully for ks.tb
✔ ~/dev/cassandra/cassandra-instaclustr/cassandra [CASSANDRA-17021-yifan L|✚ 1⚑ 172]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment