Much less connected native clients after node join

2015-11-15 Thread Michał Łowicki
Hi, I'm using Python Driver 2.7.2 connected to C* 2.1.11 cluster in two DCs. I had to reboot and rejoin one node and noticed that after successful join the number of connected native clients was much less than to other nodes (blue line on the attached graph). It didn't fixed after many hours so I

Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread badrjan
Hi, I have cluster of 4 machines With Cassandra 2.1.11,  SSD drives, 600 gb data on each node (replication factor 3).  When I run partial repair on one node, it takes 50 hours to finish. Is that normal?  B. 

Re: Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread Anuj Wadehra
Repair can take long time if you have lota of inconaistent data. If you havent restarted nodes yet, you can  run nodetool tpstats command on all nodes to make sure that there no mutation drops. Thanks Anuj Sent from Yahoo Mail on Android From:"badr...@tuta.io" Date:Sun, 15 Nov, 2015 at 4:20

Re: Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread Badrjan
Nothing is being dropped plus the processor is busy around 60%.  B. 15. Nov 2015 15:58 by anujw_2...@yahoo.co.in: > Repair can take long time if you have lota of inconaistent data. If you > havent restarted nodes yet, you can  run nodetool tpstats command on all > nodes to make sure that there

Re: Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread Anuj Wadehra
Ok. I dont have much experience with 2.1 as we are on 2.0.x. Are you using sequential repair? If yes, parallel repair can be faster but you need to make sure that your application has sufficient room to run when cluster is running repair. Are you observing any WARN or ERROR messages in logs wh

Re: Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread Badrjan
Repairs are parallel. The only error-ish message I see in the log of nodetool is "Lost notification. You should check server log for repair status of keyspace" During the repair most of the time was spent in the process of waiting for merkel tree from other nodes. I checked, the streaming was no

Re: Repair time comparison for Cassandra 2.1.11

2015-11-15 Thread Anuj Wadehra
For the error, you can see  http://www.scriptscoop.net/t/3bac9a3307ac/cassandra-lost-notification-from-nodetool-repair.html Lost notification should not be a problem.please see  https://issues.apache.org/jira/browse/CASSANDRA-7909 Infact, we are also currently facing an issue where merkle tr

Table modeling to search for various fields

2015-11-15 Thread Marlon Patrick
Hello guys, In this presentation the slides 23 and 24 shows a modeling technique in Cassandra as follows: Link: http://pt.slideshare.net/patrickmcfadin/become-a-super-modeler - Car table has a primary key composed of fields make, model, color, vehicle_id. - The partition key consists of fields

Convert timeuuid in timestamp programmatically

2015-11-15 Thread Marlon Patrick
Hi guys, Is there any way to convert a timeuuid in timestamp (dateOf) programmatically using DataStax java driver? -- Atenciosamente, Marlon Patrick

Re: Nested Collections in Cassandra

2015-11-15 Thread Neha Dave
Hi Jack, Thanks for the response. Do you think it's a good idea to have a separate table like : CREATE TYPE metadata ( key text, value set, path_id uuid ); And then index it on Value so that the query like... : SELECT * from metadata where value CONTAINS {values: {'FOX'}; 2.

Re: Convert timeuuid in timestamp programmatically

2015-11-15 Thread Dongfeng Lu
You can use long java.util.UUID.timestamp(). On Sunday, November 15, 2015 9:20 AM, Marlon Patrick wrote: Hi guys, Is there any way to convert a timeuuid in timestamp (dateOf) programmatically using DataStax java driver? -- Atenciosamente, Marlon Patrick

UDT - Collection - Query

2015-11-15 Thread Neha Dave
CREATE type metadata1 ( key text, value set, ); CREATE TABLE test_path3 ( path_id text, mdata frozen, PRIMARY KEY (path_id,mdata) ); CREATE INDEX metadata_teste_path3 on test_path3 (mdata) ; INSERT INTO test_path3 (path_id, mdata ) VALUES ( '2', { key :'mime-typ