Questions tagged [cassandra-2.0]

Cassandra 2.0 is a NoSQL database sponsored by Apache.

Filter by
Sorted by
Tagged with
1
vote
1answer
37 views

Data is replicated/copied on my 2nd node even with a replication factor of 1 for the key-space

I have a Cassandra cluster of 3 nodes and I create a keyspace 'abcd' using SimpleStrategy and ReplicationFactor 1. Since I have chosen RF as 1, I assume that any writes to my node-1 should not be ...
0
votes
0answers
18 views

How can I iterate each key-value of multiple row and multiple column using MultigetSliceQuery in cassandra

MultigetSliceQuery<String, String, String> multigetSliceQuery = HFactory.createMultigetSliceQuery(ksp,ss,ss,ss); multigetSliceQuery.setColumnFamily(CF); multigetSliceQuery.setKeys(...
1
vote
1answer
63 views

IP swapping in Cassandra cluster

We have healthy running 3 nodes cassandra cluster but we need to swap all 3 nodes IP address due to some issue. So basically, we want to swap old cassandra server IP address from to new cassandra ...
0
votes
1answer
25 views

Cassandra TLP-Stress Tarball Installation

I have just downloaded tarball tlp-stress for cassandra and extracted and found some jars. what the next step to run stress test? Thanks.
0
votes
0answers
33 views

Unable to compute ceiling for max when histogram overflowed

When I am trying to run select query without where clause on a cassandra table, it is throwing an error Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 3.11.3 | CQL spec 3.4.4 | ...
0
votes
0answers
13 views

what should be the optimum value of max_schema_agreement_wait in cassandra, by default it is 10

what should be the optimum value of max_schema_agreement_wait in cassandra cluster, by default it is 10. Most of the time I'm getting this error while schema creation: "2019-07-29 21:26:32,003 ERROR ...
0
votes
1answer
11 views

What if all mention contact points go down after successful connection to the cluster?

I have 3 node Cassandra cluster.I have put only one contact point as the part of the initialization. What will happen if it goes down after successful connection to the cluster. I still have 2 more ...
0
votes
1answer
9 views

how to make a non-partition field of a table mandatory in Cassandra

How do I make a non-partition field of the table mandatory in Cassandra? I can't find anything in the documentation unfortunately
1
vote
1answer
20 views

Why is the ResultSet not same for insert and select queries

When I use session.execute in cassandra, I notice that the ResultSet's structure is different for the same table. If I am querying the table to get a record using Where, the ResultSet contains the ...
0
votes
1answer
16 views

unable to store base64 image data in Cassandra using cassandra driver

My client application sends image data to my controller using base64 encoding which I suppose is a string of characters. I parse the json into the following case class case class PQ(id: Option[UUID]...
0
votes
0answers
16 views

How to use CassandraTemplate.update() to implement UPDATE IF

currently I am using Spring Cassandra to do update in the database, I have a requirement like this, I have one table with two primary keys - id and name, then I have three columns which are static - ...
0
votes
2answers
40 views

How can i update the column to a particular value in a cassandra table?

Hi I am having a cassandra table. my table has around 200 records in it . later i have altered the table to add a new column named budget which is of type boolean . I want to set the default value to ...
0
votes
0answers
4 views

Generate table from Cassandra-Spark connector

I hope to generate a table with two columns (sku_id, seo)from Cassandra. I have already connected Cassandra with Spark and query some information from Cassandra. The 'seo' itself is json format with ...
0
votes
1answer
39 views

DataStax DevCenter Schema window is empty

After a successful connection, the Schema window in my DataStax DevCenter is always empty. There are no keyspaces. But it's wrong. I can see the keyspaces and tables on the server using cqlsh. I have ...
1
vote
1answer
32 views

Database synchronization time in cassandra

I have two controllers accessing distributed database. I am receiving some data from a device to the controllers and i store them in Cassandra database. I use Docker to install cassandra The node 1 ...
0
votes
1answer
19 views

Storing Values into cassandra using python

I am storing the json i get from a file into cassandra. But i would like to increment the id everytime i get new data and now it is overwriting the existing data. I expect result to be as shown below. ...
0
votes
1answer
30 views

major compaction on LCS

I have table with LCS in Cassandra cluster. I am observing too may tombstones in my cluster so I have decided to reduce GC grace seconds and performing major compaction. Ran nodetoolcompact keyspace ...
2
votes
1answer
30 views

If I give row_cache_size_in_mb =5Gb in cassandra.yaml file, does cassandra reserves 5GB from Heap Memory?

I am running my cassandra cluster having memory 32 GB on each node, And row cache capacity (row_cache_size_in_mb) 5GB, Just want to know, does 5gb memory ram is reserved for row caching from my heap??...
0
votes
1answer
44 views

Pagination in cassandra with Spring-data

I'm trying to get paginated results in cassandra using springboot, but I'm not getting desired results. Here is my code. Slice<User> usersByNameSlice = userRepository.findAll(...
2
votes
1answer
38 views

Cassandra driver querying with multiple keys

I'm trying to query cassandra from a c++ application, and return the values for a set of keys. I am using the datastax driver described here: http://datastax.github.io/cpp-driver/api/ The cassandra ...
0
votes
0answers
20 views

In Cassandra source, why is StorageProxy.beginAndRepairPaxos() called twice?

In Cassandra source, why is StorageProxy.beginAndRepairPaxos() called twice? - once at the begining of cas() and then again immediately after from within read()?
0
votes
0answers
15 views

What could cause a Cassandra table to accept insert statements from an ALTERED column name?

I alter a primary key column in DevCenter, but the database still accepts data from an insert statement with the old column name. I'm avoiding alter for the time being doing it the old fashion way of ...
0
votes
1answer
38 views

Converting string to date and using query greater than operator is not working as expected in cassandra

I am using cassandra 2.2.3 and below is my table structure to store doj as date object. Table structure: class Emp{ String name Date doj } empdata: id name ...
0
votes
0answers
39 views

Support netty openssl (netty-tcnative) for client encryption

I tried upgrading my driver to 4.0 with SSL and getting below exception. Truststore is valid becaise if i change password, it gives me authentication error. I believe either it needs socket timeout ...
0
votes
0answers
27 views

How to index list of user defined data type as a frozen on table “list<frozen<UDT>>”?

I have table contains column as foos list<frozen <foo>>, Let foo is defined as foo CREATE TYPE api.foo ( arrival_date_time text, carrier_iata text, carrier_id text, ...
0
votes
1answer
20 views

Maximum number of Partition in a Cassandra Table and How it depends on Disk space?

I am using Cassandra DB, i want to know what could be the maximum number of partitions that can be made ? Will more number of partition impact on the performance of Cassandra ? how number of ...
0
votes
2answers
50 views

How DSE Spread Data?

We using DSE with Cassandra + Solr. I'm not sure how it's spreading the data, let's say we have 6 nodes, replication factor of 3. Our platform uses all the 6 nodes to query data, I query one node ...
1
vote
1answer
31 views

inserting in table emp1234 but got an error in cassandra

This is what I tried: emp1234(user_id,age,city,country,height,mobile_no,name,sex,state,weight) FROM '/tmp/user.csv' WITH HEADER = FALSE; But it returns the following error: error - Failed to ...
2
votes
2answers
137 views

Does cassandra upgrade require to run nodetool upgradesstables for cluster holding TTLed data

I am running 3 node apache cassandra cluster as docker container holding timeseries data with 45 days TTL. I am planning to upgrade the current cassandra version 2.2.5 to cassandra 3.11.4 release. ...
0
votes
3answers
34 views

How to get total no of rows in a cassandra column family using Java?

I want to get total number of rows in the column family. I know using nodetool cfstats we can get approx rows. But how to get it using Java Client.
1
vote
2answers
55 views

Move production env cassandra cluster to AWS cassandra without downtime

I have cassandra cluster of 4 nodes running in production environment in on-premise DC. I have to move it to AWS cassandra. I don't want move cassandra to dynamoDB due to some reason. Cassandra ...
1
vote
1answer
42 views

JBOD on cassandra issue

I have 3 node cassandra cluster with JBOD configuration. I have 4 disk for data /data1, /data2, /data3, /data4. Now, we are facing space issue on disk on nodes frequently. Currently /data1 is full (...
1
vote
1answer
82 views

How to connect Cassandra over ssl using connection properties(url properties)

I have truststore and keystore files and every information related to the cassandra account. There is a limitation with the application that i use to connect to cassandra as it doesn't provide me the ...
2
votes
1answer
33 views

How to query data efficiently in large Cassandra collection?

I have one big Casandra collection (1-million docs), and I want to query the whole user table data its around 1 million records. When I run following query its only return around 10K records. Could ...
0
votes
1answer
139 views

Slow Query Logger Cassandra on server side in Cassandra 3.11.4

As per https://issues.apache.org/jira/browse/CASSANDRA-12403 I tried to enable slow query logging with below steps on Cassandra 3.11.4 , but not able to query them any idea what is the issue, or am ...
0
votes
0answers
30 views

How to autogenerate data while importing from a csv file to cassandra key space?

Hi i have a cassandra keyspace/table with the following description. CREATE TABLE "Openmind".mep_user_password_history ( id uuid PRIMARY KEY, password text, reset_date timestamp, ...
0
votes
0answers
21 views

Cassandra override connection object

Is there anyway where I can override default connection object in spring boot? Because password, username I have to get from remote location.so it might change in between.I have got link in case of ...
0
votes
1answer
46 views

How to interpret cassandra consistency from tracing a query

Could you advice even though my query do not have option IF EXISTS and IF NOT EXISTS. still in query tracing result shows both consistency_level "QUORUM" which is what we wanted but it also shows '...
0
votes
2answers
71 views

User can view specfic keyspace not others if not admin rights?

While exploring cassandra, Is it possible in cassandra that if I created an user "test" and I have multiple keypsaces so if I am logging cqlsh with "test" then I can see only selected keyspaces not ...
0
votes
0answers
19 views

Understanding hintedhandoff in amazon dynamodb

From the dynamodb paper, I see Consider the example of Dynamo configuration given in Figure 2 with N=3. In this example, if node A is temporarily down or unreachable during a write operation then a ...
0
votes
0answers
46 views

Change Cassandra start/stop logs file cassandra.log file name

To send logs to splunk with application name we want to change all the Cassandra log files . I was able to find system.log/debug.log in logback.xml and gc.log in cassandra-env.sh, but I can't locate ...
2
votes
2answers
97 views

Is it possible to recover deleted column data in cassandra?

If we have deleted some(20 query) data in Cassandra using below delete query. DELETE lastname FROM cycling.cyclist_name WHERE id = c7fceba0-c141-4207-9494-a29f9809de6f; So how we can restore/find ...
0
votes
0answers
38 views

Cassandra stress test with cfstats output

I have set fresh 3 node cassandra cluster where I have run cassandra-stress for write and read testing. below are the commands which I have run with cfstat output. 1) **cassandra-stress write n=500 ...
2
votes
2answers
390 views

Major compaction on Cassandra after changing gc_grace_seconds 10 to 0 day

I have a Cassandra cluster which is having gc_grace_seconds 10 days. auto compaction is enabled and running as per configuration but I am suspecting that auto compaction is not clearing the tombstones ...
1
vote
0answers
28 views

In cassandra udf i am parsing date as saumya.text2dt('2019-01-16 13:10:44.000') and output is like 2019-10-16 07:30:00.000000+0000

My Cassandra User defined function:- CREATE OR REPLACE FUNCTION text2dt ( input text ) RETURNS NULL ON NULL INPUT RETURNS timestamp LANGUAGE java AS ' java.text.SimpleDateFormat sdf = new java.text....
0
votes
1answer
41 views

What does it mean by “Key cache save of system.KeyCache” on Opscenter?

I have running Cassandra cluster and opscenter too.I found that suddenly came "Key cache save of system.KeyCache" when I ran nodetool compactionstats. Also, found same on opscenter. Is there any ...
1
vote
2answers
120 views

How to find large partition in cassandra except system.log?

How can we find large partitions on our cassandra cluster before came into system.log? we are facing some performance issue due to this. Can anyone help me. We have cassandra version 2.0.11 and 2.1.16....
0
votes
1answer
54 views

date column which is a text type in Cassandra.so I need a UDF to convert that text to timestamp so I can query on that column

I have writeen code like belo but getting error as below:- InvalidRequest:  Error from server:  code=2200 [Invalid query]  message="Java source compilation failed: Line 1: java.util.String cannot ...
3
votes
1answer
88 views

How to Model Table to run query's based on status field which is changing over time

Currently we have a table which we query using shipment_id and in future we have a need to query based on status field Current Table : CREATE TABLE shipment ( shipment_id text, tenant_id ...
0
votes
0answers
16 views

What should be max sstable count to improve read latency on prod cluster?

We are facing read latancy issue on our prod cassandra cluster. I am suspecting that sstables are the reasons. Can any one tell that what should be max sstable count on cassandra node? or any other ...