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
2 answers

Cassandra database Excepion when performing insert from quarkus application

In our Project we are using Quarkus Version 2.8.0.FINAL and Datastax Version 1.1.1 accessing cassandra database Version 3.11 Wa are getting the following Exception when we perform an insert via…
Andrej Flieger
  • 31
  • 2
0
votes
1 answer

Why does cassandra client driver respond more information than cqlsh

I am using datastax nodejs-driver to get information of a keyspace from cassandra. const results = await client.execute( ` DESC KEYSPACE ${keyspace} ` ); The client.execute method returns an object includes lots of information: ResultSet { …
LCB
  • 971
  • 9
  • 22
0
votes
1 answer

Why am I getting this error when I run the query?

When attempting to perform this query: select race_name from sport_app.month_category_runner where race_type = 'URBAN RACE 10K' and club = 'CORNELLA ATLETIC'; I get the following error: Cannot execute this query as it might involve data filtering…
D. Albarracín
  • 103
  • 4
0
votes
1 answer

How to get incremental data from Apache cassandra?

I want to get incremental data, that is each call to select query should returns new records. For ex. let's say my table has 1 million records and I am using Spring boot application so I don't want to fetch all the records at once. I want the…
RachitSharma
  • 567
  • 4
  • 11
  • 31
0
votes
1 answer

How can I find the maximum value from CQL aggregate?

I am new with CQL, please help! I am trying to find the " Which URL on the website has been accessed the most? How many accesses were made on it?" from a Table, I have created. The IP values are saved as text here. To solve the above question, I am…
krk
  • 37
  • 4
0
votes
1 answer

What is system.size_estimates in cassandra and plausible reasons behind high disk consumption

I've been using cassandra on two nodes where one of them ran out of disk space and went down. When I checked, I've observed the size of size_estimates to be ~30GB. I've removed sstable files from my data directories and restarted the node. Was…
PKS
  • 11
  • 1
  • 2
0
votes
1 answer

Get value from specific map-key in Cassandra

For example. I have a map under the column 'users' in a table called 'table' with primary key 'Id'. If the map looks like this, {{'Phone': '1234567899'}, {'City': 'Dublin'}}, I want to get the value from key 'Phone' for specific 'Id', in Cassandra…
user5836327
  • 9
  • 1
0
votes
1 answer

CQL UPDATE a set with join query

I have to delete few data from a table using CQL based on some condition which will fetch data from another table. But I am unable to form the query. Here is the table details from where I need to delete data : Table Name : xyz_group Columns :…
Som
  • 1,522
  • 1
  • 15
  • 48
0
votes
2 answers

Less rows being inserted by sstableloader in ScyllaDB

I'm trying to migrate data from Cassandra to ScyllaDB from snapshot using sstableloader and data in some tables gets loaded without any error but when verifying count using PySpark, it gives less rows in ScyllaDB than in Cassandra. Help needed!
Varun Nagrare
  • 153
  • 1
  • 11
0
votes
1 answer

search by character ordered by value Cassandra

search by character ordered by value Cassandra: I am currently in the process of mastering cassandra with a first project. This one is a social network. I am working on the search bar to find users in the network. I'm looking for the best db…
Jesver
  • 83
  • 1
  • 6
0
votes
2 answers

Problems performing an update on Cassandra having a compound partitioning key

I have this table in Cassandra: CREATE TABLE wear_dealer.product_color_size_stock ( productcode text, colorcode text, sizecode text, ean text, shortdescription text, stock int, **PRIMARY KEY (productcode, colorcode,…
José Javier Marti Camarasa
  • 1
0
votes
1 answer

Query table based on users local hour, rather than GMT hour (including daylight savings support)

If users want notifications or certain activities triggered based on an hour of the day in their local timezone. You could store each users preferred notification hour in the database, and just poll the table every hour for who wants a notification.…
Jay
  • 19,649
  • 38
  • 121
  • 184
0
votes
1 answer

Neo4j trouble optimizing query with multiple optional matches

I thought I was getting the grasp of neo4j. It turns out I am not. I have a long query I'm running. When I run with any 2 of the optional matches it runs in like 20 seconds. But if I had any third optional match (doesn't seem to matter which one) it…
Derek1st
  • 63
  • 6
0
votes
1 answer

How to get next resultset in Cassandra DB

Table contains more than 100,000 rows. I am trying to get the total row count. I do not want to use async. Statement statement = session.prepare("SELECT user_id from table"); ResultSet resultSet = session.execute(statement); int count =…
Gvtha
  • 1,463
  • 1
  • 11
  • 18
0
votes
1 answer

How to pass WMS cql_filter through Leaflet TimeDimension?

Does anyway know how to pass a WMS cql_filter through a Leaflet TimeDimension? I am using Geoserver and Leaflet, using the Cross Layer filter extension in Geoserver and TimeDimension plugin for Leaflet. I have two point layers, one of parking spaces…
Paul H
  • 1
1 2 3
…
99
100