Counter table in Cassandra

2019-05-28 Thread Garvit Sharma
Hi, I am using counter tables in Cassandra and I want to understand how the concurrent updates to counter table are handled in Cassandra. There are more than one threads who are responsible for updating the counter for a partition key. Multiple threads can also update the counter for the same key

Sstableloader

2019-05-28 Thread Rahul Reddy
Hello, Does sstableloader works between datastax and Apache cassandra. I'm trying to migrate dse 5.0.7 to Apache 3.11.1 ?

Re: Can sstable corruption cause schema mismatch?

2019-05-28 Thread Nitan Kainth
Thank you Alain. Nodetool describecluster shows some nodes unreachable, different output from each node. Node1 can see all 4 nodes up. Node 2 says node 4 and node 5 unreachable Node 3 complains about node node 2 and node 1 Nodetool status shows all nodes up and read writes are working for most

Re: Can sstable corruption cause schema mismatch?

2019-05-28 Thread Alain RODRIGUEZ
Hello Nitan, 1. Can sstable corruption in application tables cause schema mismatch? > I would say it should not. I could imagine in the case that the corrupted table hits some 'system' keyspace sstable. If not I don' see how corrupted data can impact the schema on the node. > 2. Do we need to d

Can sstable corruption cause schema mismatch?

2019-05-28 Thread Nitan Kainth
Hi, Two questions: 1. Can sstable corruption in application tables cause schema mismatch? 2. Do we need to disable repair while adding storage while Cassandra is down? Regards, Nitan Cell: 510 449 9629

Unsubscribe

2019-05-28 Thread Steve Luo
Unsubscribe

RE: [EXTERNAL] Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

2019-05-28 Thread Durity, Sean R
This may sound a bit harsh, but I teach my developers that if they are trying to use ALLOW FILTERING – they are doing it wrong! We often choose Cassandra for its high availability and scalability characteristics. We love no downtime. ALLOW FILTERING is breaking the rules of availability and scal

RE: [EXTERNAL] Re: Python driver concistency problem

2019-05-28 Thread Durity, Sean R
This is a stretch, but are you using authentication and/or authorization? In my understanding the queries executed for you to do the authentication and/or authorization are usually done at LOCAL_ONE (or QUORUM for cassandra user), but maybe there is something that is changed in the security setu

Usage of IN at creating materialized view

2019-05-28 Thread Alptug Tokgoz
Hello, I have struggled with the following problem for last a couple of days. First of all I am using cqlsh 5.0.1 ,Cassandra 3.11.1 and CQL spec 3.4.4. What I am trying to do is creating a materialized view, named income_periods from a table named income. The problem is, i am able to create

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

2019-05-28 Thread Attila Wind
Hi Shalom, Thanks for your notes! So you also experienced this thing... fine Then maybe the best rules to follow are these: a) never(!) run a query "ALLOW FILTERING" on a Production cluster b) if you need these queries build a test cluster (somehow) and mirror the data (somehow) OR add denormal

Re: Select in allow filtering stalls whole cluster. How to prevent such behavior?

2019-05-28 Thread shalom sagges
Hi Attila, I'm definitely no guru, but I've experienced several cases where people at my company used allow filtering and caused major performance issues. As data size increases, the impact will be stronger. If you have large partitions, performance will decrease. GC can be affected. And if GC sto