Updates is not happening when using the same time stamp.

2013-12-02 Thread srinivas rao
Hi Team, i am facing an issue, with updating the data with same time stamp. The column values with string type which multiple fields are delimited with "|", example (1|2|3|4|5|6|). if i chage one of the field, some times its updating properly with same time stamp (column internal clock). however

Re: Updates is not happening when using the same time stamp.

2013-12-02 Thread srinivas rao
> > Hi Team, > > i am facing an issue, with updating the data with same time stamp. > > The column values with string type which multiple fields are delimited > with "|", example (1|2|3|4|5|6|). > if i chage one of the field, some times its updating properly with same > time stamp (column internal

Repair hangs - Cassandra 1.2.10

2013-12-02 Thread Tamar Rosen
Hi, On AWS, we had a 2 node cluster with RF 2. We added 2 more nodes, then changed RF to 3 on all our keyspaces. Next step was to run nodetool repair, node by node. (In the meantime, we found that we must use CL quorum, which is affecting our application's performance). Started with node 1, which

Re: Sample Trigger Code to get inserted value

2013-12-02 Thread J Ramesh Kumar
Finally I got it working... Below are the code snippet which will be useful for trigger users, public Collection augment(ByteBuffer key, ColumnFamily cf) { try { ByteBuffer id_bb = CompositeType.extractComponent(key, 0); UUID id=TimeUUIDType.instance.compose(id_bb)

Re: Updates is not happening when using the same time stamp.

2013-12-02 Thread Julien Campan
Hi, The internal timestamp is used when you try to read a row. Cassandra checks all the versions of the same row and returns the one with the most recent timestamp. If you make many writes (updates) of the same row with the same timestamp and then read it, Cassandra is not going to be able to c

Configuration of multiple nodes in a single machine

2013-12-02 Thread Santosh Shet
Hi, I have requirement to setup multiple nodes to the existing single node Cassandra cluster. I am new to Cassandra and I don't have idea whether do I need to setup multiple nodes in a single machine by copying Cassandra configuration or do I require separate physical machines to create multipl

Re: Configuration of multiple nodes in a single machine

2013-12-02 Thread Kais Ahmed
You can try https://github.com/pcmanus/ccm 2013/12/2 Santosh Shet > Hi, > > > > I have requirement to setup multiple nodes to the existing single node > Cassandra cluster. I am new to Cassandra and I don’t have idea whether do I > need to setup multiple nodes in a single machine by copying Ca

replica verification

2013-12-02 Thread chandra Varahala
Hello Team, I have cassandra cluster with 5 nodes with 1 replication factor initially. Now i changed to replication factor 3 and ran nodetool repair. Is there way i can verify that i have 3 replicas ? Thanks Chandra

Re: Data loss when swapping out cluster

2013-12-02 Thread Robert Coli
On Fri, Nov 29, 2013 at 6:36 PM, Anthony Grasso wrote: > In this case would it be possible to do the following to replace a seed > node? > With the quoted procedure, you are essentially just "changing the ip address of a node", which will work as long as you set auto_bootstrap:false in cassandra.

Table Creation Error

2013-12-02 Thread Charlie Andrews
Hi all, When I try to create a new table, I get the following error: cqlsh:userdata> CREATE TABLE "f6f5e6a90a90a7ebb69d84a3d6f807" (item_id uuid PRIMARY KEY); TSocket read 0 bytes This error means nothing to me, so I check the logs that were created and I get the error, ‘Cannot modify index na

Re: Cassandra shows java exceptions

2013-12-02 Thread Robert Coli
On Thu, Nov 28, 2013 at 8:47 AM, Nate McCall wrote: > I can reproduce this with the mx4j lib loaded by setting to max hint > window to 'empty': > max_hint_window_in_ms: > > I guess you could call this a bug, but given that it has 2 defaults, you > have to explicitly set this to empty in the conf

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 11:51 AM, Charlie Andrews < charlieandrews@gmail.com> wrote: > Has anyone ever seen this behavior before? > No. What version of Cassandra? Easiest fix is probably to dump-and-reload schema. =Rob

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
I am on version 2.0.2. Do you have any resources on how to dump and reload the schema? On Dec 2, 2013, at 2:52 PM, Robert Coli wrote: > On Mon, Dec 2, 2013 at 11:51 AM, Charlie Andrews > wrote: > Has anyone ever seen this behavior before? > > No. > > What version of Cassandra? Easiest fix i

Re: Recommended amount of free disk space for compaction

2013-12-02 Thread Robert Coli
On Thu, Nov 28, 2013 at 7:21 PM, Robert Wille wrote: > So here’s my question. If Cassandra only compacts one table at a time, > then I should be safe if I keep as much free space as there is data in the > largest table. If Cassandra can compact multiple tables simultaneously, > then it seems that

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews < charlieandrews@gmail.com> wrote: > I am on version 2.0.2. Do you have any resources on how to dump and reload > the schema? > I guess I should write a blog post on this guy, but the rough outline is : 1) echo "DESCRIBE KEYSPACE ;" | cqlsh >

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or is the keyspace schema separate from the data it describes? -Charlie On Dec 2, 2013, at 3:10 PM, Robert Coli wrote: > On Mon, Dec 2, 2013 at 11:54 AM, Charlie Andrews > wrote: > I am on version 2.0.2. Do you have any

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews < charlieandrews@gmail.com> wrote: > Maybe a stupid question, but doesn’t dropping a keyspace drop all data? Or > is the keyspace schema separate from the data it describes? > Lol, sorry, yes. You will have to restore the data from the automati

Re: Table Creation Error

2013-12-02 Thread Charlie Andrews
Just out of curiosity, what do you think occurred to cause this problem? I thought it was quite strange that I didn’t get a useable error since my experience with this project has always been pretty helpful errors. Thanks, Charlie On Dec 2, 2013, at 3:20 PM, Robert Coli wrote: > On Mon, Dec 2

Re: Table Creation Error

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 12:24 PM, Charlie Andrews < charlieandrews@gmail.com> wrote: > Just out of curiosity, what do you think occurred to cause this problem? I > thought it was quite strange that I didn’t get a useable error since my > experience with this project has always been pretty helpf

Re: sstable2json hangs for authenticated keyspace?

2013-12-02 Thread Robert Coli
On Fri, Nov 29, 2013 at 4:11 PM, Josh Dzielak wrote: > Having an issue with sstable2json. It appears to hang when I run it > against an SSTable that's part of a keyspace with authentication turned on. > Running it against any other keyspace works, and as far as I can tell the > only difference be

changing several things (almost) at once; is this the right order to make the changes?

2013-12-02 Thread Brian Tarbox
We're making several changes and I'd to confirm that our order of making them is reasonable. Right now we have 4 node system at replicationFactor=2 running 1.1.6. We've moving to a 6 node system at rf=3 running 1.2.12 (I guess). We think the order should be: 1) change to rf=3 and run repair on a

bin/cqlsh is missing cqlshlib

2013-12-02 Thread Ritchie Iu
Hello, I am trying to install and setup Cassandra on Fedora. So far I have successfully installed it using Yum by following the startup guide: http://www.datastax.com/documentation/cassandra/1.2/webhelp/index.html#cassandra/install/installRHEL_t.html My problem is that when I run bin/cqlsh, I

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Kumar Ranjan
Hey Folks, I have been using ccm for some time and it's pretty awesome tool to test out admin stuff. Now, I really want to test modeling data by trying to access ccm running cassandra using Thrift based pycassaShell client from remote hosts (not locally). My setup is like this: Lets say, private

Re: replica verification

2013-12-02 Thread Jason Wee
You could probably use one of these nodetool getendpoints- Print the end points that owns the key using cqlsh and desc keyspace; /Jason On Tue, Dec 3, 2013 at 12:16 AM, chandra Varahala < hadoopandcassan...@gmail.com> wrote: > Hello Team, > > > I have cassandra cluster with 5 nodes with

Re: bin/cqlsh is missing cqlshlib

2013-12-02 Thread Jason Wee
Check if you have the cqlshlib installed? For debian, it is located at /usr/share/pyshared/cqlshlib /Jason On Tue, Dec 3, 2013 at 5:42 AM, Ritchie Iu wrote: > Hello, > > I am trying to install and setup Cassandra on Fedora. So far I have > successfully installed it using Yum by following the s

Stack trace from a node during a repair

2013-12-02 Thread John Pyeatt
We are running a 6-node AWS EC2 (m1.large) cluster of cassandra 1.2.9 across three availability zones with Ec2Snitch and NetworkTopologyStrategy. One of our nodes was apparently sharing a physical box with another customer who was really hogging the IO. So we needed to bring the node up on a new e

Re: Stack trace from a node during a repair

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 2:59 PM, John Pyeatt wrote: > Caused by: java.io.IOException: Unable to create directory > /data-1/cassandra/data/SinglewireSupport/Binaries/backups > This is an exception directly from a core java method. The cause is 99.9% likely to be permissions. =Rob

Re: changing several things (almost) at once; is this the right order to make the changes?

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 1:08 PM, Brian Tarbox wrote: > We're making several changes and I'd to confirm that our order of making > them is reasonable. Right now we have 4 node system at replicationFactor=2 > running 1.1.6. > > We've moving to a 6 node system at rf=3 running 1.2.12 (I guess). > > We

Re: replica verification

2013-12-02 Thread Robert Coli
On Mon, Dec 2, 2013 at 8:16 AM, chandra Varahala < hadoopandcassan...@gmail.com> wrote: > I have cassandra cluster with 5 nodes with 1 replication factor initially. > Now i changed to replication factor 3 and ran nodetool repair. > Is there way i can verify that i have 3 replicas ? > Use "findrow

Re: bin/cqlsh is missing cqlshlib

2013-12-02 Thread Ritchie Iu
No, there is no cqlshlib found at /usr/share/pyshared/cqlshlib although it might because I'm using Fedora which isn't debian. I did a search and I've found that cqlshlib is in several locations: /opt_build/fc17/lib/cassandra/pylib/cqlshlib, /opt_build/fc17/lib/cassandra/pylib/cqlshlib, /usr/opt/

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Krishna Chaitanya
Hey why dont you try Datastax Opscenter? Its a cool Gui tool to start/stop/manage your cluster(even remotely) . It also provides administrative tools fr checking on the performance with vital statistics. Definitely worth it. On Dec 3, 2013 3:14 AM, "Kumar Ranjan" wrote: > Hey Folks, > > I have b

Re: 答复: How to configure linux service for Cassandra?

2013-12-02 Thread Michael Shuler
On 12/02/2013 03:43 PM, Kumar Ranjan wrote: > Hey Folks, > > I have been using ccm for some time and it's pretty awesome tool to test > out admin stuff. Now, I really want to test modeling data by trying to > access ccm running cassandra using Thrift based pycassaShell client from > remote hosts (

Exactly one wide row per node for a given CF?

2013-12-02 Thread onlinespending
Subject says it all. I want to be able to randomly distribute a large set of records but keep them clustered in one wide row per node. As an example, lets say I’ve got a collection of about 1 million records each with a unique id. If I just go ahead and set the primary key (and therefore the pa