A trigger that modifies the current Mutation

2014-09-27 Thread Pinak Pani
Hi, I wanted to create a trigger that alters the current mutation. For example, I wanted to, say, iterate through the ColumnFamily in augment method and look for all the fields that are of type text or varchar and change them to upper case. I am not sure how to do that. Can someone help me? Basic

How to enable client-to-node encrypt communcation?

2014-09-27 Thread Lu, Boying
Hi, All, I want to enable client-to-node encrypt communication, I read some related documents. I need to set the following changes in the server side (in yaml): client_encryption_opitons: enabled : true keystore: conf/.keystore keystore_password: some-password truststore: conf/.trustst

Re: paging through an entire table in chunks?

2014-09-27 Thread Kevin Burton
Agreed… but I’d like to parallelize it… Eventually I’ll just have too much data to do it on one server… plus, I need suspend/resume and this way if I’m doing like 10MB at a time I’ll be able to suspend / resume as well as track progress. On Sat, Sep 27, 2014 at 2:52 PM, DuyHai Doan wrote: > Use

Re: paging through an entire table in chunks?

2014-09-27 Thread DuyHai Doan
Use the java driver and paging feature: http://www.datastax.com/drivers/java/2.1/com/datastax/driver/core/Statement.html#setFetchSize(int) 1) Do you "SELECT * FROM" without any selection 2) Set fetchSize to a sensitive value 3) Execute the query and get an iterator from the ResultSet 4) Iterate

paging through an entire table in chunks?

2014-09-27 Thread Kevin Burton
I need a way to do a full table scan across all of our data. Can’t I just use token() for this? This way I could split up our entire keyspace into say 1024 chunks, and then have one activemq task work with range 0, then range 1, etc… that way I can easily just map() my whole table. and since it’

Re: Apache Cassandra 2.1.0 : cassandra-stress performance discrepancy between SSD and SATA drive

2014-09-27 Thread Shing Hing Man
Hi Kevin, Thanks for the reply ! I do not know the exact brand of SSD in my office PC. But the SSD is only 1 year old, and it is far from full. On both of office PC and home PC, I untared Apache Cassandra 2.1.0 and then run "cassandra -f " with the default config, then