Query on how to count the total number of rowkeys and columns in them

to count the keys if I don't know the actual number of keys in my Cassandra database? Please help me Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary, private and confidential information

Doubt in Row key range scan

to 1_2012/05/24, then I got all the keys even which are not in my range like 67_2012/05/23 and 54_2012/05/28. I am using Thrift API. Please help me as I want only the columns of 1_2012/05/24, 1_2012/05/25 , 1_2012/05/26 and 1_2012/05/27. Prakrati Agrawal | Developer - Big Data(ID)| 9731648376

RE: Doubt in Row key range scan

Please could you tell me how to tweak my data model to rely on 2nd index ? Thank you Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Pierre Chalamet [mailto:pie...@chalamet.net] Sent: Monday, May 28, 2012 3:31 PM To: user@cassandra.apache.org Subject: Re: Doubt

Can not find auto bootstrap property in cassandra.yaml for Cassandra 1.1.0

Dear all I am trying to add a new node to the Cassandra cluster. In all the documentations available on net it says to set the auto bootstrap property in cassandra.yaml to true but I am not finding the property in the file. Please help me Thanks and Regards Prakrati Agrawal | Developer - Big

Getting error on adding seed to add a new node

Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which it is addressed. Any

Finding whether a new node is successfully added or not

Dear all, I added a new node to my 1 node Cassandra cluster. Now I want to find out whether it is added successfully or not. Also do I need to restart the already running node after entering the seed value. Please help me. Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID

Adding a new node to Cassandra cluster

me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which

RE: Adding a new node to Cassandra cluster

Hi, I am using Thrift API and I am not able to find anything on the internet about how to configure it for multiple nodes. I am not using any proper client like Hector. Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: R. Verlangen [mailto:ro...@us2.nl] Sent

RE: Adding a new node to Cassandra cluster

