Re: High Usage of Survivor Space

2016-10-26 Thread Daniel Kleviansky
Before anyone wastes any time replying, I found out that most of these were not being used, and manage to drop certain keyspaces and reduce the count of column families to 158. Thought still a fair number, this seems to have relieved the issue significantly! Hope this helps someone out at some

High Usage of Survivor Space

2016-10-26 Thread Daniel Kleviansky
​Hi everyone, Organisation is running Cassandra for Windows v2.2.5 One of our development (non-load testing) clusters has a total of 6 nodes across two DCs, with an RF = 3:3. Each node has a total of 16GB of memory, and no JVM options have been modified. We're seeing what I believe to be

Re: Cannot set TTL in COPY command

2016-10-26 Thread Stefania Alborghetti
The TTL option for the COPY command was only added in 3.2, CASSANDRA-9494 . On Thu, Oct 27, 2016 at 3:28 AM, Harikrishnan Pillai < hpil...@walmartlabs.com> wrote: > i have created a Jira for Cassandra version 3.9.Anyone have seen this >

Re: Cannot set TTL in COPY command

2016-10-26 Thread Harikrishnan Pillai
i have created a Jira for Cassandra version 3.9.Anyone have seen this scenario before in any 3.X version. https://issues.apache.org/jira/browse/CASSANDRA-12844 Regards Hari From: Lahiru Gamathige Sent: Wednesday, October 26, 2016 10:46:51

Node tool drain causing hint corruption

2016-10-26 Thread Harikrishnan Pillai
Changing the subject Sent from my iPhone On Oct 26, 2016, at 12:28 PM, Harikrishnan Pillai > wrote: i have created a Jira for Cassandra version 3.9.Anyone have seen this scenario before in any 3.X version.

