Hi Radha,
This is in my opinion a bug on the stress tool. Static columns are not
supported on COMPACT tables.
Do not hesitate to open a JIRA ticket for that.
Nevertheless be aware that COMPACT STORAGE is deprecated and support for it
should be removed in the 5.0 release.
Le mer. 16 juin 2021 à 16:13, Radha Wadhera <wadherara...@gmail.com> a
écrit :
> Hi,
>
> I have Cassandra 3.11 installed on my setup.* I used the Cassandra-stress
> tool to create data for my cluster.*
>
>
> *# cassandra-stress write n=800 -log file=/tmp/1 level=verbose -mode native
> cql3 user=cassandra password=cassandra -node nodeip*
> I saw that two tables were created "counter1 and standard1".
> *The "counter1" table had no data and also was created with the following
> configuration:*
>
> CREATE TABLE keyspace1.counter1 (
>
> key blob,
>
> column1 text,
>
> *"C0" counter static,*
>
> * "C1" counter static,*
>
> * "C2" counter static,*
>
> * "C3" counter static,*
>
> * "C4" counter static*,
>
> value counter,
>
> PRIMARY KEY (key, column1)
>
> ) *WITH COMPACT STORAGE*
>
> AND CLUSTERING ORDER BY (column1 ASC)
>
> AND bloom_filter_fp_chance = 0.01
>
> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
>
> AND comment = ''
>
> AND compaction = {'class':
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
> 'max_threshold': '32', 'min_threshold': '4'}
>
> AND compression = {'enabled': 'false'}
>
> AND crc_check_chance = 1.0
>
> AND dclocal_read_repair_chance = 0.1
>
> AND default_time_to_live = 0
>
> AND gc_grace_seconds = 864000
>
> AND max_index_interval = 2048
>
> AND memtable_flush_period_in_ms = 0
>
> AND min_index_interval = 128
>
> AND read_repair_chance = 0.0
>
> AND speculative_retry = '99PERCENTILE';
>
>
>
>
> *Now if I try to create a similar schema manually with above-mentioned
> schema, I get the following error. *InvalidRequest: Error from server:
> code=2200 [Invalid query] message="*Static columns are not supported in
> COMPACT STORAGE tables*"
>
>
>
> I further read more about this error and found that *static columns cannot
> be used with COMPACT STORAGE tables*.
> Here is the documentation for the same :
>
> 1.
>
> https://docs.datastax.com/en/cql-oss/3.3/cql/cql_using/useCompactStorage.html
> 2. https://programmersought.com/article/81431553936/
>
>
> *If the above configuration is not supported schema then can you please let
> me know how the "Cassandra-stress" tool is able to create a table with not
> supported schema configuration?*
>
> *Any help will be much appreciated.*
>
> Regards
> Radha Wadhera
>
