Top "Cql3" questions

Cassandra cql: how to select the LAST n rows from a table

I want to verify that rows are getting added to the table. What cql statement would show the last n …

cassandra cql3

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

How to rename table in Cassandra CQL3

I'm trying to rename table created via CQLSH. E.g. rename table "AAA" to "BBB". Can't find any command to …

cassandra cql3

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

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

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

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

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

Timestamp comparison in cassandra

As shown in the picture querying with exact timestamp(2013-08-01 15:02:56) is not returning any result though a row with …

timestamp cassandra cql3

Exception when connecting to Cassandra with CQL using DataStax Java driver 1.0.4

I have Cassandra 1.2.11 running on my laptop. I can connect to it using nodetool and cqlsh but when I try …

java cassandra cql3 datastax-java-driver