Top "Cql" questions

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables.

How to query a field in a user defined type in a set using CQL (Cassandra)

I am using the User Defined Types in CQL 3.1 (cqlsh info below): [cqlsh 5.0.1 | Cassandra 2.1.2 | CQL spec 3.2.0 | Native protocol v3] I …

cassandra set cql user-defined-types
how UPDATE rows in cassandra using only Partition Key?

My table looks like this create table Notes( user_id varchar, real_time timestamp, insertion_time timeuuid, read boolean PRIMARY …

cassandra datastax cql cql3 nosql
How to change PARTITION KEY column in Cassandra?

Suppose we have such table: create table users ( id text, roles set<text>, PRIMARY KEY ((id)) ); I want …

cassandra cql cqlsh
CQLSH: Converting unix timestamp to datetime

I am performing a cql query on a column that stores the values as unix timestmap, but want the results …

cassandra cql cqlsh
Is the IN relation in Cassandra bad for queries?

Given an example of the following select in CQL: SELECT * FROM tickets WHERE ID IN (1,2,3,4) Given ID is a partition …

java database database-design cassandra cql
Wrong count(*) with cassandra-cql

I tried to create some users for my testing. I created users in a loop from 0..100000 using the cassandra-cql gem …

cassandra cql
How to add multiple columns in cassandra table?

I need to add some new columns to my existing column_family/table in cassandra. I can add single column …

cassandra cql datastax-java-driver
Cassandra: inserting timeuuid error

I have following table create table test( userId varchar, notifId timeuuid, notification varchar, time bigint,read boolean, primary key(userId, …

cassandra cql datastax-java-driver
What is the byte size of common Cassandra data types - To be used when calculating partition disk usage?

I am trying to calculate the the partition size for each row in a table with arbitrary amount of columns …

cassandra datastax cql
Cassandra preventing duplicates

I have a simple table distributed by userId: create table test ( userId uuid, placeId uuid, visitTime timestamp, primary key(userId, …

cassandra cql cql3