Re: LTCS Strategy Resulting in multiple SSTables

if you are on Cassandra 2.2, it is probably this: https://issues.apache.org/jira/browse/CASSANDRA-10270 On Tue, Sep 15, 2015 at 4:37 AM, Saladi Naidu wrote: > We are using Level Tiered Compaction Strategy on a Column Family. Below > are CFSTATS from two nodes in same cluster, one node has 880 SS

Re: Getting intermittent errors while taking snapshot

Hi All. Granting complete-permissions to the keyspace-folder (/var/lib/cassandra/data/instamsg) fixed the issue. Now, multiple, successive snapshot-commands run to completion fine. sudo chmod -R 777 /var/lib/cassandra/data/instamsg

Re: Possible to restore ENTIRE data from Cassandra-Schema in one go?

Thanks Mam for the reply. I guess there is manual work needed to bring all the SSTables files into one directory, so doesn't really solve the purpose I guess. So, going the "vanilla" way might be simpler :) Thanks anyways for the help !!! Thanks and Regards, Ajay On Tue, Sep 15, 2015 at 11:34 A

Getting intermittent errors while taking snapshot

Hi All. Taking snapshots sometimes works, sometimes don't. Following is the stacktrace whenever the process fails :: ## ajay@ajay-HP-15-Notebook-PC:/var/lib/cassandra/data/instamsg$ nodetool -h localhost

[ANNOUNCE] Apache Gora 0.6.1 Release

Hi All, The Apache Gora team are pleased to announce the immediate availability of Apache Gora 0.6.1. What is Gora? Gora is a framework which provides an in-memory data model and persistence for big data. Gora supports persisting to column stores, key value stores, document stores and RDBMSs, and

Re: Possible to restore ENTIRE data from Cassandra-Schema in one go?

Havent used it.. but u can try SSTaable Bulk Loader: http://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsBulkloader_t.html regards Neha On Tue, Sep 15, 2015 at 11:21 AM, Ajay Garg wrote: > Hi All. > > We have a schema on one Cassandra-node, and wish to duplicate the > entire schema

Possible to restore ENTIRE data from Cassandra-Schema in one go?

Hi All. We have a schema on one Cassandra-node, and wish to duplicate the entire schema on another server. Think of this a 2 clusters, each cluster containing one node. We have found the way to dump/restore schema-metainfo at :: https://dzone.com/articles/dumpingloading-schema And dumping/rest

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Hi All. I re-established my server from scratch, and installed the 21x server. Now, cqlsh works right out of the box. When I had last setup the server, I had (accidentally) installed the 20x server on first attempt, removed it, and then installed the 21x series server. Seems that caused some hidd

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Hi Jared. Thanks for your help. I made the config-changes. Also, I changed the seed (right now, we are just trying to get one instance up and running) :: seed_provider: # Addresses of hosts that are deemed contact points. #

Seeing null pointer exception 2.0.14 after purging gossip state

Hi, I have cassandra 2.0.14 deployed and after following the method described in  Apache Cassandra™ 2.0 to clear the gossip state of the node in one of the dc of my cluster |   | |   |   |   |   |   | | Apache Cassandra™ 2.0Correcting a problem in the gossip state. | Version 2.0 | | | | View on d

LTCS Strategy Resulting in multiple SSTables

We are using Level Tiered Compaction Strategy on a Column Family. Below are CFSTATS from two nodes in same cluster, one node has 880 SStables in L0 whereas one node just has 1 SSTable in L0. In the node where there are multiple SStables, all of them are small size and created same time stamp. We

Re: Question: Gossip Protocol

On Mon, Sep 14, 2015 at 6:26 AM, Thouraya TH wrote: > Please, i ask if it is possible to change this periode, to three seconds ? > It's an unusual question to ask; in return I must ask "why do you want to change the gossip period?" The answer is "yes, if you are willing to recompile" : cassand

Re: Upgrade Limitations Question

On Wed, Sep 9, 2015 at 12:09 PM, Vasileios Vlachos < vasileiosvlac...@gmail.com> wrote: > In our case the restart bit has already been done. Do you know if it would > be a bad idea to create a new KS before all nodes have upgraded their > SSTables? > This particular case is probably fine. The rea

Re: cassandra-stress on 3.0 with column widths benchmark.

By default, stress runs stop after throughput has not improved after three runs. This functionality is a little difficult to figure out from the documentation, so take a look at (maybe even with a debugger attached): https://github.com/apache/cassandra/blob/cassandra-2.1/tools/stress/src/org/apache

Re: Question: Gossip Protocol

It is hard coded in Gossiper: https://github.com/apache/cassandra/blob/cassandra-2.1/src/java/org/apache/cassandra/gms/Gossiper.java#L83 What requirement are you trying to address by increasing this value? On Mon, Sep 14, 2015 at 8:26 AM, Thouraya TH wrote: > I find this information : > > The

