Limitations on secondary indexes

2013-03-07 Thread Edward Sargisson
Hi, Please correct me if this statement is wrong. Secondary indexes are limited to indexing 2 billion rows - because they turn a row into a column and C* has a limit of 2 billion columns. Cheers, Edward

Re: Force data to a specific node

2013-01-02 Thread Edward Sargisson
Why would you want to? From: Everton Lima peitin.inu...@gmail.com To: Cassandra-User user@cassandra.apache.org Sent: Wed Jan 02 18:03:49 2013 Subject: Force data to a specific node It is possible to force a data to stay in a specific node? -- Everton Lima Aleixo

Re: cannot parse 'name' as hex bytes

2012-12-05 Thread Edward Sargisson
You're not casting the types. Cassandra stores everything as bytes. You either need to set the key_validation_class to UTF8Type or use the utf8() function to convert. http://www.datastax.com/docs/1.1/dml/using_cli On 12-12-05 03:14 AM, Yogesh Dhari wrote: Hi all, I am very new to

Java 7 support?

2012-10-16 Thread Edward Sargisson
/install_deb, step 1 -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive supports email, instant

Re: Nodetool repair, exit code/status?

2012-10-09 Thread Edward Sargisson
to verify the repair has completed successfully: https://issues.apache.org/jira/browse/CASSANDRA-2666 Is this still a problem? What is the best way to monitor the final status of the repair command to make sure all is well? Thank you ahead of time for any info. - David -- Edward Sargisson senior

Re: Losing keyspace on cassandra upgrade

2012-09-19 Thread Edward Sargisson
://barracudanetworks.com/facebook -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive

Re: Losing keyspace on cassandra upgrade

2012-09-19 Thread Edward Sargisson
https://issues.apache.org/jira/browse/CASSANDRA-4583 On 12-09-19 08:30 AM, Michael Kjellman wrote: @Edward Do you have a bug number for that by chance? On Sep 19, 2012, at 8:25 AM, Edward Sargisson edward.sargis...@globalrelay.netmailto:edward.sargis...@globalrelay.net wrote: We've seen

Re: How to replace a dead *seed* node while keeping quorum

2012-09-12 Thread Edward Sargisson
any ideas. HTH, JAmes Cheers, Edward On 12-09-12 03:53 PM, Rob Coli wrote: On Tue, Sep 11, 2012 at 4:21 PM, Edward Sargisson edward.sargis...@globalrelay.net wrote: If the downed node is a seed node then neither of the replace a dead node procedures work (-Dcassandra.replace_token and taking

How to replace a dead *seed* node while keeping quorum

2012-09-11 Thread Edward Sargisson
? Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive supports email

Re: Schema Disagreement after migration from 1.0.6 to 1.1.4

2012-09-05 Thread Edward Sargisson
nodetool upgradesstables. When this had done, describe schema in the cli showed a schema definition which seemed correct, but was indeed different from the schema on the other nodes in the cluster. Any clues on how we should proceed? Thanks, /Martin Koch -- Edward Sargisson senior java

Re: Node forgets about most of its column families

2012-08-29 Thread Edward Sargisson
on https://issues.apache.org/jira/browse/CASSANDRA Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 8:38 AM, Edward Sargisson edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net wrote: For the record

Re: Node forgets about most of its column families

2012-08-28 Thread Edward Sargisson
resetlocalschema works. But the following nodetool repair crashes. It has to be stopped and then re-started. Are there any suggestions for logging or similar so that we can get a clue next time this happens. Cheers, Edward On 12-08-24 11:18 AM, Edward Sargisson wrote: Sadly, I don't think we

Re: Automating nodetool repair

2012-08-28 Thread Edward Sargisson
around so that only one should be running at once. Or, perhaps, a central orchestrator that is given some known quiet time and works its way through the list, running nodetool repair one at a time (using RPC?) until it runs out of time. Cheers, Edward -- Edward Sargisson senior java developer

Automating nodetool repair

2012-08-27 Thread Edward Sargisson
at once. Or, perhaps, a central orchestrator that is given some known quiet time and works its way through the list, running nodetool repair one at a time (using RPC?) until it runs out of time. Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis

Re: Node forgets about most of its column families

2012-08-24 Thread Edward Sargisson
Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 8:33 AM, Edward Sargisson edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net wrote: Ah, yes, I forgot that bit thanks! 1.1.2 running on Centos. Running nodetool resetlocalschema

Node forgets about most of its column families

2012-08-23 Thread Edward Sargisson
from unknown (probably removed) CF with id 1017 ... and so on. Hector is saying: InvalidRequestException(why:unconfigured columnfamily user_conversations) Thanks for any comments or advice, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net

Re: Node forgets about most of its column families

2012-08-23 Thread Edward Sargisson
Ah, yes, I forgot that bit thanks! 1.1.2 running on Centos. Running nodetool resetlocalschema then nodetool repair fixed the problem but not understanding what happened is a concern. Cheers, Edward On 12-08-23 12:40 PM, Rob Coli wrote: On Thu, Aug 23, 2012 at 11:47 AM, Edward Sargisson

Node doesn't rejoin ring after restart

2012-08-03 Thread Edward Sargisson
on the assumption that a small outage on one node shouldn't cause extraordinary action. Nor do I want to have to stop every node before bringing them up one by one. What am I missing? Am I forced into those time consuming methods every time I want to restart? Thoughts? Cheers, Edward -- Edward

Change of behaviour in multiget_slice query for unknown keys between 0.7 and 1.1?

2012-06-18 Thread Edward Sargisson
like to see if there was an explanation before I change the unit test for it. Many thanks in advance, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net *866.484.6630* New York | Chicago | Vancouver | London

Performance impact of static vs dynamic columns and mixing the two in the same CF

2012-06-05 Thread Edward Sargisson
for any comments. Cheers, Edward -- Edward Sargisson senior java developer Global Relay edward.sargis...@globalrelay.net mailto:edward.sargis...@globalrelay.net *866.484.6630* New York | Chicago | Vancouver | London (+44.0800.032.9829) | Singapore (+65.3158.1301) Global Relay Archive