Re: Error creating pool to /IP_ADDRESS33:9042 (Proving Cassandra's NO SINGLE point of failure)

2016-10-26 Thread Edward Capriolo
I would suggest you look some existing work http://techblog.netflix.com/2014/07/revisiting-1-million-writes-per-second.html and attempt to re-create those scenarios and methodologies for failing nodes and seeing the performance impact. This would yield faster and more easily verifiable results

Re: Cannot set TTL in COPY command

2016-10-26 Thread Lahiru Gamathige
Highly recommend to move to a newer Cassandra version first because TTL and compaction are much more consistent. On Wed, Oct 26, 2016 at 10:36 AM, Tyler Hobbs wrote: > > On Wed, Oct 26, 2016 at 10:07 AM, techpyaasa . > wrote: > >> Can some one please

Re: Import failure for use python cassandra-driver

2016-10-26 Thread Tyler Hobbs
This was fixed by the 3.7.1 release of the python driver: https://groups.google.com/a/lists.datastax.com/forum/#!topic/python-driver-user/1UbvYc_h9KQ On Wed, Oct 26, 2016 at 4:35 AM, Stefano Ortolani wrote: > Did you try the workaround they posted (aka, downgrading Cython)?

Re: Cannot set TTL in COPY command

2016-10-26 Thread Tyler Hobbs
On Wed, Oct 26, 2016 at 10:07 AM, techpyaasa . wrote: > Can some one please tell me how to set TTL using COPY command? It looks like you're using Cassandra 2.0. I don't think COPY supports the TTL option until at least 2.1. -- Tyler Hobbs DataStax

Re: Cannot set TTL in COPY command

2016-10-26 Thread Lahiru Gamathige
Yes if you alter the table now all the new data would have ttl attached but not the old data. On Wed, Oct 26, 2016 at 8:39 AM, techpyaasa . wrote: > And to add to above email , its already existing table with some data and > NOT new table. > Is it ok to change table

Re: Cannot set TTL in COPY command

2016-10-26 Thread techpyaasa .
And to add to above email , its already existing table with some data and NOT new table. Is it ok to change table property default_time_to_live now? On Wed, Oct 26, 2016 at 9:06 PM, laxmikanth sadula wrote: > You mean to say instead of > *COPY keyspace1.columnFamily1

Re: Cannot set TTL in COPY command

2016-10-26 Thread laxmikanth sadula
You mean to say instead of *COPY keyspace1.columnFamily1 FROM 'dump_data.csv' WITH TTL = '7200';*use *COPY keyspace1.columnFamily1 FROM 'dump_data.csv' WITH DEFAULT_TIME_TO_LIVE = '7200';* I tried this way too, but again exception thrown saying "*Unrecognized COPY FROM options:

Re: Cannot set TTL in COPY command

2016-10-26 Thread Lahiru Gamathige
You have to use with default_time_to_live = 7200. On Wed, Oct 26, 2016 at 8:07 AM, techpyaasa . wrote: > Hi all, > > I'm getting following exception when I try to set TTL using COPY command, > where as it is working fine without TTL option. Followed doc at >

Cannot set TTL in COPY command

2016-10-26 Thread techpyaasa .
Hi all, I'm getting following exception when I try to set TTL using COPY command, where as it is working fine without TTL option. Followed doc at https://docs.datastax.com/en/cql/3.1/cql/cql_reference/copy_r.html *"**Improper COPY command.**"* Command used as below *COPY

RE: Error creating pool to /IP_ADDRESS33:9042 (Proving Cassandra's NO SINGLE point of failure)

2016-10-26 Thread Rajesh Radhakrishnan
Hi Vladimir, Thank you for the response. Yes I added all the three node IPs while connecting to the cluster via driver. Its not failed operation. while the script is running and it takes some time to read millions of data and during this time , I intentionally put one node down to see how the

Re: cluster creating problem due to same cluster name

2016-10-26 Thread kurt Greaves
github, not JIRA... Kurt Greaves k...@instaclustr.com www.instaclustr.com On 26 October 2016 at 09:36, kurt Greaves wrote: > you probably should raise this as an issue on their JIRA. (I assume you're > using TLP's fork: https://github.com/thelastpickle/cassandra-reaper) >

Re: cluster creating problem due to same cluster name

2016-10-26 Thread kurt Greaves
you probably should raise this as an issue on their JIRA. (I assume you're using TLP's fork: https://github.com/thelastpickle/cassandra-reaper) Kurt Greaves k...@instaclustr.com www.instaclustr.com On 26 October 2016 at 06:51, Abhishek Aggarwal < abhishek.aggarwa...@snapdeal.com> wrote: > > Not

Re: Import failure for use python cassandra-driver

2016-10-26 Thread Stefano Ortolani
Did you try the workaround they posted (aka, downgrading Cython)? Cheers, Stefano On Wed, Oct 26, 2016 at 10:01 AM, Zao Liu wrote: > Same happen to my ubuntu boxes. > > File >

Re: Import failure for use python cassandra-driver

2016-10-26 Thread Zao Liu
Same happen to my ubuntu boxes. File "/home/jasonl/.pex/install/cassandra_driver-3. 7.0-cp27-none-linux_x86_64.whl. ebfb31ab99650d53ad134e0b312c7494296cdd2b/cassandra_driver-3. 7.0-cp27-none-linux_x86_64.whl/cassandra/cqlengine/connection.py", line 20, in from cassandra.cluster import

Import failure for use python cassandra-driver

2016-10-26 Thread Zao Liu
Hi, Suddenly I start to get this following errors when use python cassandra driver 3.7.0 in my macbook pro running OS X EI Capitan. Tries to reinstall the package and all the dependencies, unfortunately no luck. I was able to run it a few days earlier. Really can't recall what I changed could

Re: which one of the following choices is more efficient?

2016-10-26 Thread Kant Kodali
@Benjamin Roth I think you kinda of answered my question. my use case is really that I need to store a SkipList like structure into one or multiple tables. I could map the entire skip list like structure into one table or I could map a list at every level into another table and the number of

Re: which one of the following choices is more efficient?

2016-10-26 Thread Kant Kodali
@Ali hmm..I didn't mean to say I store the same data across two tables and neither tables are dependent for me to do the writes twice. you can imagine tables are independent and the data is unique across tables but I could store data from multiple tables into one table. otherwords I am just

Re: which one of the following choices is more efficient?

2016-10-26 Thread Benjamin Roth
If you have 2 tables that share the same PK and have few fields and most of the rows have values for all (or many fields), merging them could save you some space as for each table, each PK has to be stored in both tables. But I would avoid having "god tables" with too many fields. But at the end

Re: which one of the following choices is more efficient?

2016-10-26 Thread Ali Akhtar
You would need to do each write twice and data will take up twice the space as its duplicated in two places. On Wed, Oct 26, 2016 at 1:17 PM, Kant Kodali wrote: > I guess the question can be rephrased into "What is the overhead of > creating and maintaining an additional

Re: which one of the following choices is more efficient?

2016-10-26 Thread Kant Kodali
I guess the question can be rephrased into "What is the overhead of creating and maintaining an additional table?" On Wed, Oct 26, 2016 at 1:12 AM, Ali Akhtar wrote: > Depends on the use case. No one right answer. > > On Wed, Oct 26, 2016 at 1:03 PM, Kant Kodali

Re: which one of the following choices is more efficient?

2016-10-26 Thread Ali Akhtar
Depends on the use case. No one right answer. On Wed, Oct 26, 2016 at 1:03 PM, Kant Kodali wrote: > If one were given a choice of fitting all the data into one table vs > fitting the data into two tables while say (keeping all the runtime and > space complexity for CRUD

which one of the following choices is more efficient?

2016-10-26 Thread Kant Kodali
If one were given a choice of fitting all the data into one table vs fitting the data into two tables while say (keeping all the runtime and space complexity for CRUD operations the same in either case) which one would you choose and why?

cluster creating problem due to same cluster name

2016-10-26 Thread Abhishek Aggarwal
Not able to create new cluster with existing name in reaper with diff seed. As per code firstly using the jmx cluster name is fetched and looked into DB if the cluster with same name exists or not. My point is if the seed ip is different then it should allow to create the new cluster.

unscribe

2016-10-26 Thread Mehdi Bada
unscribe Mehdi Bada | Consultant Phone: +41 32 422 96 00 | Mobile: +41 79 928 75 48 | Fax: +41 32 422 96 15 dbi services, Rue de la Jeunesse 2, CH-2800 Delémont mehdi.b...@dbi-services.com www.dbi-services.com ⇒ dbi services is recruiting Oracle & SQL Server experts ! – Join the team