Top "Cql" questions

SELECT in cassandra where id != null

How do I query in cassandra for != null columns. Select * from tableA where id != null; Select * from tableA where name != …

cassandra cql

Where and Order By Clauses in Cassandra CQL

I am new to NoSQL database and have just started using apache Cassandra. I created a simple table "emp" with …

cassandra cql cql3

Cassandra cqlsh - how to show microseconds/milliseconds for timestamp columns?

I'm inserting into a Cassandra table with timestamp columns. The data I have comes with microsecond precision, so the time …

cassandra timestamp cql cqlsh

How do secondary indexes work in Cassandra?

Suppose I have a column family: CREATE TABLE update_audit ( scopeid bigint, formid bigint, time timestamp, record_link_id bigint, …

cassandra cql cassandra-2.0 cql3

Select first N rows of Cassandra table

As stated in this doc to select a range of rows i have to write this: select first 100 col1..colN …

cassandra cql

Check a rows TTL in cassandra?

I have a table/column family which I am inserting rows that expire after a certain amount of time. Is …

cassandra cql cql3

Does an UPDATE become an implied INSERT

For Cassandra, do UPDATEs become an implied INSERT if the selected row does not exist? That is, if I say …

cassandra cql

How to switch Keyspace in Cassandra using CQL?

I used USE billKeyspace; to enter a keyspace and start using it. Now I want to exit this keyspace and …

database cassandra cql cassandra-2.0 cql3

Inserting a hard-coded UUID via CQLsh (Cassandra)

Would like to populate some static test data via a CQLsh script. This doesn't work: (device_id is UUID) insert …

cassandra uuid cql cqlsh

How to copy data from a Cassandra table to another structure for better performance

In several places it's advised to design our Cassandra tables according to the queries we are going to perform on …

cassandra cql cql3 cqlsh