Index and schema review

2012-02-08 Thread Tiwari, Dushyant
Hi Cassandra Users, I am considering Cassandra as the main data store. Just a quick description of the entity structure that we are looking at to store/design schema for. So we have 3 entities A,B and C. A has one to many relationship with B and similar is true for B and C. Hence this gives us

cli composite type literal with empty string component

2012-02-08 Thread Bryce Allen
I have a CF defined like this in CLI syntax: create column family Test with key_validation_class = UTF8Type and comparator = 'CompositeType(AsciiType, UTF8Type)' and default_validation_class = UTF8Type and column_metadata = [ { column_name : 'deleted:',

Re: cli composite type literal with empty string component

2012-02-08 Thread Bryce Allen
Never mind; the issue with addressing composite column names with empty components was fixed in the latest pycassa, which is why I was even able to create them in the Test3 schema below. I get an error in 1.2.1 which I used to be running, but it all seems to work in 1.4.0. -Bryce On Wed, 8 Feb

Re: cli composite type literal with empty string component

2012-02-08 Thread Bryce Allen
In case anyone else is curious about what is going on here: https://github.com/pycassa/pycassa/issues/112 The links to the Cassandra JIRA are instructive. -Bryce On Wed, 8 Feb 2012 10:59:37 -0600 Bryce Allen bal...@ci.uchicago.edu wrote: Never mind; the issue with addressing composite column

Re: Best way to know the cluster status

2012-02-08 Thread Tamil selvan R.S
Hi I fixed the issue. I used ConnectionPools with one server each, with send and recv timeout to 20Sec. Catching Cassandra Exception. This worked for me. Thanks for the response Regards, Tamil On Mon, Feb 6, 2012 at 5:38 PM, Sasha Dolgy sdo...@gmail.com wrote: Tamil, what is the underlying

Re: nodetool hangs and didn't print anything with firewall

2012-02-08 Thread Maxim Potekhin
That's good to hear because it does present a problem for a strictly manages and firewalled campus environment. Maxim On 2/6/2012 11:57 AM, Nick Bailey wrote: JMX is not very firewall friendly. The problem is that JMX is a two connection process. The first connection happens on port 7199 and

Re: truncate command fails

2012-02-08 Thread aaron morton
truncate will throw Unavailable when it times out waiting for one of the nodes to return. The full error for the UnavailableException should include some text saying how many messages it received. You can also check the logs on the other machines to see if they are erroring. Finally turn

Re: Index and schema review

2012-02-08 Thread aaron morton
1. Are the indexes local? i.e if node 1 holds say 10 keys that will only have indexes for theses 10 keys. In short – interested in knowing how is the index partitioned? Yes, nodes only hold the secondary indexes for the rows they are a replica for. This means it's token range and the

internode communication using multiple network interfaces

2012-02-08 Thread Chris Hart
Hi, I have 3 Cassandra nodes in one data center all on the same local network, which needs to replicate from an off site data center. Only 1 of the 3 nodes, called dw01, is externally accessible. dw01 has 2 network interfaces, one externally accessible and one internal. All 3 nodes talk to

Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
Hi All I have 2 Cassandra data center (DC1=1 node, DC2=2 nodes). XXX.XXX.XXX.XXX DC2 RAC1Up Normal 44.3 KB 33.33% 0 YYY.YYY.YY.YYY DC1 RAC1Up Normal 48.71 KB 33.33%

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
I have create the Keyspace like below, but the result is same. All the data getting replicated to all over the cluster instead of DC1. create keyspace WSDC with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options = {DC1:1,DC2:0}; -- View this

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Peter Schuller
It is expected that the schema is replicated everywhere, but *data* won't be in the DC with 0 replicas. -- / Peter Schuller (@scode, http://worldmodscode.wordpress.com)

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
Thanks for the reply. But I can see the data setting inserted in DC1 in DC2. So that means data also getting replicated to DC2. Want to know how to restrict this? -- View this message in context:

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Peter Schuller
Thanks for the reply. But I can see the data setting inserted in DC1 in DC2. So that means data also getting replicated to DC2. data setting inserted? You should not be seeing data in the DC with 0 replicas. What does data setting inserted mean? Do you have sstables on disk with data for the

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Peter Schuller
Again the *schema* gets propagated and the keyspace will exist everywhere. You should just have exactly zero amount of data for the keyspace in the DC w/o replicas. -- / Peter Schuller (@scode, http://worldmodscode.wordpress.com)