Re: oracle goldengate to cassandra

2017-10-10 Thread sam sriramadhesikan
Nesli, What version of Golden Gate? This might be achievable with Golden Gate Big Data (source) to Kafka to Cassandra (sink). This link provides a good walkthrough except it uses ElasticSearch as

Re: DataStax Spark driver performance for analytics workload

2017-10-10 Thread Javier García-Valdecasas Bernal
Hi, The spark-cassandra-connector does pushdown filter when there are valid clauses. Pushdown filters go directly to cassandra so, if your model fits your queries, you won't end up reading or scanning the full table but only those partitions that match your query. You can check which clauses are

[RELEASE] Apache Cassandra 3.11.1 released

2017-10-10 Thread Michael Shuler
The Cassandra team is pleased to announce the release of Apache Cassandra version 3.11.1. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of source

[RELEASE] Apache Cassandra 3.0.15 released

2017-10-10 Thread Michael Shuler
The Cassandra team is pleased to announce the release of Apache Cassandra version 3.0.15. Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of source

Re: Could not connect to localhost:9160 when installing Cassandra on AWS

2017-10-10 Thread Jon Haddad
How did you install Cassandra? Try passing the machine’s IP address to cqlsh, like “cqlsh 192.168.1.1" > On Oct 10, 2017, at 10:43 AM, Lutaya Shafiq Holmes > wrote: > > Hello Cassandra Gurus, > > After I installed Cassandra on AWS- This error comes up when I try to

Could not connect to localhost:9160 when installing Cassandra on AWS

2017-10-10 Thread Lutaya Shafiq Holmes
Hello Cassandra Gurus, After I installed Cassandra on AWS- This error comes up when I try to Start CQLSH Could not connect to localhost:9160 What should I do ? -- Lutaaya Shafiq Web: www.ronzag.com | i...@ronzag.com Mobile: +256702772721 | +256783564130 Twitter: @lutayashafiq Skype: lutaya5

Re: LWT and non-LWT mixed

2017-10-10 Thread Anuj Wadehra
Hi Daniel, What is the RF and CL for Delete?Are you using asynchronous writes?Are you firing both statements from same node sequentially?Are you firing these queries in a loop such that more than one delete and LWT is fired for same partition? I think if you have the same client executing both

Re: Using materialized view or AllowFiltering which one is better ?

2017-10-10 Thread Avi Levi
Thank you Crisan. Using SASI does seems better solution. Although it is officially not supported in production, I think that this is the optimal solution in this case On Mon, Oct 9, 2017 at 11:01 PM, Valentina Crisan <

Re: DataStax Spark driver performance for analytics workload

2017-10-10 Thread Stone Fang
@kurt greaves doubt that need to read all the data.it is common that there are so many records in cassandra cluster. if loading all the data,how to analyse? On Mon, Oct 9, 2017 at 9:49 AM, kurt greaves wrote: > spark-cassandra-connector will provide the best way to

Re: LWT and non-LWT mixed

2017-10-10 Thread Javier Canillas
Daniel, Cassandra is "eventually consistent". This means that the DELETE can go to a different coordinator than the INSERT... IF NOT EXISTS. Being so, each coordinator enters a race condition than can make the INSERT...IF NOT EXISTS failed reading data that the DELETE will destroy. Even on the

LWT and non-LWT mixed

2017-10-10 Thread Daniel Woo
The document explains you cannot mix them http://docs.datastax.com/en/archived/cassandra/2.2/cassandra/dml/dmlLtwtTransactions.html But what happens under the hood if I do? e.g, DELETE INSERT ... IF NOT EXISTS The coordinator has 4 steps to do the second statement (INSERT) 1.

oracle goldengate to cassandra

2017-10-10 Thread neslişah demirci
Hi all , Is there anyone to know how can i configure oracle goldengate for data streaming to cassandra database ? Any comments , links, any help appreciated. Kind regards , Nesli.

Re: Does NTP affects LWT's ballot UUID?

2017-10-10 Thread Daniel Woo
Hi DuyHai, Thanks, and that's exactly what I am asking, if NTP goes backward. Actually NTP often does that because clock drift is inevitable. On Tue, Oct 10, 2017 at 3:13 PM, DuyHai Doan wrote: > The ballot UUID is obtained using QUORUM agreement between replicas for a >

Re: CREATE INDEX without IF NOT EXISTS when snapshoting

2017-10-10 Thread Lutaya Shafiq Holmes
TRY THIS CODE - REPLACE WITH YOUR OWN KEYSPACE AND TABLE cqlsh:tutorialspoint> describe table emp; CREATE TABLE tutorialspoint.emp ( emp_id int PRIMARY KEY, emp_city text, emp_name text, emp_phone varint, emp_sal varint ) WITH bloom_filter_fp_chance = 0.01 AND caching = '{"keys":"ALL",

Re: Does NTP affects LWT's ballot UUID?

2017-10-10 Thread DuyHai Doan
The ballot UUID is obtained using QUORUM agreement between replicas for a given partition key and we use this TimeUUID ballot as write-time for the mutation. The only scenario where I can see a problem is that NTP goes backward in time on a QUORUM of replicas, which would break the contract of

Does NTP affects LWT's ballot UUID?

2017-10-10 Thread Daniel Woo
Hi guys, The ballot UUID should be monotonically increasing on each coordinator, but the UUID in cassandra is version 1 (timestamp based), what happens if the NTP service adjusts system clock while a two phase paxos prepare/commit is in progress? -- Thanks & Regards, Daniel