Stack Overflow
Stack Overflow

Questions tagged [cql]

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables. Its syntax is similar to SQL, helping to lower the learning curve to working with Cassandra. For the Cypher graph query language, use the cypher tag.

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables. Its syntax is similar to SQL, helping to lower the learning curve to working with Cassandra. Despite their similarities, in many cases CQL behaves very differently from SQL, so it is important to read the documentation before going too far.

Some of the more useful links to documentation on CQL:

2118 questions
652
votes
10 answers

Difference between partition key, composite key and clustering key in Cassandra?

I have been reading articles around the net to understand the differences between the following key types. But it just seems hard for me to grasp. Examples will definitely help make understanding better. primary key, partition key, composite key…
brain storm
  • 30,124
  • 69
  • 225
  • 393
105
votes
1 answer

Deleting all rows from Cassandra cql table

Is there a command to all the rows present in a cql table in cassandra like the one in sql? delete from TABLE Going by the documentation, I don't find any way to perform delete operation without a where condition. DELETE col1 FROM SomeTable WHERE…
Aarish Ramesh
  • 6,745
  • 15
  • 60
  • 105
65
votes
4 answers

How to run cql files (.cql) from within cqlsh?

The problem that I am having is that I want to run the following command (and I can't): cqlsh < cql_directory/cql_create_stuff.cql Because I have not logged in to cqlsh. So I logged in: cqlsh -u 'my_username' -p 'my_super_secret_password' and now…
Charlie Parker
  • 5,884
  • 57
  • 198
  • 323
65
votes
3 answers

How to get current timestamp with CQL while using Command Line?

I am trying to insert into my CQL table from the command line. I am able to insert everything. But I am wondering if I have a timestamp column, then how can I insert into timestamp column from the command line? Basically, I want to insert current…
user2467545
63
votes
3 answers

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 and always use TimeUUID instead of plain old UUID?
Jay
  • 19,649
  • 38
  • 121
  • 184
56
votes
4 answers

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 UPDATE users SET name = "Raedwald" WHERE id = 545127 and id is the PRIMARY KEY of the users table, and the table has no row with a key of…
Raedwald
  • 46,613
  • 43
  • 151
  • 237
54
votes
2 answers

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, ipaddress text, user_zuid bigint, value text, PRIMARY KEY ((scopeid, formid), time) ) WITH CLUSTERING…
Aftab
  • 938
  • 1
  • 9
  • 20
53
votes
4 answers

How to auto generate uuid in cassandra CQL 3 command line

Just learning cassandra, is there a way to insert a UUID using CQL, ie create table stuff (uid uuid primary key, name varchar); insert into stuff (name) values('my name'); // fails insert into stuff (uid, name) values(1, 'my name'); // fails Can…
Jay
  • 19,649
  • 38
  • 121
  • 184
50
votes
2 answers

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 into devices (device_id, geohash,name, external_identifier, measures, tags) values ('c37d661d-7e61-49ea-96a5-68c34e83db3a','9q9p3yyrn1',…
Chris H
  • 665
  • 1
  • 7
  • 10
50
votes
4 answers

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 no difference, but now the documentation says that INSERT does not support counters while UPDATE does. Is there a "preferred"…
Chris Dutrow
  • 48,402
  • 65
  • 188
  • 258
47
votes
4 answers

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 and describe cluster isn't as concise as I want. I'm working using the following specifications: cqlsh 2.2.0, Cassandra 1.1.10, CQL spec…
Crowie
  • 3,220
  • 7
  • 28
  • 48
43
votes
7 answers

Results pagination in Cassandra (CQL)

I am wondering how can I achieve pagination using Cassandra. Let us say that I have a blog. The blog lists max 10 posts per page. To access next posts a user must click on pagination menu to access page 2 (posts 11-20), page 3 (posts 21-30),…
kazy
  • 1,111
  • 2
  • 14
  • 24
42
votes
3 answers

How to do a join queries with 2 or more tables in cassandra cql

I am new to cassandra. Here I have two tables EVENTS and TOWER. I need to join those for some queries. But I'm not enable to do it. Structure of EVENTS table: eid int PRIMARY KEY, a_end_tow_id text, a_home_circle text, a_home_operator text, a_imei…
BlueShark
  • 497
  • 3
  • 9
  • 14
37
votes
3 answers

cassandra get all records in time range

I have to work with a column family that has (user_id, timestamp) as key. In my query I would like to fetch all records in a given time range independent of the user_id. This is the exact table schema: CREATE TABLE userlog ( user_id text, ts…
Faber
  • 1,504
  • 2
  • 13
  • 21
35
votes
1 answer

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
AturSams
  • 7,568
  • 18
  • 64
  • 98
1
2 3
…
99 100