Re: Got exception running Sqoop: org.apache.cassandra.db.marshal.MarshalException: 97 is not recognized as a valid type, while importing data from mysql to cassandra using sqoop

2012-08-03 Thread Abhijit Chanda
Hey Rajesh, For better response put this question in Datastax support forum * http://www.datastax.com/support-forums/forum/datastax-enterprise* Regards, Abhijit

Re: Unsuccessful attempt to add a second node to a ring.

2012-08-03 Thread Roshni Rajagopal
Hi Jakub, Were you able to resolve the issue? For a multi data center setup I do believe some steps are different. You may need to set Networktopology as your replication strategy rather than simple strategy, and setup a snitch. And mention the rack/dc configurations in a config file. You can

Changing comparator

2012-08-03 Thread Christof Roduner
Hi, I know that changing a CF's comparator is not officially supported. However, there is a post by Jonathan Ellis that implies it can be done (www.mail-archive.com/user@cassandra.apache.org/msg09502.html). I assume that we'd have to change entries in the system.schema_* column families.

Re: Changing comparator

2012-08-03 Thread Roshni Rajagopal
Christof , can't you just use ASSUME for the CQL session? http://www.datastax.com/docs/1.0/references/cql/ASSUME Regards, Roshni On 03/08/12 2:26 PM, Christof Roduner chris...@scandit.com wrote: Hi, I know that changing a CF's comparator is not officially supported. However, there is a

Re: Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

2012-08-03 Thread Omid Aladini
I think the 1.0.6 nodes can't join (on a restart, for example) the ring in a mixed cluster. So you can either continue the rolling upgrade, or if you want to keep running in mixed mode (why?) you can use 1.0.11 for the older ones, but you won't be able to do schema migrations. -- Omid On Fri,

Re: Changing comparator

2012-08-03 Thread Christof Roduner
Hi Roshni, Thanks for your reply. As far as I know, ASSUME is only for cqlsh and not for CQL in general. (We can of course achieve the same by programmatically setting the encoding. It would be just simpler to let the CQL driver take care of it...) Regards, Christof On 8/3/2012 11:31 AM,

Re: Unsuccessful attempt to add a second node to a ring.

2012-08-03 Thread Jakub Glapa
Hi Roshni, I was just about to summarize. I got it running. The problem eventually was the firewall. I didn't have the full control over the server so I couldn't check the iptables rules. The incoming traffic on 7000 port was rejected on the second node. I've just checked one way communication

How to process new rows in parallel?

2012-08-03 Thread Philip Nelson
Hello, I am using a Column Family in Cassandra to store incoming messages, which arrive at a high rate (100s of thousands per second). I then have a process wake up periodically to work on those messages, and then delete them. I'd like to understand how I could have multiple processes running,

Re: How to process new rows in parallel?

2012-08-03 Thread Brian O'Neill
If you are deleting the messages after processing, it sounds like you are using Cassandra as a work queue. Here are some links for implementing a distributed queue in Cassandra: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Distributed-work-queues-td5226248.html

Re: How to process new rows in parallel?

2012-08-03 Thread Philip Nelson
Brian -- thanks. We were looking to do the same thing, but in the end decided to go with Kafka. Given your throughput requirements, Kafka might be a good option for you as well. This might be off-topic, so I'll keep it short. Kafka is reasonably stable? Mature (I see it's in the Incubator)?

Re: How to process new rows in parallel?

2012-08-03 Thread Milind Parikh
Kafka is relatively stable and has a active well-supported news-group as well. As discussed by Brian, you would be inverting the paradigm of store-process. Essentially in your original approach, you are storing the messages first and then processing them after the fact. In the Kafka model, you

Re: RE Restore snapshot

2012-08-03 Thread Tyler Hobbs
On Thu, Aug 2, 2012 at 6:14 AM, Romain HARDOUIN romain.hardo...@urssaf.frwrote: Then http://www.datastax.com/docs/1.1/operations/backup_restore should mention it :-) I opened a ticket with our docs team to cover that. Thanks! -- Tyler Hobbs DataStax http://datastax.com/

Re: How to create a COLUMNFAMILY with Leveled Compaction?

2012-08-03 Thread Data Craftsman 木匠
Nobody use Leveled Compaction with CQL 3.0 ? -Z On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman 木匠 database.crafts...@gmail.com wrote: Sorry for my stupid simple question. How to create a COLUMNFAMILY with Leveled Compaction? There is no example in documentation:

Node doesn't rejoin ring after restart

2012-08-03 Thread Edward Sargisson
Hi all, I'm testing our procedures for handling some Cassandra failure scenarios and I'm not understanding something. I'm testing on a 3 node cluster with a replication_factor of 3. I stopped one of the nodes for 5 or so minutes and run some application tests. Everything was fine. Then I