Sstableloader options on cassandra 3.11.9
Hi Cassandra Dev team, I was using Cassandra's bulk loading tool on a simple auth based setup. I found out that we need to pass *"-u and -pw" *parameters on Auth enabled Casandra setup. If I use the command using these parameters then if someone (any user with login access to Cassandra host machine) does *"ps -ef | grep -v grep | grep -E 'sstableloader'" *on Cassandra host machine other then Cassandra admin, then that user can see creds of the Cassandra user in plain text. I saw a similar issue while using the cqlsh and nodetool utility but there I found *"--cqlshrc and -pwf" *options where we can pass ACL based file and creds are not directly visible in ps command. *I am not able to find any such option with the Sstableloader utility. Can you suggest to me anyway by which I can pass Cassandra creds and those are not visible over the ps command? I am looking for a solution on Cassandra 3.11.9 or 3.x in general.* Regards Radha Wadhera
Regarding static column added in compact tables through Cassandra-stress tool
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
Re: Regarding static column added in compact tables through Cassandra-stress tool
Thanks Benjamin.
I have raise JIRA ticket :
https://issues.apache.org/jira/browse/CASSANDRA-16751
On 2021/06/17 08:42:36, Benjamin Lerer wrote:
> 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 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
> >
>
-
To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org
For additional commands, e-mail: dev-h...@cassandra.apache.org
