Re: Performance impact with ALLOW FILTERING clause.

. Regards, Jacques-Henri Berthemet From: "ZAIDI, ASAD A" Reply to: "user@cassandra.apache.org" Date: Thursday 25 July 2019 at 15:49 To: "user@cassandra.apache.org" Subject: Performance impact with ALLOW FILTERING clause. Hello Folks, I was going thru documentation

Re: [EXTERNAL] multiple Cassandra instances per server, possible?

So how much data can you safely fit per node using SSDs with Cassandra 3.11? How much free space do you need on your disks? There should be some recommendations on node sizes on: http://cassandra.apache.org/doc/latest/operating/hardware.html Documentation - Apache Cassandra

Re: cass-2.2 trigger - how to get clustering columns and value?

without values is a delete of the Cell. Regards, Jacques-Henri Berthemet From: Carl Mueller Reply-To: "user@cassandra.apache.org" Date: Wednesday 10 April 2019 at 23:53 To: "user@cassandra.apache.org" Subject: cass-2.2 trigger - how to get clustering columns and value? We have a

Re: Cassandra Possible read/write race condition in LOCAL_ONE?

If you use LOCAL_ONE for write and read and you have RF>1, it means both operations could go to different replicas that does not have the data yet. Try to use LOCAL_QUORUM instead, as usual check your clocks as well. From: Jeff Jirsa Reply-To: "user@cassandra.apache.org" Date: Thursday 28 March

Re: SASI queries- cqlsh vs java driver

