Top "Cql" questions

CQL (Cassandra Query Language) is used to interact with and query Cassandra tables.

Prepared Statement with collection in IN clause in Datastax Cassandra CQL driver

I am trying to run the following query SELECT edge_id, b_id FROM booking_by_edge WHERE edge_id …

cassandra cql cql3 datastax-enterprise datastax-java-driver
Cassandra DB. com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table person

The keyspace and 'person' table are exist Hello, I'm new with Cassandra, so I'm just trying to execute select query …

java cassandra cql datastax-java-driver cassandra-3.0
Cassandra: Unable to coerce '2016-04-06 13:06:11.534000' to a formatted date (long)

I am trying to UPDATE an existing item in my cassandra DB using cqlsh: $ > UPDATE allEvents SET "isLastEvent" = True …

cassandra cql cqlsh
Non frozen collections and user defined types on Cassandra 2.1.8

I'm trying to run the following example from here CREATE TYPE address ( street text, city text, zip int ); CREATE TABLE …

cassandra cql datastax cql3
CQL check if record exists

I'm on my path to learning Cassandra, and the differences in CQL and SQL, but I'm noticing the absence of …

cassandra cql
Run cassandra queries from command line

I want to execute cql queries from bash command. [cqlsh 3.1.8 | Cassandra 1.2.19 | CQL spec 3.0.5 | Thrift protocol 19.36.2] [root@hostname ~]# /opt/apache-cassandra-1.2.19/bin/…

bash cassandra cql cqlsh cassandra-cli
Understanding the Token Function in Cassandra

Hello I was reading the Cassandra documentation on Token Function, I am trying to achieve pagination for a Cassandra table, …

cassandra pagination cql cql3
Alter cassandra column family primary key using cassandra-cli or CQL

I am using Cassandra 1.2.5. After creating a column family in Cassandra using cassandra-cli, is it possible to modify the primary …

cassandra cql cql3 cassandra-cli cqlsh
How to view all tables in CQL and CQLSH?

I'm trying to explore the database and want to see all tables that exist there. What's the command that's equivalent …

cassandra cql cqlsh
Select 2000 most recent log entries in cassandra table using CQL (Latest version)

How do you query and filter by timeuuid, ie assuming you have a table with create table mystuff(uuid timeuuid …

cassandra cql