2,146 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
54
views
The CQF ruler HAPI FHIR server doesn't seem to find the base64 encoded text/cql or text/elm in my Library
Problem
I’ve uploaded multiple Library resources and measures, each containing both text/cql and application/elm+json entries also in the content array. from the HEDIS MY2024 definations
Each Library ...
2
votes
0
answers
76
views
Neo4j complex label expressions inconsistencies
I'm running Neo4j 5.18.1 enterprise edition with a cluster of 6 servers.
I'm running 2 queries on all servers in the cluster, trying to find a specific node.
The node in question has the following ...
0
votes
0
answers
40
views
Is there a clear method of filtering the layer group using the CQL filter of the WMS GetMap service?
We use layer groups of objects of the GeoServer to combine separate layers into a single map to optimize client-side OpenLayers rendering. But we also want to control the layer's visibility and show ...
2
votes
1
answer
105
views
Cassandra sorting issue on updated_at column
I have the following Cassandra table:
K = Partition Key
C = Clustering Key
user_id (text) -- K
folder_id (text) -- C
name (text)
owner (text)
size (text)
updated_at (timestamp)
My use case is to ...
0
votes
1
answer
68
views
Error using Datastax SchemaBuilder for creating Cassandra table in Java
I'm trying to create a Cassandra table from Java code using Datastax's SchemaBuilder class. I'm essentially trying to convert this CQL query:
CREATE TABLE <tablename> (id text, key blob, val ...
0
votes
1
answer
69
views
Cassandra IN clause for a composite primary key
I have a table with composite key:
create table profile
(
id int,
zone text,
data blob,
primary key ((id, zone))
);
And a use case where I need to select many records given ...
0
votes
1
answer
95
views
Generating a hash for Cassandra table data
I wanted to check if there is a way to generate a hash or any kind of unique identifier for all the data in a Cassandra table at a given point of time? I can't find anything to generate a hash ...
1
vote
1
answer
63
views
MAX() function in Cassandra Query Language returns wrong values
I am running the below Cassandra query, for which I am getting the correct maximum value for max_sale_value, but wrong value for the corresponding country column.
I am using Cassandra 5.0.2 with the ...
-1
votes
1
answer
147
views
With no materialized view or secondary index support, does the use of another lookup table have performance implications?
I have 2 questions about AWS Keyspaces.
I have an important table 'posts' with this structure:
CREATE TABLE IF NOT EXISTS social_platform.posts (
id UUID,
user_id UUID,
title TEXT,
...
1
vote
1
answer
106
views
How to properly create a table for user messages?
I have a table with user channels in the Apache Cassandra database. And queries responsible for getting the list of channels and getting data about the channel. One of the queries requires ALLOW ...
1
vote
1
answer
280
views
`gocql: no hosts available in the pool` with AWS Keyspaces
I'm using the gocql package to connect with AWS Keyspaces. Generally, my approach works 95% of the time, but every few days or so I get this error: gocql: no hosts available in the pool. I've followed ...
0
votes
1
answer
331
views
How do I get an accurate count of rows of a large table in ScyllaDB?
I have a large table consisting of about 1B rows in ScyllaDB. I need to get a count of rows present in the table for statistical and verification purposes.
If the consistency level(CL) is set to ONE, ...
2
votes
3
answers
107
views
Is it possible to identify the Cassandra engine/system via CQL?
I tried to identify the engine (Cassandra, Scylla, AstraDB, CosmosDB, Yugabyte, ...) based on Cassandra Query Language (CQL). I focused on tables system.local and system.peers, see the sample:
SELECT ...
2
votes
1
answer
180
views
How to convert the value returned from writetime() into datetime in Scylla CQL?
I would like to convert the integer timestamp returned by writetime() to a readable datetime format in Scylla cqlsh.
After some Googling I found the following answer that works for Cassandra:
...
1
vote
1
answer
145
views
system.local table restrictions - AstraDB Serverless (Cassandra)
I'm trying to execute "toUnixTimestamp(now())" against system.local table (AstraDB Serverless).
It works fine when I execute it inside AstraDB CQL Console: SELECT toUnixTimestamp(now()) FROM ...