Questions tagged [cassandra-2.1]

Casandra 2.1 is a NoSQL database sponsored by Apache. Use this tag for question specifically for version 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…
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…
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