Stack Overflow
Stack Overflow

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
2
votes
1 answer

Cassandra time datatype

Using DataStax 4.8.11 with Cassandra 2.1.17, Ubuntu14.04 I am trying to create a table with time data type. The syntax works fine on Cassandra 2.2.8/Win7, but not on DataStax 4.8.11. CREATE KEYSPACE tests WITH REPLICATION = {'class' :…
Sam-T
  • 1,877
  • 6
  • 23
  • 51
2
votes
0 answers

Cassandra Best Practices

What is the best practice to be used for Cassandra - separate installations for different applications or just a new keyspace in same installations. Factors such has storage, memory and CPU how they can be restricted for a keyspace if we used the…
Arpit Agrawal
  • 41
  • 2
2
votes
0 answers

SStables are not removed during minor compation in DTCS

I am having this issue of disk space in Cassandra 2.1.12. Even after the TTL, sstables are persisted on disk. I have given below the definition of my column family and it's a time series data with date as a partitioning key. Definition : AND…
Naresh
  • 5,073
  • 12
  • 67
  • 124
2
votes
2 answers

How COPY works in cassandra when table is replicated accross multplie nodes in a cluster?

Suppose if want to copy a table from a cluster of 7 nodes with RF = '3' to another cluster of 6 nodes with RF '3' how can i do that ?? can i copy data from anyone of the node to CSV file and then import that data from CSV file to any node in the new…
user6288321
  • 365
  • 4
  • 14
2
votes
1 answer

Cassandra constant tombstone compaction of table

I have a couple of Cassandra tables on which tombstone compaction is constantly being run and I believe this is the reason behind high CPU usage by the Cassandra process. Settings I have include: compaction = {'tombstone_threshold': '0.01',…
GenerousJoker
  • 87
  • 1
  • 12
2
votes
1 answer

How to model enum types in phantom dsl?

My case class contains enum parameter like as follows: case class User(role: UserRole.UserRole, name: String) object UserRole extends Enumeration { type UserRole = Value val ADMIN, USER = Value } How to model this case as in this example? Any…
PainPoints
  • 461
  • 8
  • 20
2
votes
1 answer

Cassandra Range Query

I have a set of products (product_Id, price). 'Price' of all products keep on changing and hence need to be updated very frequently. I want to perform range query on prices: select * from products where price > 10 and price < 100; Please note -…
Abhishek Agarwal
  • 846
  • 4
  • 13
  • 34
2
votes
2 answers

Cassandra Python driver OperationTimedOut issue

I have a python script which is used to interact with cassandra with datastax python driver It has been running since March 14th, 2016 and had not problem until today. 2016-06-02 13:53:38,362 ERROR ('Unable to connect to any servers',…
Haifeng Zhang
  • 30,077
  • 19
  • 81
  • 125
2
votes
1 answer

no-warmup option in cassandra-stress read or write

While reading or writing from a node in a Cassandra cluster, using cassandra-stress tool, there is an option called no-warmup. What does that mean? Will there be any performance improvement when using that option? Or does it have something to do…
Keerthikanth Chowdary
  • 728
  • 1
  • 10
  • 17
2
votes
2 answers

Multiple IF conditions in Cassandra lightweight transactions/CAS

So I'm trying to do a CAS (compare-and-set) type operation in Cassandra, where I want to do a data update only if a particular non-primary-key column is NULL or < ? where ? is supplied by client-side code. How do I do this? Something like the…
Nishant Kelkar
  • 412
  • 1
  • 4
  • 20
2
votes
1 answer

Example of creating triggers in Cassandra and does this support only for Java?

Wanted to check about Triggers feature in Cassandra. Can someone please provide an example for creating Trigger. From this blog, http://www.datastax.com/dev/blog/whats-new-in-cassandra-2-0-prototype-triggers-support To create a trigger, you must…
Arun
  • 1,692
  • 15
  • 24
2
votes
2 answers

How do I define multiple table definitions and multiple column specs for cassandra-stress profile file?

# Keyspace Name keyspace: demo1 # The CQL for creating a keyspace (optional if it already exists) keyspace_definition: | CREATE KEYSPACE demo1; # Table name table: sample_test # The CQL for creating a table you wish to stress (optional if it…
user1870400
  • 6,028
  • 13
  • 54
  • 115
2
votes
1 answer

cassandra 2.1.8, adding new nodes(s), out of memory

I have cassandra 2.1.8 cluster with 16 nodes (Centos 6.6, 1x4core xeon, 32Gb RAM, 3x3Tb HDD, java 1.8.0_65) and trying to add 16 more, one by one, but stuck with the first one. After starting cassandra process on the new node, 16 streams from…
Vladimir Ermakov
  • 113
  • 5
2
votes
1 answer

Cassandra: Minimizing metadata overhead with UDT

I have a 40 column RDBMS table which I am porting to Cassandra. Using the estimator at http://docs.datastax.com/en/cassandra/2.1/cassandra/planning/architecturePlanningUserData_t.html I created a excel sheet with column names, data types, size of…
Dojo
  • 5,374
  • 4
  • 49
  • 79
2
votes
4 answers

Cassandra CQL where clause with multiple collection values?

My data model:- tid | codes | raw | type -------------------------------------+--------------+--------------+------ a64fdd60-1bc4-11e5-9b30-3dca08b6a366 | {12, 34, 53} | {sdafb=safd} | cmd CREATE…
leoismyname
  • 407
  • 6
  • 11
1 2 3
…
26 27