Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new DESCRIBE KEYSPACES ; system sample mykeyspace test sample_new system_traces [root@CSL-simulation conf]# ../bin/sstableloader /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/SAMPLE_NEW/DATA_NEW/ -d

Re: unable to load data using sstableloader

2014-07-29 Thread Duncan Sands
Hi Akshay, On 29/07/14 09:14, Akshay Ballarpure wrote: Yes, I have created keyspaces, but still i am getting error. cqlsh:sample_new DESCRIBE KEYSPACES ; system sample mykeyspace test *sample_new* system_traces [root@CSL-simulation conf]# ../bin/sstableloader

Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Thanks Duncan for quick help now i am trying sstableloader but its not loading data...any suggestion ? [root@CSL-simulation conf]# ps -eaf | grep -i cass root 20322 1 0 Jul28 ?00:04:27 /usr/java/jdk1.7.0_60/bin/java -ea -javaagent:./../lib/jamm-0.2.5.jar

Re: unable to load data using sstableloader

2014-07-29 Thread Rahul Neelakantan
Is SStable loader being run on the same host as the Cassandra node 127.0.0.1 (I see your ring is made up of all loop back IPs). Rahul Neelakantan 678-451-4545 On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure akshay.ballarp...@tcs.com wrote: Thanks Duncan for quick help now i am trying

Re: unable to load data using sstableloader

2014-07-29 Thread Rahul Neelakantan
Sstabloader and Cassandra can't use the same network interface, clearly mentioned in the Cassandra documentation on DataStax. If you are running both Cassandra and SStableloader locally, you have to take some extra steps. Look at the post.

Re: Thrift vs CQL3 performance

2014-07-29 Thread Kumar Ranjan
Stick with cql3 going forward. Last i checked, there is no further dev on thrift. I had worked with Thrift based c* api for 2 years in Python based pycassa and experience was not very satisfactory. I had not done comparisions between pycassa and cql so cant say. Cql isvery simple any way.— Sent

Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread tsi
We are planning to migrate data from a Cassandra 1.2.5 to a new Cassandra 2.0.8 cluster with changed partitioner settings (1.2.5: org.apache.cassandra.dht.RandomPartitioner, 2.0.8: org.apache.cassandra.dht.Murmur3Partitioner). Restoring a snapshot via BulkLoader fails with error message

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread DuyHai Doan
Why don't you stay with random partitioner ? On Tue, Jul 29, 2014 at 2:30 PM, tsi thorsten.s...@t-systems.com wrote: We are planning to migrate data from a Cassandra 1.2.5 to a new Cassandra 2.0.8 cluster with changed partitioner settings (1.2.5: org.apache.cassandra.dht.RandomPartitioner,

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread tsi
We are moving our application to a plattform with this partitioner setting and as far as I know there is no way to specify a partitioner on keyspace level. -- View this message in context:

Re: Migration from Cassandra 1.2.5 to Cassandra 2.0.8 with changed partitioner settings

2014-07-29 Thread DuyHai Doan
No, I meant why don't you set the partitioner of 2.0.8 cluster to RandomPartitioner instead of Mumur3 ? On Tue, Jul 29, 2014 at 2:53 PM, tsi thorsten.s...@t-systems.com wrote: We are moving our application to a plattform with this partitioner setting and as far as I know there is no way to

Re: Thrift vs CQL3 performance

2014-07-29 Thread Vivek Mishra
Checkout differentiators between thrift n cql3. Storage engine is same but they differs in metadata. Prior to 2.0 it was mix of both. I would still suggest the same. Checkout earlier threads around map collection support, bulk loading, dynamic column support comparison b/w thrift and cql3. Ease of

Re: Authentication exception

2014-07-29 Thread Jeremy Jongsma
This is still happening to me; is there anything else I can check? All nodes have NTP installed, all are in sync, all have open communication to each other. But usually first thing in the morning, I get this auth exception. A little while later, it starts working. I'm very puzzled. On Tue, Jul

Re: nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Mark Reddy
Looks like you are running into this issue: https://issues.apache.org/jira/browse/CASSANDRA-7239 Mark On Tue, Jul 29, 2014 at 5:32 PM, Jeronimo de A. Barros jeronimo.bar...@gmail.com wrote: Hi everyone, After upgrade and clean install on a 5 nodes cluster: Datacenter: datacenter1

nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Jeronimo de A. Barros
Hi everyone, After upgrade and clean install on a 5 nodes cluster: Datacenter: datacenter1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID Rack UN 192.168.3.50 -123645 bytes 256

Re: nodetool status returning negative load values on 2.1.0-rc4

2014-07-29 Thread Jeronimo de A. Barros
Mark, Thank you. The initial_token: was commented and I didn't notice it. regards, Jero On Tue, Jul 29, 2014 at 1:37 PM, Mark Reddy mark.re...@boxever.com wrote: Looks like you are running into this issue: https://issues.apache.org/jira/browse/CASSANDRA-7239 Mark On Tue, Jul 29,

Measuring WAN replication latency

2014-07-29 Thread Rahul Neelakantan
Does anyone know of a way to measure/monitor WAN replication latency for Cassandra? For example I make a write to DC 1 of a multi DC setup using local_quorum , how long before that write is available for a read either locally in DC1 or remotely in DC2 using local_quorum. Rahul Neelakantan

Re: Measuring WAN replication latency

2014-07-29 Thread Robert Coli
On Tue, Jul 29, 2014 at 3:15 PM, Rahul Neelakantan ra...@rahul.be wrote: Does anyone know of a way to measure/monitor WAN replication latency for Cassandra? No. [1] =Rob [1] There are ways to do something like this task, but you probably don't actually want to do them. Trying to do them

Re: Measuring WAN replication latency

2014-07-29 Thread Laing, Michael
I saw this awhile back: With requests possibly coming in from either US region, we need to make sure that the replication of data happens within an acceptable time threshold. This lead us to perform an experiment where we wrote 1 million records in one region of a multi-region cluster. We then

Re: Measuring WAN replication latency

2014-07-29 Thread Rahul Neelakantan
Here is the use case ... The Cassandra ring is going to span 6 data centers. The client can write in any data center (the client is also in 6 DCs) and turn back around and read from any other data center for this I assume you will tell me to use each quorum for the writes, however that is going

bootstrapping new nodes on 1.2.12

2014-07-29 Thread Parag Patel
Hi, It's taking a while to boostrap a 13th node into a 12 node cluster. The average node size is about 1.7TB. At the beginning of today we were close to .9TB on the new node and 12 hours later we're at 1.1TB. I figured it would have finished by now because when I was looking on OpsCenter,

Re: unable to load data using sstableloader

2014-07-29 Thread Akshay Ballarpure
Yes Rahul, i didn't created any ring. just a stand alone setup (single node cluster) Issue got resolved after creating sstable file properly...i mean, Keyspace/ColumnFamily folder manually and keeping sstable file in it. Somehow java api is not creating column family folder under keyspace, did