Is there any way to select TTL value for an element in a map in Cassandra with CQL3? I've tried this, but it doesn't work: SELECT TTL (mapname['element']) FROM columnfamily

using CF: CREATE TABLE history ( domain text, iid text, timeid timeuuid, data text, comments text, PRIMARY KEY (domain, iid, timeid) ); I'd like to query it like this: select domain, iid,...

I have a table/column family which I am inserting rows that expire after a certain amount of time. Is it possible to then query the table to check which rows are going to expire soon (for diagnosti...

I have a requirement of versioning to be done using cassandra. Following is my column family definition create table file_details(id text primary key, fname text, version int, mimetype text); I ...

I want to insert a single row with 50,000 columns into Cassandra 1.2.8. Before inserting, I have all the data for the entire row ready to go (in memory): +---------+------+------+------+------+---...

I need to fetch rows without specific keys. for sample: select * from users where user_id not in ("mikko"); I have tried with "not in" and this is the response: Bad Request: line 1:35 no viabl...

I am using Cassandra 1.2.5. After creating a column family in Cassandra using cassandra-cli, is it possible to modify the primary key on the column family using either cassandra-cli or CQL? Speci...

I want to store my website images in cassandra database! I must read and store bytes of image. Do you have a nice code for me? I'm using python2.7, django framework and cql-engine! This is my code...

I have a requirement of designing Data Model in cassandra for User, Role, Organization and permissions. Each Organization can have Users and Roles Each User can belong to number of Roles Each R...

I'm trying to rename table created via CQLSH. E.g. rename table "AAA" to "BBB". Can't find any command to do so. Any ideas? Using [cqlsh 3.1.6 | Cassandra 1.2.8 | CQL spec 3.0.0 | Thrift protocol...

I want to query data filtering by composite keys other than Row Key in CQL3. These are my queries: CREATE TABLE grades (id int, date timestamp, subject text, status text, PRIMARY KEY (id, sub...

How to rename keyspace and columnfamily in cassandra 1.2? I know that cassandra-cli rename api is no longer supported - How to rename keyspace in Cassandra. Maybe there are some api in CQL3? Or som...

I have started working with Cassandra database. I am planning to use Datastax API to upsert/read into/from Cassandra database. I am totally new to this Datastax API (which uses new Binary protocol)...

Initially I started learning Cassandra because dynamic columns caught my attention. As I started learning more, I learnt that composite primary keys are preferred to dynamic columns and Cassandra i...