Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread 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 the steps exactly as > per http://wiki.apache.org/cassandra/DebianPackaging > > Installation completes fine, Cassandra starts fine,

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Ahmed Eljami
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

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Ahmed Eljami
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

cassandra-stress where query with greater than operator

2015-09-14 Thread folex
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:

Question: Gossip Protocol

2015-09-14 Thread Thouraya TH
Hi all, Please, the gossip procotol in cassandra is running every ... seconds ? Thank you so much for answers. Best Regards.

Re: Question: Gossip Protocol

2015-09-14 Thread Thouraya TH
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,

Re: Importing data from SQL Server

2015-09-14 Thread Raluca Marcu
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

Re: Importing data from SQL Server

2015-09-14 Thread Jason Kushmaul
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

Re: Importing data from SQL Server

2015-09-14 Thread Sebastian Estevez
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

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Jared Biel
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

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Ajay Garg
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.

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Jared Biel
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

Re: Question: Gossip Protocol

2015-09-14 Thread Nate McCall
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

Re: Upgrade Limitations Question

2015-09-14 Thread Robert Coli
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

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

2015-09-14 Thread Nate McCall
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):

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Ajay Garg
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

Seeing null pointer exception 2.0.14 after purging gossip state

2015-09-14 Thread K F
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

Re: Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread Ajay Garg
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.

Re: Question: Gossip Protocol

2015-09-14 Thread Robert Coli
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

LTCS Strategy Resulting in multiple SSTables

2015-09-14 Thread Saladi Naidu
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.

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

2015-09-14 Thread Ajay Garg
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

Extremely high CPU load in new data center

2015-09-14 Thread Tom van den Berge
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

Re: Best strategy for hiring from OSS communities.

2015-09-14 Thread Alain RODRIGUEZ
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

Test Subject

2015-09-14 Thread Ajay Garg
Testing simple content, as my previous email bounced :( -- Regards, Ajay

Not able to cqlsh on 2.1.9 on Ubuntu 14.04

2015-09-14 Thread 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 Installation completes fine, Cassandra starts fine, however cqlsh does not work. We get the error ::