Ye I know I am trying to reinvent the wheel but I have to. The requirement is such that I have to use Java Thrift API without any client like Hector. Can you please tell me how do I do it. Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: samal [mailto:samalgo

Which client to use for Cassandra real time insertion and retrieval

Dear all, I am trying to explore Cassandra for real time applications. Can you please suggest me which client is the best to use ? Is the client choice based on the user 's comfort level or on use cases. Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu

How to configure the Cassandra connection using Hector

Dear all, I am writing a java code using Hector but when I am configuring the already created key space using HFactory.createKeySpace its giving me the error Null Point Exception. What am I doing wrong. Please help me. Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376

RE: How to configure the Cassandra connection using Hector

cluster = HFactory.getCluster(Test Cluster); keySpace = HFactory.createKeyspace(mstream, cluster); These are the lines that I am executing and getting an error Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Harshvardhan Ojha [mailto:harshvardhan.o

RE: How to configure the Cassandra connection using Hector

Thank you all for the quick response :) Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: MOHD ARSHAD SALEEM [mailto:marshadsal...@tataelxsi.co.in] Sent: Tuesday, June 05, 2012 3:07 PM To: user@cassandra.apache.org Subject: RE: How to configure the Cassandra

How to include two nodes in Java code using Hector

Dear all I am using a two node Cassandra cluster. How do I code in Java using Hector to get data from both the nodes. Please help Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain

RE: How to include two nodes in Java code using Hector

But the data is distributed on the nodes ( meaning 50% of data is on one node and 50% of data is on another node) so I need to specify the node ip address somewhere in the code. But where do I specify that is what I am clueless about. Please help me Prakrati Agrawal | Developer - Big Data(ID

Removing a node in cluster

Dear all I am trying to check the performance of Cassandra on adding or removing nodes. I want to know what happens to my existing data if I remove a node ? Please help me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com

RE: How to include two nodes in Java code using Hector

Thank you for the reply. Now I have decommissioned a node but now I don't know how to recommission it .Please help me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com -Original Message- From: Roshni Rajagopal [mailto:roshni.rajago...@wal

How to make a decommissioned node join the ring again

Dear all I decommissioned a node. Now I want to make that node a part of the ring again. How do I do it? Please help me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary

RE: how to create keyspace using cassandra API's

You have to create the keyspace manually first using Cassandra cli Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: MOHD ARSHAD SALEEM [mailto:marshadsal...@tataelxsi.co.in] Sent: Wednesday, June 06, 2012 2:27 PM To: user@cassandra.apache.org Subject: how

Cassandra not retrieving the complete data on 2 nodes

is 52793 Time taken to count is 268135 Total number of rows in the database are 396 Total number of columns in the database are 16316426 Please help me. Where is my data going or how should I retrieve it. Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu

Why Hector is taking more time than Thrift

? If yes, then why are we using Hector and not Thrift? Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary, private and confidential information. The information transmitted

RE: Cassandra not retrieving the complete data on 2 nodes

Please anyone reply to my query Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Prakrati Agrawal [mailto:prakrati.agra...@mu-sigma.com] Sent: Wednesday, June 06, 2012 2:34 PM To: user@cassandra.apache.org Subject: Cassandra not retrieving the complete data on 2

Problem in getting data from a 2 node cluster

I decommission my node and then add it again I get the following message. This node will not auto bootstrap because it is configured to be a seed node Please tell me the meaning of it also Thanks and Regards Prakrati Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com

RE: Problem in getting data from a 2 node cluster

What does repair do? Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: R. Verlangen [mailto:ro...@us2.nl] Sent: Wednesday, June 06, 2012 3:56 PM To: user@cassandra.apache.org Subject: Re: Problem in getting data from a 2 node cluster Did you run repair on the new

RE: Problem in getting data from a 2 node cluster

Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Prakrati Agrawal [mailto:prakrati.agra...@mu-sigma.com] Sent: Wednesday, June 06, 2012 3:55 PM To: user@cassandra.apache.org Subject: RE: Problem in getting data from a 2 node cluster What does repair do? Prakrati Agrawal

RE: Problem in getting data from a 2 node cluster

Yes I ran nodetool repair also. Still the same problem I am getting lesser data when using my code on a 2 node cluster. Please help me Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: R. Verlangen [mailto:ro...@us2.nl] Sent: Wednesday, June 06, 2012 4:01 PM

RE: Problem in getting data from a 2 node cluster

I even used CassandraHostConfigurator and added a string of hosts but still the same issue. Please someone help me Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Prakrati Agrawal [mailto:prakrati.agra...@mu-sigma.com] Sent: Wednesday, June

RE: Problem in getting data from a 2 node cluster

issue 2. Used nodetool repair on both the nodes - Still same issue Please help me out. I am badly stuck Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Prakrati Agrawal [mailto:prakrati.agra...@mu-sigma.com] Sent: Wednesday, June 06

RE: Problem in getting data from a 2 node cluster

What is the default replication factor? I did not set any replication factor. Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com -Original Message- From: Tim Wintle [mailto:timwin...@gmail.com] Sent: Wednesday, June 06, 2012 5:42 PM To: user@cassandra.apache.org

RE: Cassandra not retrieving the complete data on 2 nodes

I have specified the consistency level as 1 Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Poziombka, Wade L [mailto:wade.l.poziom...@intel.com] Sent: Wednesday, June 06, 2012 11:11 PM To: user@cassandra.apache.org Subject: RE: Cassandra not retrieving

RE: Cassandra not retrieving the complete data on 2 nodes

I was told that the node bootstraps automatically in 1.1.0 version of Cassandra. Please help me how to rectify the mistake Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Tyler Hobbs [mailto:ty...@datastax.com] Sent: Wednesday, June 06, 2012 11:45 PM To: user

Problem in getting data from a 2 node cluster of Cassandra

. Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com This email message may contain proprietary, private and confidential information. The information transmitted is intended only for the person(s) or entities to which it is addressed. Any

Not getting all data from a 2 node cluster

Dear all I am using Cassandra to retrieve a number of rows and columns stored in it. Initially I had a 1 node cluster and I flooded it with data. I ran a Hector code to retrieve data from it I got the following output: Total number of rows in the database are 396 Total number of columns in the

Problem in adding a new node

Dear all, I had a 1 node cluster of Cassandra. Then I added one more node to it and started Cassandra on it. I got the following error: INFO 12:44:49,588 Loading persisted ring state ERROR 12:44:49,613 Exception in thread Thread[COMMIT-LOG-ALLOCATOR,5,main] java.io.IOError: java.io.IOException:

RE: Problem in adding a new node

in that (cassandra.yaml file)give the ip address of 1st node in seeds option. Regards Arshad From: Prakrati Agrawal [prakrati.agra...@mu-sigma.com] Sent: Friday, June 08, 2012 12:44 PM To: user@cassandra.apache.org Subject: Problem in adding a new node Dear all, I

Out of memory error

Dear all, When I try to list the entire data in my column family I get the following error: Using default limit of 100 Exception in thread main java.lang.OutOfMemoryError: Java heap space at org.apache.thrift.transport.TFramedTransport.readFrame(TFramedTransport.java:140)

Time taken to retrieve data from a 2 node cluster is more than 1 node cluster

Dear all Initially I had a one node cluster and I flooded my data into it. I then ran my Hector code to get some rows and columns. It took around 52.793 seconds. Then I added one more node to the cluster. I again ran the same code and it took around 112.065 seconds. Cassandra should perform

RE: Time taken to retrieve data from a 2 node cluster is more than 1 node cluster

, but should not be slow (unless u also doubled the data)... On Fri, Jun 8, 2012 at 2:41 PM, Prakrati Agrawal prakrati.agra...@mu-sigma.com wrote: Dear all Initially I had a one node cluster and I flooded my data into it. I then ran my Hector code to get some rows and columns. It took around

RE: Out of memory error

On 8/06/2012, at 9:04 PM, Prakrati Agrawal wrote: Dear all, When I try to list the entire data in my column family I get the following error: Using default limit of 100 Exception in thread main java.lang.OutOfMemoryError: Java heap space

RE: Out of memory error

The version is 1.1.0 Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: Dave Brosius [mailto:dbros...@mebigfatguy.com] Sent: Monday, June 11, 2012 10:07 AM To: user@cassandra.apache.org Subject: Re: Out of memory error What version of Cassandra? might be related

Effective ownership on both nodes 0 %

Dear all I have a Cassandra cluster with 2 nodes. I was trying to increase the replication factor of keyspace in Cassandra to 2. I did the following steps: UPDATE KEYSPACE demo WITH strategy_options = {DC1:2,DC2:2}; on both the nodes Then I ran the nodetool repair on both the nodes Then I ran my

Why cassandra nodes ownership is 0.00%

Dear all I have a Cassandra cluster with 2 nodes. I am using NetworkTopologyStrategy. I was trying to increase the replication factor of keyspace in Cassandra to 2. I did the following steps: UPDATE KEYSPACE demo WITH strategy_options = {DC1:2,DC2:2}; on both the nodes Then I ran the nodetool

Hector code not running when replication factor set to 2

Dear all I had a 2 node cluster with replication factor set to 1. Then I changed the replication factor to 2 and brought down one node so that only 1 node was up and running. Then I ran my Hector code on the running node. But it gave me Unavailable Exception. I also had a Thrift code which ran

RE: Hector code not running when replication factor set to 2

and replication factor were you using ? UnavailableException is thrown when less the consistency level nodes are UP. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/06/2012, at 10:19 PM, Prakrati Agrawal wrote: Dear all I had a 2 node

RE: Hector code not running when replication factor set to 2

stack you got ? What does node tool ring look look from the node you connected to? Did you notice any errors in the logs on the machine you connected to ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/06/2012, at 8:41 PM, Prakrati

RE: Hector code not running when replication factor set to 2

How do I verify that I am using a wrong consistency level? Thanks and Regards Prakrati Agrawal | Developer - Big Data(ID)| 9731648376 | www.mu-sigma.com From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Wednesday, June 13, 2012 2:38 PM To: user@cassandra.apache.org Subject: Re: Hector

How to use row caching to enable faster retrieval of rows in Cassandra

Dear all, I am trying to understand whether I can fasten the retrieval process using cache. Please can you help me write the code for setting the cache properties in Cassandra. Please help Thanks and Regards Prakrati This email message may contain