Top "Cql" questions

Get current date in cassandra cql select

In SQL, I am able to do: select getdate(), getdate() - 7 Which returns the current date as well as current …

cassandra cql datastax datastax-enterprise cql3

select count(*) runs into timeout issues in Cassandra

Maybe it is a stupid question, but I'm not able to determine the size of a table in Cassandra. This …

cassandra cql

cassandra, select via a non primary key

I'm new with cassandra and I met a problem. I created a keyspace demodb and a table users. This table …

cassandra cql cqlsh

Difference between UPDATE and INSERT in Cassandra?

What is the difference between UPDATE and INSERT when executing CQL against Cassandra? It looks like there used to be …

cassandra cql cql3

Range Queries in Cassandra (CQL 3.0)

One main part of Cassandra that I don't fully understand is its range queries. I know that Cassandra emphasizes distributed …

cassandra cql range-query

cassandra primary key column cannot be restricted

I am using Cassandra for the first time in a web app and I got a query problem. Here is …

cassandra cql cqlsh

Creating column family or table in Cassandra while working Datastax API(which uses new Binary protocol)

I have started working with Cassandra database. I am planning to use Datastax API to upsert/read into/from cassandra …

cassandra command-line-interface cql cql3

How to check if a Cassandra table exists

Is there an easy way to check if table (column family) is defined in Cassandra using CQL (or API perhaps, …

cassandra cql

Inserting null values into cassandra

I have some fields that I am storing into Cassandra, but some of them could be null at any given …

cassandra cql tombstone

Use of Order by clause in cassandra

When creating table in cassandra, we can give clustering keys with ordering like below. Create table user(partitionkey int, id …

cassandra cassandra-2.0 cql datastax