Extremely high CPU load in new data center

I have a DC of 4 nodes that must be expanded to accommodate an expected growth in data. Since the DC is not using vnodes, we have decided to set up a new DC with vnodes enabled, start using the new DC, and decommission the old DC. Both DCs have 4 nodes. The idea is to add additional nodes to the n

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Is there a reason that you're setting listen_address and rpc_address to localhost? listen_address doc: "the Right Thing is to use the address associated with the hostname". So, set the IP address of this to eth0 for example. I believe if it is set to localhost then you won't be able to form a clus

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Hi All. Thanks for your replies. a) cqlsh does not work either :( b) Following are the parameters as asked :: listen_address: localhost rpc_address: localhost broadcast_rpc_address is not set. According to the yaml file :: # RPC address to broadcast to drivers and other Cassandra nodes. Thi

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Whoops, I accidentally pressed a hotkey and sent my message prematurely. Here's what netstat should look like with those settings: sudo netstat -apn | grep 9042 tcp6 0 0 0.0.0.0:9042:::*LISTEN 21248/java -Jared On 14 September 2015 at 16:09, Jared

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

I assume "@ Of node" is ethX's IP address? Has cassandra been restarted since changes were made to cassandra.yaml? The netstat output that you posted doesn't look right; we use settings similar to what you've posted. Here's what it looks like on one of our nodes. -Jared On 14 September 2015 at 1

Re: Importing data from SQL Server

If you have a csv, try Brian's cassandra-loader. It is a full featured c* java import program built with all the best practices for data loading and writes. https://github.com/brianmhess/cassandra-loader All the best, [image: datastax_logo.png] Sebastián Estévez Sol

Re: Importing data from SQL Server

I had to write my own, but not due to lack of support. I found I needed to preprocess the data before I put it into cassandra, you might find that beneficial. I only had 3 massive tables to worry about so it wasn't that much extra work to code it out - your case might be different if you have 50 t

Re: Importing data from SQL Server

Kevin Burton charter.net> writes: > > I have seen numerous posts on transferring data from MySql to Cassandra but have yet to find a good way to > transfer directly from a Microsoft SQL Server table to a Cassandra CF. Even better would be a method to take > as input the output of an arbitrary

Re: Question: Gossip Protocol

I find this information : The gossip process runs every second and exchanges state messages with up to three other nodes in the cluster. here http://docs.datastax.com/en/cassandra/2.0/cassandra/architecture/architectureGossipAbout_c.html Please, i ask if it is possible to change this periode,

Question: Gossip Protocol

Hi all, Please, the gossip procotol in cassandra is running every ... seconds ? Thank you so much for answers. Best Regards.

cassandra-stress where query with greater than operator

Hi All. I'm trying to set up cassandra load testing and came up with the next YAML config (https://gist.github.com/folex/d297cc8208a2e54a36d7) : keyspace: stress keyspace_definition: | CREATE KEYSPACE stress WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3}; table: messa

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

In cassanrda.yaml: listen_address:@ Of node rpc_address:0.0.0.0 brodcast_rpc_address:@ Of node 2015-09-14 11:31 GMT+01:00 Neha Dave : > Try > >cqlsh > > regards > Neha > > On Mon, Sep 14, 2015 at 3:53 PM, Ajay Garg wrote: > >> Hi All. >> >> We have setup a Ubuntu-14.04 server, and followed th

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Hi, Can you pass the parametrs listen_adress, rpc_adress and brodcast_rpc_adress from cassandra.yaml. 2015-09-14 11:23 GMT+01:00 Ajay Garg : > Hi All. > > We have setup a Ubuntu-14.04 server, and followed the steps exactly as > per http://wiki.apache.org/cassandra/DebianPackaging > > Installatio

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Try >cqlsh regards Neha On Mon, Sep 14, 2015 at 3:53 PM, Ajay Garg wrote: > Hi All. > > We have setup a Ubuntu-14.04 server, and followed the steps exactly as > per http://wiki.apache.org/cassandra/DebianPackaging > > Installation completes fine, Cassandra starts fine, however cqlsh does not >

Not able to cqlsh on 2.1.9 on Ubuntu 14.04

Hi All. We have setup a Ubuntu-14.04 server, and followed the steps exactly as per http://wiki.apache.org/cassandra/DebianPackaging Installation completes fine, Cassandra starts fine, however cqlsh does not work. We get the error :: ###

Test Subject

Testing simple content, as my previous email bounced :( -- Regards, Ajay

Re: Best strategy for hiring from OSS communities.

Hi Kevin, You can try --> https://twitter.com/Cassandra_Jobs Anyway, I saw your message and I imagine other people looking for a job right know did as well already. You can also try to spot people through Linkedin, a few companies contacted me that way too, it might work for you. Then you can al