I’m not sure why it`s not allowed by the Datastax driver, but maybe you could try to use OR instead of IN? SELECT blah FROM foo WHERE = :val1 OR = :val2 ALLOW FILTERING It should be the same as IN query, but I don’t if it makes a difference for performance. From: Peter Heitman Reply-To: "us

Re: OpenJDK and Windows Service Error

Apache Cassandra has no service executable, so you're probably using Datastax DDAC instead, if it's the case you should contact them for support. From: Michael Shuler on behalf of Michael Shuler Sent: Wednesday, January 2, 2019 17:15 To: user@cassandra.apache.

RE: Cassandra 4.0

Are there binary builds available for testing or is it source only? -- Jacques-Henri Berthemet -Original Message- From: Nate McCall Sent: Wednesday, October 24, 2018 10:02 PM To: Cassandra Users Subject: Re: Cassandra 4.0 When it's ready :) In all seriousness, the past two

RE: how to avoid lightwieght transactions

data is actually the same you can always insert. If you insert on an existing record it will just overwrite it, if you update without an existing record it will insert data. In Cassandra there is not much difference between insert and update operations. Regards, -- Jacques-Henri Berthemet

RE: Does Cassandra supports ACID txn

/13/cassandra-to-batch-or-not-to-batch/ -- Jacques-Henri Berthemet From: Rajesh Kishore [mailto:rajesh10si...@gmail.com] Sent: Thursday, April 19, 2018 11:13 AM To: user@cassandra.apache.org Subject: Re: Does Cassandra supports ACID txn Thanks for the response. Let me put my question again wrt a

RE: Does Cassandra supports ACID txn

won’t have a way to know if it worked or not. There is no way to rollback a statement/batch, the only way is to send an update to modify the partition to its previous state. Regards, -- Jacques-Henri Berthemet From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: Thursday, April 19, 2018 9:10 AM To

Re: Is it safe to use paxos protocol in LWT from patent perspective ?

Hi Hiroyuki, That's an interesting question, it looks like Paxos was invented in 1989: https://en.wikipedia.org/wiki/Paxos_(computer_science) So "prior art" could discard such patent claim. -- Jacques-Henri Berthemet From: Hiroyuki Yamada

RE: Mailing list server IPs

Hi Nate, Thanks for the help, I passed the info to our IT. Regards, -- Jacques-Henri Berthemet From: Nate McCall [mailto:n...@thelastpickle.com] Sent: Monday, April 16, 2018 12:27 AM To: Cassandra Users Subject: Re: Mailing list server IPs Hi Jacques, Thanks for bringing this up. I took a

RE: Mailing list server IPs

I checked with IT and I missed an email on the period where I got the last bounce. It’s not a very big deal but I’d like to have it fixed if possible. Gmail servers are very picky on SMTP traffic and reject a lot of things. -- Jacques-Henri Berthemet From: Nicolas Guyomar [mailto:nicolas.guyo

Mailing list server IPs

://untroubled.org/ezmlm/ezman/ezman5.html commands. Regards, -- Jacques-Henri Berthemet --- Begin Message --- Hi! This is the ezmlm program. I'm managing the user@cassandra.apache.org mailing list. Messages to you from the user mailing list seem to have been bouncing. I've attached a copy of

RE: does c* 3.0 use one ring for all datacenters?

okens will be rearranged between all nodes within the DC only, the other DCs won't be affected. -- Jacques-Henri Berthemet -Original Message- From: Jinhua Luo [mailto:luajit...@gmail.com] Sent: Wednesday, April 11, 2018 12:35 PM To: user@cassandra.apache.org Subject: does c* 3.0 us

RE: LWT on data mutated by non-LWT operation is valid ?

If you check the Jira issue I linked you'll see a recent comment describing a potential explanation for my mixed LWT/non-LWT problem. So, it looks like there can be some edge cases. I'd say that if data was inserted a while ago (seconds) there should be no problems. -- Jacques-Henri

Re: LWT on data mutated by non-LWT operation is valid ?

Hi Hiroyuki, For both operations you'll have to provide partition key so "conflict" at DB level can always be resolved. But if two operations, LWT and non-LWT, are racing against each others the result is unpredictable, if non-LWT is applied after LWT the result will be overwritten. It seem

Re: Using Spark to delete from Transactional Cluster

A row is TTLed once all its columns are TTLed. If you want a row to be TTLed at once just set the same TTL on all its columns. From: Charulata Sharma (charshar) Sent: Friday, March 23, 2018 9:52:28 PM To: user@cassandra.apache.org Subject: Re: Using Spark to dele

RE: Cassandra DevCenter

Then you need to make the cp yourself as I described. -- Jacques-Henri Berthemet -Original Message- From: phi...@free.fr [mailto:phi...@free.fr] Sent: Tuesday, March 13, 2018 11:03 AM To: user@cassandra.apache.org Subject: Re: Cassandra DevCenter Same result. - Mail original

RE: Cassandra DevCenter

ifact/com.datastax.cassandra/cassandra-driver-core/3.4.0 "Compile dependencies" and make it yourself. -- Jacques-Henri Berthemet -Original Message- From: phi...@free.fr [mailto:phi...@free.fr] Sent: Tuesday, March 13, 2018 9:51 AM To: user@cassandra.apache.org Subject: Re: Cassandra DevCenter

RE: Cassandra DevCenter

Hi, Try that: groovy -cp C:\DevCenter\plugins\*.jar Cass1.groovy -- Jacques-Henri Berthemet -Original Message- From: phi...@free.fr [mailto:phi...@free.fr] Sent: Tuesday, March 13, 2018 9:40 AM To: user@cassandra.apache.org Subject: Re: Cassandra DevCenter Good morning, when I run

RE: yet another benchmark bottleneck

If throughput decreases as you add more load then it’s probably due to disk latency, can you test SDDs? Are you using VMWare ESXi? -- Jacques-Henri Berthemet From: onmstester onmstester [mailto:onmstes...@zoho.com] Sent: Monday, March 12, 2018 2:15 PM To: user Subject: RE: yet another

RE: yet another benchmark bottleneck

What happens if you increase number of client threads? Can you add another instance of cassandra-stress on another host? -- Jacques-Henri Berthemet From: onmstester onmstester [mailto:onmstes...@zoho.com] Sent: Monday, March 12, 2018 12:50 PM To: user Subject: RE: yet another benchmark

RE: yet another benchmark bottleneck

f cores in # your system; (8 * number_of_cores) is a good rule of thumb. concurrent_reads: 32 concurrent_writes: 32 concurrent_counter_writes: 32 Jumping directly to 160 would be a bit high with spinning disks, maybe start with 64 just to see if it gets better. -- Jacques-Henri Berthemet From:

RE: yet another benchmark bottleneck

Any errors/warning in Cassandra logs? What’s your RF? Using 300MB/s of network bandwidth for only 130 op/s looks very high. -- Jacques-Henri Berthemet From: onmstester onmstester [mailto:onmstes...@zoho.com] Sent: Monday, March 12, 2018 11:38 AM To: user Subject: RE: yet another benchmark

RE: yet another benchmark bottleneck

What’s your disk latency? What kind of disk is it? -- Jacques-Henri Berthemet From: onmstester onmstester [mailto:onmstes...@zoho.com] Sent: Monday, March 12, 2018 10:48 AM To: user Subject: Re: yet another benchmark bottleneck Running two instance of Apache Cassandra on same server, each

RE: Cassandra DevCenter

: https://mvnrepository.com/artifact/com.datastax.cassandra/cassandra-driver-core Put only the jars listed on the driver version you have on you classpath and it should work. -- Jacques-Henri Berthemet From: Philippe de Rochambeau [mailto:phi...@free.fr] Sent: Saturday, March 10, 2018 6:56 PM To

RE: Secondary Indexes C* 3.0

A very interesting and detailed article, thank you DuyHai. I think this should be part of general Cassandra documentation. -- Jacques-Henri Berthemet From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: Thursday, February 22, 2018 7:04 PM To: user Subject: Re: Secondary Indexes C* 3.0 Read

RE: Cassandra Needs to Grow Up by Version Five!

nals for my custom secondary index I can tell you that there was a huge rework between Cassandra 2.2 and 3.x, PartitionIterators are a very elegant solution and is really helpful in my case, great work guys :) -- Jacques-Henri Berthemet -Original Message- From: Kenneth Brotman [mai

RE: overhead of empty tables

The main overhead is that each table locks 1MB of Java heap, so if you have 1000 tables it will use 1GB of RAM just for managing the tables, even if they are empty. -- Jacques-Henri Berthemet From: Alaa Zubaidi (PDF) [mailto:alaa.zuba...@pdf.com] Sent: Friday, February 16, 2018 1:05 AM To

RE: LWT broken?

inconsistencies happened and check corresponding Cassandra logs to see what happened. -- Jacques-Henri Berthemet From: Mahdi Ben Hamida [mailto:ma...@signalfx.com] Sent: Monday, February 12, 2018 8:45 PM To: user@cassandra.apache.org Subject: Re: LWT broken? On 2/12/18 2:04 AM, Jacques-Henri Berthemet

RE: LWT broken?

. Regards, -- Jacques-Henri Berthemet From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: Sunday, February 11, 2018 6:11 PM To: user Subject: Re: LWT broken? Mahdi , the issue in your code is here: else // we lost LWT, fetch the winning value 9existing_id = SELECT id FROM hash_id WHERE hash

RE: ClassNotFoundException when trigger is fired

lasspath before starting Cassandra. Regards, -- Jacques-Henri Berthemet From: tsubasa.nar...@us.fujitsu.com [mailto:tsubasa.nar...@us.fujitsu.com] Sent: mercredi 6 décembre 2017 19:49 To: user@cassandra.apache.org Subject: ClassNotFoundException when trigger is fired Dear All I use cassandra trigger

RE: Solr Search With Apache Cassandra

Tjake is now working for Datastax and they made DSE out of Solandra. -- Jacques-Henri Berthemet From: Jon Haddad [mailto:jonathan.had...@gmail.com] On Behalf Of Jon Haddad Sent: lundi 20 novembre 2017 18:11 To: user Subject: Re: Solr Search With Apache Cassandra That’s long since been

RE: Solr Search With Apache Cassandra

How are Cassandra and Solr related? they are two separate products. -- Jacques-Henri Berthemet From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] Sent: lundi 20 novembre 2017 10:04 To: user Subject: Re: Solr Search With Apache Cassandra Hi Jacques, For testing, I configure Apache

RE: Solr Search With Apache Cassandra

Hi, Apache Cassandra does not have Solr search, it’s Datastax Entreprise that supports such feature, you should contact Datastax support for such questions. Regards, -- Jacques-Henri Berthemet From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] Sent: lundi 20 novembre 2017 06:44 To: user

RE: Executing a check before replication / manual replication

only work when you have different DCs. One DC would stay with rogue data, and the other one would shutdown. -- Jacques-Henri Berthemet From: Abdelkrim Fitouri [mailto:abdou@gmail.com] Sent: jeudi 16 novembre 2017 22:33 To: user@cassandra.apache.org Subject: Re: Executing a check before

RE: SASI and secondary index simultaniously

difference. It also means that you may miss results until it is fully built. Note that I may be wrong, I’m just reading sources as I’m working on a custom index. -- Jacques-Henri Berthemet From: Vlad [mailto:qa23d-...@yahoo.com.INVALID] Sent: mercredi 12 juillet 2017 08:56 To: User

RE: Reg:- Data Modelling For Hierarchy Data

-materialized-views/ I don’t have experience on MVs, I’m stuck on 2.2 for now. Regards, -- Jacques-Henri Berthemet From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] Sent: vendredi 9 juin 2017 10:27 To: Jacques-Henri Berthemet Cc: user@cassandra.apache.org Subject: Re: Reg:- Data Modelling For

RE: Reg:- Data Modelling For Hierarchy Data

exceed 64k, but you could create dedicate columns for all attributes that you know will always be there. -- Jacques-Henri Berthemet From: @Nandan@ [mailto:nandanpriyadarshi...@gmail.com] Sent: vendredi 9 juin 2017 03:14 To: user@cassandra.apache.org Subject: Reg:- Data Modelling For Hierarchy Data

RE: Reg:- CQL SOLR Query Not gives result

for Chinese, using wildcards with CJK does not make sense. 中 can be considered as a word, not a letter, so partial matches using wildcards don’t make sense. Also, CJK analyzer is indexing bi-grams, so you should search for pairs of characters. -- Jacques-Henri Berthemet From: Jonathan Haddad

RE: NoSE: Automated schema design for Cassandra

generate test code to validate the workload? -- Jacques-Henri Berthemet From: michael.m...@gmail.com [mailto:michael.m...@gmail.com] On Behalf Of Michael Mior Sent: mardi 9 mai 2017 17:30 To: user Subject: NoSE: Automated schema design for Cassandra Hi all, I wanted to share a tool I've

RE: scylladb

Will you support custom secondary indexes, triggers and UDF? I checked index code but it’s just a couple of files with commented Java code. I’m curious to test Scylladb but our application uses LWT and custom secondary indexes, I understand LWT is coming (soon?). -- Jacques-Henri Berthemet

RE: scylladb

limiting factor is your disk write speed and latency, I don’t see how C++ changes anything in this regard unless you can cache all your data in memory. I’d be curious to know how ScyllaDB performs with a 100+ nodes cluster with PBs of data compared to Cassandra. -- Jacques-Henri Berthemet From

RE: [C*3.0.3]lucene indexes not deleted and nodetool repair makes DC unavailable

Hi, This is very interesting that there is a difference between vanilla Cassandra and DSC, I thought it was simply the same thing provided with a setup/package. -- Jacques-Henri Berthemet From: Eduardo Alonso [mailto:eduardoalo...@stratio.com] Sent: vendredi 6 mai 2016 07:36 To: user

RE: how expensive is light weight transaction: if not exists

Hi, You can’t batch LWT if they don’t work on the same partition. So in your below queries all the values of “id” must be the same. -- Jacques-Henri Berthemet From: y2k...@gmail.com [mailto:y2k...@gmail.com] On Behalf Of Jimmy Lin Sent: mercredi 27 avril 2016 18:14 To: user

RE: How many nodes do we require

You’re right. I meant about data integrity, I understand it’s not everybody’s priority! -- Jacques-Henri Berthemet From: Jonathan Haddad [mailto:j...@jonhaddad.com] Sent: jeudi 31 mars 2016 17:48 To: user@cassandra.apache.org Subject: Re: How many nodes do we require Losing a write is very

RE: How many nodes do we require

Because if you lose a node you have chances to lose some data forever if it was not yet replicated. -- Jacques-Henri Berthemet From: Jonathan Haddad [mailto:j...@jonhaddad.com] Sent: vendredi 25 mars 2016 19:37 To: user@cassandra.apache.org Subject: Re: How many nodes do we require Why would

RE: How many nodes do we require

I found this calculator very convenient: http://www.ecyrd.com/cassandracalculator/ Regardless of your other DCs you need RF=3 if you write at LOCAL_QUORUM, RF=2 if you write/read at ONE. Obviously using ONE as CL makes your cluster very fragile. -- Jacques-Henri Berthemet -Original

RE: Updating secondary index options

that holds index options but it seems I need to restart Cassandra twice to be able to see the changes. Regards, -- Jacques-Henri Berthemet From: Jack Krupansky [mailto:jack.krupan...@gmail.com] Sent: vendredi 4 mars 2016 18:40 To: user@cassandra.apache.org Subject: Re: Updating secondary index o

RE: Updating secondary index options

It’s not possible, it’s a PerRowSecondary index, potentially as big as the table itself (few TBs) it will take a very long time to drop and re-create. -- Jacques-Henri Berthemet From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: vendredi 4 mars 2016 14:52 To: user@cassandra.apache.org

Updating secondary index options

Hi, I'm using Cassandra 2.2.5 with a custom secondary index. It's created with the below syntax: https://docs.datastax.com/en/cql/3.1/cql/cql_reference/create_index_r.html CREATE CUSTOM INDEX ON users (email) USING 'path.to.the.IndexClass' WITH OPTIONS = {'some_setting': 'value'}; I'd like to up

RE: automated CREATE TABLE just nuked my cluster after a 2.0 -> 2.1 upgrade....

the schema upgraded that much. -- Jacques-Henri Berthemet From: Ken Hancock [mailto:ken.hanc...@schange.com] Sent: mardi 2 février 2016 17:14 To: user@cassandra.apache.org Subject: Re: automated CREATE TABLE just nuked my cluster after a 2.0 -> 2.1 upgrade Just to close the loop on this,

RE: Changing schema on multiple nodes while they are isolated

conflicts it will be resolved on the basis of the row timestamp. -- Jacques-Henri Berthemet From: Stephen Baynes [mailto:stephen.bay...@smoothwall.net] Sent: lundi 5 octobre 2015 11:00 To: user@cassandra.apache.org Subject: Re: Changing schema on multiple nodes while they are isolated > Why do

RE: Changing schema on multiple nodes while they are isolated

Why don’t you simply let the node join the cluster? It will pull new tables and the data automatically. -- Jacques-Henri Berthemet From: Stephen Baynes [mailto:stephen.bay...@smoothwall.net] Sent: vendredi 2 octobre 2015 18:08 To: user@cassandra.apache.org Subject: Re: Changing schema on

RE: Changing schema on multiple nodes while they are isolated

enabled at any given time. -- Jacques-Henri Berthemet From: Stephen Baynes [mailto:stephen.bay...@smoothwall.net] Sent: vendredi 2 octobre 2015 16:46 To: user@cassandra.apache.org Subject: Changing schema on multiple nodes while they are isolated Is it safe to make schema changes ( e.g. create keyspace

RE: Using DTCS, TTL but old SSTables not being removed

Hi, Any idea when 2.2.2 will be released? I see there are still 3 issues left to fix: https://issues.apache.org/jira/browse/CASSANDRA/fixforversion/1219/?selectedTab=com.atlassian.jira.jira-projects-plugin:version-summary-panel -- Jacques-Henri Berthemet -Original Message- From

RE: TTL question

What if you use an update statement in the second query? -- Jacques-Henri Berthemet -Original Message- From: Tommy Stendahl [mailto:tommy.stend...@ericsson.com] Sent: vendredi 28 août 2015 13:34 To: user@cassandra.apache.org Subject: Re: TTL question Yes, I understand that but I think