Connect Cassandra to Power BI desktop

2018-07-16 Thread VAN HOLLEBEKE Emeric (SAFRAN CERAMICS)
I would connect a Cassandra database to Power BI, I have seen on Internet that requires an ODBC driver. Is it possible to connect the database to the software without using a driver ? Thank you, Emeric VAN HOLLEBEKE. # " Ce courriel et les documents qui lui sont joints peuvent contenir des inf

Re: Limitations of Hinted Handoff OverloadedException exception

2018-07-16 Thread kurt greaves
The coordinator will refuse to send writes/hints to a node if it has a large backlog of hints (128 * #cores) already and the destination replica is one of the nodes with hints destined to it. It will still send writes to any "healthy" node (a node with no outstanding hints). The idea is to not fur

New cluster vs Increasing nodes to already existed cluster

2018-07-16 Thread onmstester onmstester
Currently i have a cluster with 10 nodes dedicated to one keyspace (Hardware sizing been done according to input rate and ttl just for current application requirements). I need a launch a new application with new keyspace with another set of servers (8 nodes), there is no relation between the cu

RE: [EXTERNAL] New cluster vs Increasing nodes to already existed cluster

2018-07-16 Thread Durity, Sean R
In most cases, we separate clusters by application. This does help with isolating problems. A bad query in one application won’t affect other applications. Also, you can then scale each cluster as required by the data demands. You can also upgrade separately, which may be a huge help. You only

Cassandra Repair

2018-07-16 Thread rajasekhar kommineni
Hello All, I have all cluster nodes in Cloud, and there is very rare chance for nodes going down. I want to prepare repair strategy to my cluster, so need inputs on any calculations to decide when to go for repair. Also let me know if my statement is correct or not "It’s not only node down

Re: Bind keyspace to specific data directory

2018-07-16 Thread Anthony Grasso
Hi Abdul, There is no mechanism offered in Cassandra to bind a keyspace (when created) to specific filesystem or directory. If multiple filesystems or directories are specified in the data_file_directories property in the *cassandra.yaml* then Cassandra will attempt to evenly distribute data from

How to further compress Data in Cassandra.

2018-07-16 Thread Pranay akula
Hi, I am using default LZ4Compressor, how can i further compress the data ?? Does switching to SnappyCompressor, or DeflateCompressor helps is there any comparison metrics available ?? Has anyone implemented any new compression types which can reduce data, i am using Cassandra 3.11.x Than