Re: Unable to connect via cqlsh or datastax-driver

2015-05-05 Thread Anishek Agarwal
did u setup CQLSH_HOST variable to the ip so cqlsh uses that ? On Tue, May 5, 2015 at 8:50 PM, Björn Hachmann wrote: > Hello, > > I am unable to connect to the nodes of our second datacenter, not even > from localhost. > > The error message I receive is: > > Connection error: ('Unable to connect

Hive support on Cassandra

2015-05-05 Thread Ajay
Hi, Does Apache Cassandra (not DSE) support Hive Integration? I found couple of open source efforts but nothing is available currently. Thanks Ajay

Re: bulk uploading

2015-05-05 Thread C.B.
I would like do live migration instead of offline bulk load. You can make 3-node old cluster as dc1, the 5-node new cluster as dc2, then "nodetool rebuild dc1" on dc2, in this way, you don't need to take down the cluster to maintain consistency. On 5/5/15 11:04 AM, Robert Coli wrote: On Tu

Re: bulk uploading

2015-05-05 Thread Robert Coli
On Tue, May 5, 2015 at 1:22 AM, Rahul Bhardwaj wrote: > Hi All, > > We have a cassandra cluster of 3 machines, which has a table containing 50 > millions of rows. We are making a new cluster of 5 nodes and we want to > migrate this table to the new cluster. > > > Please suggest what would be the

Unable to connect via cqlsh or datastax-driver

2015-05-05 Thread Björn Hachmann
Hello, I am unable to connect to the nodes of our second datacenter, not even from localhost. The error message I receive is: Connection error: ('Unable to connect to any servers', {'...': OperationTimedOut('errors=None, last_host=None',)}) I already checked some things: - The node starts

Re: Multiple Cluster vs Multiple DC

2015-05-05 Thread Anuj Wadehra
Multiple DC is usually useful in case u need Geo Redundancy or have distributed workload. Do u have these clusters at same physical location? If 3 nodes are at diff locations dont u need geo red for disaster ? Whats ur RF for cf?  Thanks Anuj Sent from Yahoo Mail on Android From:"Alain RODR

Multiple Cluster vs Multiple DC

2015-05-05 Thread Alain RODRIGUEZ
Hi, tl;dr : How to choose between having a Cluster with 2 DC and having 2 separate clusters as follow: "cluster_name: mycluster KS1 {DC1: 3, DC2: 0} and KS2 {DC1: 0, DC2: 3}" OR "cluster_name: cluster1 KS1 {DC: 3} + cluster_name: cluster2 KS2 {DC: 3}" We can use distinct columns and row to kee

bulk uploading

2015-05-05 Thread Rahul Bhardwaj
Hi All, We have a cassandra cluster of 3 machines, which has a table containing 50 millions of rows. We are making a new cluster of 5 nodes and we want to migrate this table to the new cluster. Please suggest what would be the best and least time taking process. I know we can use sstable loader