Top "Cql" questions

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

how to construct range query in cassandra?

CREATE TABLE users ( userID uuid, firstname text, lastname text, state text, zip int, age int, PRIMARY KEY (userID) ); I want …

cql cql3 cassandra-2.0
Cassandra error - Order By only supported when partition key is restricted by EQ or IN

Here is the table I'm creating, this table contains information about players that played the last mundial cup. CREATE TABLE …

select cassandra sql-order-by cql
Error: unable to connect to cassandra server. Unconfigured table

I am trying to connect to cassandra, which is running on local desktop, via cassandra-driver for python using this simple …

python cassandra cql cql3
Cassandra: get column names of a columnfamily?

I'm wondering if there is a query in CQL3 that allows you to get column names of a specific columnfamily …

cassandra cql cql3
Cassandra Delete by Secondary Index or By Allowing Filtering

I’m trying to delete by a secondary index or column key in a table. I'm not concerned with performance …

cassandra cql
How to create foreign key in Cassandra CQL

I'm trying to replicate a SQL database in Cassandra, but, while I had no problem creating the tables, I found …

sql cassandra foreign-keys foreign-key-relationship cql
Dealing with Cassandra Timestamp

Recently I have started working on cassandra and I have some issues dealing with cassandra timestamp using cql and Java. …

java cassandra timestamp cql datastax
Cassandra Allow filtering

I have a table as below CREATE TABLE test ( day int, id varchar, start int, action varchar, PRIMARY KEY((day),…

cassandra datastax cql datastax-enterprise
Cassandra LOCAL_QUORUM

I'm having trouble understanding / finding information about how various quorums are calculated in cassandra. Let's say I have a 16 node …

cassandra datastax cql cassandra-2.0 nosql
Cassandra Error - Clustering column cannot be restricted (preceding column is restricted by a non-EQ relation)

We are using Cassandra as the data historian for our fleet management solution. We have a table in Cassandra , which …

cassandra cql datastax-enterprise cql3