I have a Cassandra Customers table which is going to keep a list of customers. Every customer has an address which is a list of standard fields: { CustomerName: "", etc..., Address: { street: ...

Just installed (copied over the app from the downloaded dmg) DevCenter 1.6 on my mac, running macOs Sierra 10.12.6 with jdk 8u152 installed. The application loads a UI (splash screen then a couple ...

I have been tasked to come up with a schema to store our application logs using Cassandra. I am quite new to Cassandra but from what I have read and learned so far, it could be the best approach fo...

There is a limit of displaying 1000 rows for the tables in Datastax Devcenter. Any reason for having this option? Because when queried as SELECT count(*) FROM tablename; the performance from Cass...

So far, I haven't found a place on Datastax documentation website that sums this up. Can I easily check the version some other way on a server?

I am not using Elasticssearch. I am trying to perform some database operations in cassandra using CQL. I am using threads. While running the code I am always getting the exception in thread after a...

To enhance read performance, I try to have fewer underlying SSTables with LCS, so I set sstable_size_in_mb to 1280MB as suggested by some articles, which pointed out that the 160MB default value wa...

I'm trying to get the number of key value pairs in a Cassandra column family. Following is the code I used. PreparedStatement statement = client.session .prepare("select count(*) from corpus.word...

This is a super basic question but it's actually been bugging me for days. Is there a good way to obtain the equivalent of a COUNT(*) of a given table in Cassandra? I will be moving several hundr...

Cassandra does not comply with ACID like RDBMS but CAP. So Cassandra picks AP out of CAP and leaves it to the user for tuning consistency. I definitely cannot use Cassandra for core banking transac...

I'm trying to access my Cassandra server through a CQLSH client to import a huge CSV file. I'm getting a module' object has no attribute 'parse_options error. I run the follow command: cqlsh XXX....

I am currently working on the Cassandra tutorials about data modeling. I cannot understand why whenever I try to run the cassandra service from the bin folder I receive the error: "Cassandra: co...

When importing datastax cassandra-driver(python) get the following error Error File "cassandra.py", line 1, in <module> from cassandra.cluster import Cluster File "/home/vagrant/cassandra....

I am trying to duplicate data in a cassandra nosql database for a school project using datastax ops center. From what I have read, there is three keywords: cluster, node, and datacenter, and from w...

In our company, we do one project and use apache, Cassandra. Until recently, we used an older driver. Yesterday, we tried to replace it with the latest 4.3.0. We connect to the database, everything...

I am using apache cassandra 3.x version. I am bit confused regarding when should I use decimal vs float types? Is there any specific use-cases/differences when should go for float or avoid deci...

I have a cassandra node at a machine. When I access cqlsh from the same machne it works properly. But when I tried to connect to it's cqlsh using "192.x.x.x" from another machine, I'm getting an e...

Suppose I had this table. CREATE TABLE keyspace.user_event ( user_name varchar, user_email varchar, event_type int, event_time timestamp, a varchar, b varchar, c varchar PRIMARY KEY ((user...

We have a Cassandra schema with more than 50 columns and we are inserting data into it from multiple data sources by transforming the data using Spark (Data frames not rdd). We are running into th...

I'm having trouble understanding / finding information about how various quorums are calculated in cassandra. Let's say I have a 16 node cluster using Network Topology Strategy across 2 data cente...

I am using spark-sql-2.4.1 with spark-cassandra-connector-2_11.jar I am trying to join to streaming datasets as below : Dataset<Row> companyInfo_df = company_info_df .select("companyInfo....

I am trying to filter a column of a dataframe read from oracle as below import org.apache.spark.sql.functions.{col, lit, when} val df0 = df_org.filter(col("fiscal_year").isNotNull()) When I do ...

We had DataStax Cassandra Community Server 3.0.2 installed on our boxes, got couple of keyspaces created and we migrated some data from our old DB to Cassandra (Aroudnd 10GB of data). While, that w...

I have a simple script to insert a new record into a Cassandra database. It works fine on my local machine, but I am getting timeout errors from the client when I moved the database to a remote mac...

DataStax cassandra core java drive is having a transitive dependencies on guava-19 (including latest DataStax) which is having a security vulnerable (CVE-2018-10237). To fix this when I tried exc...