Casandra 2.1 is a NoSQL database sponsored by Apache. Use this tag for question specifically for version 2.1.
Questions tagged [cassandra-2.1]
396 questions
0
votes
1 answer
Create table with many columns Cassandra 2
I need a table on Cassandra2 with 56K columns of 1 byte each, for benchmark purposes.
I'm trying to create a "usertable" with this requirement like this:
create table usertable (
y_id varchar primary key,
field0 varchar,
field1 varchar,
…

vschettino
- 101
- 2
- 9
0
votes
2 answers
Cassandra java.lang.IllegalArgumentException: text while getMetaData
I get an cassandra exception while geathering meta data.
Exception:
Exception in thread "main" java.lang.IllegalArgumentException: text
at com.datastax.driver.core.ColumnMetadata$Raw$Kind.fromStringV3(ColumnMetadata.java:160)
at…

JuKu
- 1
- 6
0
votes
1 answer
Generic VS Specific model in Cassandra?
Quite long post so let’s start with some context:
Weather data have a central role in our architecture. A weather data is mainly composed of five values:
Temperature
Rain
Global Radiation
Wind (direction, speed)
Relative Humidity
But we could also…

mlardeur
- 109
- 1
- 9
0
votes
0 answers
Any limitation on using Unique column as partition key in cassandra
I have a scenario where i have only sequence number column that i can use in partition key,rest of the columns will create big partition on a node.
So my question is, is there any drawback of using sequence no in partition key?
As by doing this my…

user3774905
- 178
- 4
- 15
0
votes
1 answer
using dynamicFields with datastax enterprise search
I'm using Datastax Enterprise 4.8.0 with Search enabled. I'm trying to use dynamicFields with a map collection and can't figure it out. Here's more details.
[cqlsh 5.0.1 | Cassandra 2.1.9.791 | DSE 4.8.0 | CQL spec 3.2.0 | Native protocol v3]
I've…

LHWizard
- 2,121
- 19
- 30
0
votes
1 answer
node js cassandra driver ResponseError: line 0:-1 no viable alternative at input ''
Not able to connect to cassandra database using cassandra-driver.
Cassandra version is 2.1.5, cassandra-driver version is 2.1.
var cassandra = require("cassandra-driver");
var cassandraClient = new cassandra.Client({
contactPoints: [
…

Prash
- 21
- 4
0
votes
1 answer
Difference between CQL insert and update?
I'm new to Cassandra and I come from a relational world. When I was playing with CQL I observed that I didn't find any difference. For ex:
when I execute below query
update product set price=100, currency=USD where productID=12345;
then CQL…

ak123
- 285
- 2
- 5
- 15
0
votes
0 answers
Cassandra 2.1.10: Cannot rename Commit log files
I am a newbie please bear with me if not very clear with the query.
I have been working with cassandra for sometime. But suddenly it has stopped working with the issue being reported as "Error processing commit log during intialization" and that it…

Sujata Ghorpade
- 11
- 2
0
votes
0 answers
Cassandra cluster write performance
I'm using Cassandra 2.1 with 3 nodes, one of them is configured as seed.
The cluster seems to be working fine, and read/query speed is nice. But writing speed is really bad. About 1000-2000 rows/sec. Considering I need to push a database with…

alvatar
- 3,340
- 6
- 38
- 50
0
votes
2 answers
Can Triggers be used in Cassandra for production for a multi datacenter environment?
I have a multi datacenter(DC1, DC2) environment having 3 nodes in each datacenter with RF=3 per datacenter.
Wanted to know if triggers can be used in production in a multi-datacenter environment. If so, how can this be achieved?
Case A: If I start…

Arun
- 1,692
- 15
- 24
0
votes
1 answer
does Cassandra's CCM tool only support one keyspace?
I am working with a cluster I created with ccm. We are using 3 tables in 2 keyspaces, so 6 tables in total. I was having a problem that it let me create one table in one keyspace and 2 in the other but even when I removed my
IF NOT EXISTS
check…

Dan Csharpster
- 2,662
- 1
- 26
- 50
0
votes
1 answer
connect to Cassandra CCM cluster with C# driver
I am trying to play around with my application access a ccm cluster I create on the fly, for local development but I'm not sure how you would set the contact points (which ip address and what not, what security settings to use) once I've created my…

Dan Csharpster
- 2,662
- 1
- 26
- 50
0
votes
1 answer
Retrieving data with dynamic attributes in Cassandra
I'm working on a solution for Cassandra that's proving impossible.
We have a table that will return a set of candidates given some search criteria. The row with the highest score is returned back to the user. We can do this quite easily with SQL,…

kalypzo
- 102
- 2
- 6
0
votes
1 answer
cql-import dynamic map Entries in cassandra
I have 2 mysql tables as given below
Table Employee:
id int,
name varchar
Table Emails
emp_id int,
email_add varchar
Table Emails & Employee are connected by employee.id = emails.emp_id
I have entries like:
mysql> select * from employee;
id …
0
votes
1 answer
Is it acceptable to have Replication factor 3 for a 3 node cluster in Cassandra with Consistency level as LOCAL_ONE in multi datacenter?
We have 2 Datacenters each having 3 nodes with replication factor of 3 for each Datacenter (Total 6 replicas) with read consistency level as LOCAL_ONE. Since we are not using LOCAL_QUORUM or DC_LOCAL_QUORUM, is it acceptable to go with 3 nodes in…

Arun
- 1,692
- 15
- 24