Your partition key is foreignid. You may have a large partition. Why not use
foreignid+timebucket as partition key?
From: learner dba
Date: 2018-07-19 01:48
To: User cassandra.apache.org
Subject: Timeout for only one keyspace in cluster
Hi,
We have a cluster with multiple keyspaces. All queries
Hi,
We have a cluster with multiple keyspaces. All queries are performing good but
write operation on few tables in one specific keyspace gets write timeout.
Table has counter column and counter update query times out always. Any idea?
CREATE TABLE x.y (
foreignid uuid,
timebucket text
Hi Cassandra/Spark experts:
I am working with on a project to save Spark dataframe to cassandra and am
getting an exception regarding row size not valid (see below). I tried to trace
the code in the connector and it appears that the row size (3 below) is
different from the column count (which tu
Chris,
Thank you for mbean reference.
On Wed, Jul 18, 2018 at 6:26 PM, Riccardo Ferrari
wrote:
> Alain, thank you for email. I really really appreciate it!
>
> I am actually trying to remove the disk io from the suspect list, thus I'm
> want to reduce the number of concurrent compactors. I'll g
Alain, thank you for email. I really really appreciate it!
I am actually trying to remove the disk io from the suspect list, thus I'm
want to reduce the number of concurrent compactors. I'll give thorughput a
shot.
No, I don't have a long list of pending compactions, however my instances
are still
YgaByte!!! <— another Cassandra “compliant" DB - not sure if they forked C*
or wrote Cassandra in go. ;)
https://github.com/YugaByte/yugabyte-db
Datastax is Cassandra compliant — and can use the same sstables at least until
6.0 (which uses a patched version of “4.0” which is 2-5x faster) —
Refer to Alains email but to strictly answer the question of increasing
concurrent_compactors via jmx:
There are two attributes you can increase that would set the maximum number of
concurrent compactions.
org.apache.cassandra.db:type=CompactionManager,name=MaximumCompactorThreads ->
6
org.ap
There are 4+ implementations of CQL in addition to Apache Cassandra - the
ones I can think of off the top of my head include DSE, Yugabyte, CosmosDB,
and Scylla.
You'll want to define "popular". If by popular you mean "which
implementation of CQL has the most installed servers", nobody knows for
s
Hello,
It's a complex topic that has already been extensively discussed (at least
for the part about Datastax). I am sharing my personal understanding, from
what I read in the mailing list mostly:
Recently Cassandra eco system became very fragmented
>
I would not put Scylladb in the same 'eco sy
Oh man you just saved me ^^
I missed your link, I had just removed the users table, not the others… Now
they are gone and the password auth is working great !
Thanks a lot everyone for your help !!! :-)
> Le 18 juil. 2018 à 13:33, Sam Tunnicliffe a écrit :
>
> The salted hash being different
Hi,
Recently Cassandra eco system became very fragmented:
Scylladb provides solution based on Cassandra wire protocol claiming
it is 10 times faster than Cassandra.
Datastax provides it's own solution called DSE claiming it is twice
faster than Cassandra.
Also their site says "DataStax no longer
The salted hash being different is fine, the bcrypt library generates a
random 128 bit salt when encrypting a new password. The salt is then
encoded in the hashed string so you'd expect a different salted_hash each
time a given plaintext string is encoded.
I inserted exactly that data into a clean
It’s my mail client that changed the quote mark, I didn’t see it, it’s just an
export of the data I get from DevCenter, the salted hash is not the same as I
saw in this guide :
https://support.datastax.com/hc/en-us/articles/207932926-FAQ-How-to-recover-from-a-lost-superuser-password
But it shoul
It may be an artifact of the email client, but that's not a valid INSERT
statement - the closing quote on the password hash is U2019 (right side
quotation mark) but the opening quote is U0027 (apostrophe) - which is what
cqlsh expects. Can you just SELECT * from system_auth.roles and check that
the
Yes it’s the config I’m using and I’m trying to add the Password Auth to :-)
Here is the content of the roles table :
INSERT INTO roles (role,can_login,is_superuser,member_of,salted_hash) VALUES
('cassandra',true,true,null,'$2a$10$7sXeNr3okw61oisR9pCyHeWEO3wPzx3w8r/LKwtDSW2Tt68f4KFmi’);
It seem
With that config you'll be using the default AllowAllAuthenticator, so I
assume you are able to connect cqlsh without any credentials? If so, can
you verify the contents of the system_auth.roles table? It should contain
only the cassandra user.
On 18 July 2018 at 08:02, Thomas Lété wrote:
> I’m
Hi , On a cluster with 10 nodes, Out of 20K/seconds Native-Transports,
200/seconds of them blocked. They are mostly small single writes. Also I'm
expriencing random read delays, which i suspect the filled native queue. On all
nodes, cpu usage is less than 20 percent, and there is no problem in m
Okay thank you,
Can you send me a link to download the connector ?
Thank you very much.
Emeric.
De : Justin Cameron [mailto:jus...@instaclustr.com]
Envoyé : mercredi 18 juillet 2018 09:35
À : user@cassandra.apache.org
Objet : Re: How to connect a Cassandra database to Microsoft Power BI ?
Hi Eme
Hi Emeric,
Cassandra itself does not offer an ODBC compatible interface.
Spark offers ODBC/JDBC connectivity via Spark SQL, and you can connect this
to Cassandra using the Spark-Cassandra connector. You'll need to keep in
mind that Cassandra's data model requirements are very different and
limite
I’m using the default ones, the commented parts are the one I use when I try
the PasswordAuthenticator :) (line 19 to 24)
> Le 18 juil. 2018 à 08:51, Horia Mocioi a écrit :
>
> If this is the file that you are currently using...he first things that
> I see is that you do not have any authentica
Hi list,
I created a Power BI file which regroups several databases, and I have to
connect a Cassandra V3 database to Power BI.
Can someone explain me how can I do that ?
I have seen on Internet that is needed an ODBC driver, is there other solutions
to connect them ?
Any suggestion much apprec
21 matches
Mail list logo
