Top "Cql" questions

SELECT DISTINCT cql ignores WHERE clause

Executing two identical requests but the DISTINCT keyword gives unexpected results. Without the keyword, the result is ok but with …

cassandra distinct cql

How do you create the first user in Cassandra DB

How does one create the first user in a cassandra database? I tried: CREATE USER username WITH PASSWORD ""; and its …

cassandra cql cqlsh

Is there a clear equivalent of 'show keyspaces' in cqlsh 2?

What cqlsh command can I use to quickly see the keyspaces in a cluster? cqlsh does not provide show keyspaces …

cassandra cql cqlsh

Cassandra UUID vs TimeUUID benefits and disadvantages

Given that TimeUUID handily allows you to use now() in CQL, are there any reasons you wouldn't just go ahead …

cassandra uuid cql cql3 timeuuid

Cassandra CQL not equal operator on any column

Hi is there any way I can use != operator using CQL in Cassandra? I am trying to use a != operator …

cassandra cql

Executing CQL through Shell Script?

I am trying to execute the CQL commands from shell script. I am able to connect to the cqlsh (CQL …

cassandra cql cassandra-2.0 cqlsh

How Can I Search for Records That Have A Null/Empty Field Using CQL?

How can I write a query to find all records in a table that have a null/empty field? I …

cassandra cql

Cassandra: Generate a unique ID?

I'm working on a distributed data base. I'm trying to generate a unique ID that will serve as a column …

cassandra uuid cql cql3

Check CQL version with Cassandra and cqlsh?

How do you check which cql version is currently being used in cqlsh? In sql, you do this: Select @@version

cassandra cql cqlsh

How to insert a datetime into a Cassandra 1.2 timestamp column

IMPORTANT If you are dealing with this problem today, use the new cassandra-driver from datastax (i.e. import cassandra) since …

python cassandra cql