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
0
votes
1 answer

Using CQL filter to query date relative to present

I'm working with geoserver ,and i want to filter my layer by date (WFS), i have two columns : Date_start and Date_end i would like to display only feature that verify this condition : Date_PRESENT >Date_start and Date_PRESENT
work
  • 27
  • 4
  • 12
0
votes
0 answers

Scylla cannot append clustering row

What is the cause of the following error? :9042 replied with server error (mutation_partition::append_clustered_row(): cannot append clustering row with key {position: clustered,ckp{00024174000400000000},0} to the partition, last…
Rado Buransky
  • 3,252
  • 18
  • 25
0
votes
3 answers

Why does setting TTL to 1 second lead to unexpected behaviour?

I know that setting very short TTL in Cassandra is a bad practice, but I want to have a deeper understanding of why it is the case. I have a table structure with primary key consisting of 2 fields. When writing a record to Cassandra and setting a…
mboronin
  • 875
  • 1
  • 10
  • 16
0
votes
0 answers

InvalidQueryException: Cannot have more than 100 in a single assignment. Please use multiple assignments to set this value

I am getting this error when trying to insert data in my new table with one of the columns of type list when size of the elements in the list go beyond 100. But I am able to do insert even 400 records in old table with same config. table(field1…
Amrita Singh
  • 1
0
votes
0 answers

Geoserver cross layer filtering with subselection in both layers

I am trying to add a cross layer cql filter in two geoserver layers. I would like to be able to select a subgroup of the records in both layers before I apply the spatial filter. I can apply the selection successfully in the second layer like…
gijo
  • 45
  • 4
0
votes
1 answer

How to show raw queries(CQL) in Scylla/Cassandra

I am using Scylla(Cassandra's drop in replacement) db in docker container. I am using Python driver to connect with Scylla db for querying. I need to know the exact CQL query is applying on the database engine. So, if there any way to print the…
Mohammad Ashraful Islam
  • 1,879
  • 15
  • 29
0
votes
0 answers

how we can find total unique videos in dataset

i am trying to find unique videos in cql but dintinct cannot be used directly.so what approach we can use to find.i have created a separate table but still its not working query = """ CREATE TABLE IF NOT EXISTS distinct_videos ( video_set…
programming
  • 11
  • 2
0
votes
0 answers

AWS CQL editor showing incorrect data when queried

I have inserted the order with all the necessary fields into Cassandra using python (cassandra-driver==3.21.0). Table schema looks like this: Columns datatype ----------------------- name text phone text date text inserteddate…
Venkatesh Gorige
  • 11
  • 3
0
votes
1 answer

How do I count distinct values based on a non-primary key filter in Cassandra?

relational databases and Cassandra. With two tables like the following: TABLE 1: PRIMARY KEY (ID, DATE)); ID DATE TRIP_TIME B03291 2022-01-01 5 B03291 2022-01-02 6 ZR7875 2022-01-01 2 ZR7875 2022-01-02 0 TABLE 2: PRIMARY KEY ((ID,…
Moses Casposes
  • 23
  • 4
0
votes
1 answer

Openlayers: Loading image while layer is invisible

I'm using Openlayers 7. Is it possible to force the layer source (ImageWMS) to load a CQL filtered image, i.e. to buffer it, while the layer is not visible? I would like to avoid the image from a previous filter to flash on the map, when the filter…
user762513
  • 61
  • 3
0
votes
0 answers

Request to Cassandra with a condition on a column that is not a Primary Key works in DBeaver but doesn't work in Python

My query has a WHERE on a column that is not a primary key. SELECT * FROM table WHERE id_order IN ('2177579','2177130','2177072') The query works fine in DBeaver, but when using the Cassandra library in Python: from cassandra.cluster import Cluster…
Vladimir Yushmanov
  • 1
0
votes
1 answer

Is it possible to use a hash type secondary index in scylladb?

Table for explanation: CREATE TABLE test ( id INT, uniuque_string VARCHAR, another_id INT, PRIMARY KEY ((id, uniuque_string)) ); Sometimes it is necessary to make such requests: SELECT * FROM test WHERE another_id = 12; but…
Gregory Sysoev
  • 173
  • 1
  • 15
0
votes
1 answer

How to execute a .cql file inside a kubernetes pod?

I need to execute a .cql file inside a kubernetes pod. I did not try anything
Aiman Sharief
  • 1
  • 1
0
votes
2 answers

How can I design a table that stores subdomain metadata to avoid large partitions?

i try to design a table in cassandra, but im getting a lot of large partition messages. Any ideas how i could improve this "design" to prevent overloading and still can use a query like this: select * from analytics where domain='test' and tld='com'…
Justus
  • 9
  • 2
0
votes
1 answer

Catching a specific exception on a drop column CQL statement in Clojure

I want to run a drop-column CQL statement on a table that may or may not have that column exist. Ideally I would like to do a if-exists then drop column, but I do not believe CQL supports that. My work around is to catch an invalid query exception,…
BrianN
  • 19
  • 4
1 2 3
…
99 100